eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BEN_DETERMINE_DATE dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 6989: from ben_popl_enrt_typ_cycl_f popl,

6985: epd.rt_strt_dt_cd,
6986: epd.rt_strt_dt_rl,
6987: epd.rt_end_dt_cd,
6988: epd.rt_end_dt_rl
6989: from ben_popl_enrt_typ_cycl_f popl,
6990: ben_enrt_perd epd,
6991: ben_per_in_ler pil
6992: where popl.pl_id = c_pl_id
6993: and epd.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id

Line 7015: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591

7011: epd.rt_strt_dt_cd,
7012: epd.rt_strt_dt_rl,
7013: epd.rt_end_dt_cd,
7014: epd.rt_end_dt_rl
7015: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
7016: ben_enrt_perd epd,
7017: ben_per_in_ler pil
7018: where popl.pgm_id = c_pgm_id
7019: and epd.popl_enrt_typ_cycl_id = popl.popl_enrt_typ_cycl_id

Line 7162: from ben_popl_enrt_typ_cycl_f popl,

7158: lee.rt_strt_dt_cd,
7159: lee.rt_strt_dt_rl,
7160: lee.rt_end_dt_cd,
7161: lee.rt_end_dt_rl
7162: from ben_popl_enrt_typ_cycl_f popl,
7163: ben_lee_rsn_f lee,
7164: ben_ler_f ler,
7165: ben_per_in_ler pil
7166: where popl.pl_id = c_pl_id

Line 7192: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591

7188: lee.rt_strt_dt_cd,
7189: lee.rt_strt_dt_rl,
7190: lee.rt_end_dt_cd,
7191: lee.rt_end_dt_rl
7192: from ben_popl_enrt_typ_cycl_f popl, -- start 4356591
7193: ben_lee_rsn_f lee,
7194: ben_per_in_ler pil
7195: where popl.pgm_id = c_pgm_id
7196: and c_effective_date between popl.effective_start_date and popl.effective_end_date