DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DATE dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 6810: from ben_popl_enrt_typ_cycl_f popl,

6806: epd.rt_strt_dt_cd,
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

Line 6836: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591

6832: epd.rt_strt_dt_cd,
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

Line 6983: from ben_popl_enrt_typ_cycl_f popl,

6979: lee.rt_strt_dt_cd,
6980: lee.rt_strt_dt_rl,
6981: lee.rt_end_dt_cd,
6982: lee.rt_end_dt_rl
6983: from ben_popl_enrt_typ_cycl_f popl,
6984: ben_lee_rsn_f lee,
6985: ben_ler_f ler,
6986: ben_per_in_ler pil
6987: where popl.pl_id = c_pl_id

Line 7013: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591

7009: lee.rt_strt_dt_cd,
7010: lee.rt_strt_dt_rl,
7011: lee.rt_end_dt_cd,
7012: lee.rt_end_dt_rl
7013: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
7014: ben_lee_rsn_f lee,
7015: ben_per_in_ler pil
7016: where popl.pgm_id = c_pgm_id
7017: and c_effective_date between popl.effective_start_date and popl.effective_end_date