DBA Data[Home] [Help]

APPS.BEN_DETERMINE_CHC_CTFN dependencies on BEN_ENRT_CTFN_F

Line 610: from ben_enrt_ctfn_f ecf,

606: ecf.rqd_flag,
607: ecf.ctfn_rqd_when_rl,
608: cop.susp_if_ctfn_not_prvd_flag,
609: cop.ctfn_determine_cd
610: from ben_enrt_ctfn_f ecf,
611: ben_oipl_f cop
612: where ecf.oipl_id = l_oipl_id
613: and cop.oipl_id = ecf.oipl_id
614: and ecf.business_group_id = l_business_group_id

Line 628: from ben_enrt_ctfn_f ecf,

624: ecf.rqd_flag,
625: ecf.ctfn_rqd_when_rl,
626: pln.susp_if_ctfn_not_prvd_flag,
627: pln.ctfn_determine_cd
628: from ben_enrt_ctfn_f ecf,
629: ben_pl_f pln
630: where ecf.pl_id = l_pl_id
631: and pln.pl_id = ecf.pl_id
632: and ecf.business_group_id = l_business_group_id

Line 954: from ben_enrt_ctfn_f ec

950: and lec.ler_rqrs_enrt_ctfn_id = lre.ler_rqrs_enrt_ctfn_id
951: and lec.enrt_ctfn_typ_cd = p_enrt_ctfn_typ_cd
952: union
953: select 'Y'
954: from ben_enrt_ctfn_f ec
955: where ec.pl_id = p_pl_id
956: and p_effective_date between ec.effective_start_date
957: and ec.effective_end_date
958: and ec.enrt_ctfn_typ_cd = p_enrt_ctfn_typ_cd ;