APPS.BEN_DETERMINE_DATE dependencies on BEN_ENRT_PERD_FOR_PL_F

Line 6792: from ben_enrt_perd_for_pl_f epp

6788: epp.rt_strt_dt_cd,
6789: epp.rt_strt_dt_rl,
6790: epp.rt_end_dt_cd,
6791: epp.rt_end_dt_rl
6792: from ben_enrt_perd_for_pl_f epp
6793: where epp.ENRT_PERD_FOR_PL_ID = c_epfp_id
6794: and c_effective_date
6795: between epp.effective_start_date and epp.effective_end_date
6796: union

Line 6960: from ben_enrt_perd_for_pl_f epp

6956: epp.rt_strt_dt_cd,
6957: epp.rt_strt_dt_rl,
6958: epp.rt_end_dt_cd,
6959: epp.rt_end_dt_rl
6960: from ben_enrt_perd_for_pl_f epp
6961: where epp.ENRT_PERD_FOR_PL_ID=c_epfp_id
6962: and c_effective_date
6963: between epp.effective_start_date and epp.effective_end_date
6964: and ( enrt_cvg_strt_dt_cd is not null

Line 7206: from ben_enrt_perd_for_pl_f epfp

7202: ,c_effective_date in date
7203: )
7204: is
7205: select epfp.ENRT_PERD_FOR_PL_ID
7206: from ben_enrt_perd_for_pl_f epfp
7207: where epfp.lee_rsn_id = c_lee_rsn_id
7208: and epfp.pl_id = c_pl_id
7209: and c_effective_date
7210: between epfp.effective_start_date and epfp.effective_end_date;

Line 7219: from ben_enrt_perd_for_pl_f epfp

7215: ,c_effective_date in date
7216: )
7217: is
7218: select epfp.ENRT_PERD_FOR_PL_ID
7219: from ben_enrt_perd_for_pl_f epfp
7220: where epfp.enrt_perd_id = c_enrt_perd_id
7221: and epfp.pl_id = c_pl_id
7222: and c_effective_date
7223: between epfp.effective_start_date and epfp.effective_end_date;

Line 7239: from ben_enrt_perd_for_pl_f epp

7235: epp.rt_strt_dt_cd,
7236: epp.rt_strt_dt_rl,
7237: epp.rt_end_dt_cd,
7238: epp.rt_end_dt_rl
7239: from ben_enrt_perd_for_pl_f epp
7240: where epp.ENRT_PERD_FOR_PL_ID=c_epfp_id
7241: and c_effective_date
7242: between epp.effective_start_date and epp.effective_end_date
7243: and ( enrt_cvg_strt_dt_cd is not null