APPS.BEN_DETERMINE_DATE dependencies on BEN_ENRT_PERD_FOR_PL_F

Line 6971: from ben_enrt_perd_for_pl_f epp

6967: epp.rt_strt_dt_cd,
6968: epp.rt_strt_dt_rl,
6969: epp.rt_end_dt_cd,
6970: epp.rt_end_dt_rl
6971: from ben_enrt_perd_for_pl_f epp
6972: where epp.ENRT_PERD_FOR_PL_ID = c_epfp_id
6973: and c_effective_date
6974: between epp.effective_start_date and epp.effective_end_date
6975: union

Line 7139: from ben_enrt_perd_for_pl_f epp

7135: epp.rt_strt_dt_cd,
7136: epp.rt_strt_dt_rl,
7137: epp.rt_end_dt_cd,
7138: epp.rt_end_dt_rl
7139: from ben_enrt_perd_for_pl_f epp
7140: where epp.ENRT_PERD_FOR_PL_ID=c_epfp_id
7141: and c_effective_date
7142: between epp.effective_start_date and epp.effective_end_date
7143: and ( enrt_cvg_strt_dt_cd is not null

Line 7385: from ben_enrt_perd_for_pl_f epfp

7381: ,c_effective_date in date
7382: )
7383: is
7384: select epfp.ENRT_PERD_FOR_PL_ID
7385: from ben_enrt_perd_for_pl_f epfp
7386: where epfp.lee_rsn_id = c_lee_rsn_id
7387: and epfp.pl_id = c_pl_id
7388: and c_effective_date
7389: between epfp.effective_start_date and epfp.effective_end_date;

Line 7398: from ben_enrt_perd_for_pl_f epfp

7394: ,c_effective_date in date
7395: )
7396: is
7397: select epfp.ENRT_PERD_FOR_PL_ID
7398: from ben_enrt_perd_for_pl_f epfp
7399: where epfp.enrt_perd_id = c_enrt_perd_id
7400: and epfp.pl_id = c_pl_id
7401: and c_effective_date
7402: between epfp.effective_start_date and epfp.effective_end_date;

Line 7418: from ben_enrt_perd_for_pl_f epp

7414: epp.rt_strt_dt_cd,
7415: epp.rt_strt_dt_rl,
7416: epp.rt_end_dt_cd,
7417: epp.rt_end_dt_rl
7418: from ben_enrt_perd_for_pl_f epp
7419: where epp.ENRT_PERD_FOR_PL_ID=c_epfp_id
7420: and c_effective_date
7421: between epp.effective_start_date and epp.effective_end_date
7422: and ( enrt_cvg_strt_dt_cd is not null