/*------------------------------------------------------------
-- サービス契約番号、請求契約番号抽出
-- 課金先スキーマのアンロード
------------------------------------------------------------*/
SELECT
     KK0321.SVC_KEI_NO
    ,KK0321.SEIKY_KEI_NO
FROM
    KK_T_KAKINS KK0321
WHERE
    KK0321.KAKINS_TSTAYMD <= :OPEDATE
    AND KK0321.KAKINS_TENDYMD >= :OPEDATE
    AND KK0321.MK_FLG = '0'