APPS.BEN_DETERMINE_DATE dependencies on BEN_ENRT_PERD

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 6811: ben_enrt_perd epd,

6807: epd.rt_strt_dt_rl,
6808: epd.rt_end_dt_cd,
6809: epd.rt_end_dt_rl
6810: from ben_popl_enrt_typ_cycl_f popl,
6811: ben_enrt_perd epd,
6812: ben_per_in_ler pil
6813: where popl.pl_id = c_pl_id
6814: and epd.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
6815: and pil.per_in_ler_id = c_per_in_ler_id

Line 6837: ben_enrt_perd epd,

6833: epd.rt_strt_dt_rl,
6834: epd.rt_end_dt_cd,
6835: epd.rt_end_dt_rl
6836: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
6837: ben_enrt_perd epd,
6838: ben_per_in_ler pil
6839: where popl.pgm_id = c_pgm_id
6840: and epd.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id
6841: and pil.per_in_ler_id = c_per_in_ler_id

Line 6918: from ben_enrt_perd

6914: rt_strt_dt_cd,
6915: rt_strt_dt_rl,
6916: rt_end_dt_cd,
6917: rt_end_dt_rl
6918: from ben_enrt_perd
6919: where enrt_perd_id=l_enrt_perd_id and
6920: business_group_id =p_business_group_id
6921: union
6922: select '4' order_number,

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