#-----------------------------------------------------------
#--NTT‰µ—¿‹àƒR�[ƒX(KK_M_NTTORS_PCRS-CH_SELECT_001)
#--�y“à—e�z
#--ID”Ô�†Œv�A—¿‹à“à–ó—¿‹àƒOƒ‹�[ƒvŒv‚ðŽæ“¾‚·‚é�B
#--�yŒŸ�õ�ðŒ��z
#--NTT‰µƒT�[ƒrƒXŽí•Ê
#--�y’Š�o‘Î�Û�z
#--ˆê——
#-----------------------------------------------------------

--KEY:CH_SELECT_001

SELECT
  KK3521.ID_NO_KEI
 ,KK3521.PRU_PRGP_KEI
FROM
  KK_M_NTTORS_PCRS KK3521
WHERE
  KK3521.NTTORS_SVC_SBT = ? 
AND KK3521.NTT_OROSI_SVC_TSTAYMD <= ?
AND KK3521.NTT_OROSI_SVC_TENDYMD >= ?
AND KK3521.MK_FLG = '0'

#-