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.

APPS.BEN_DETERMINE_DATE dependencies on BEN_PLIP_F

Line 6858: from ben_plip_f plp

6854: plp.rt_strt_dt_cd,
6855: plp.rt_strt_dt_rl,
6856: plp.rt_end_dt_cd,
6857: plp.rt_end_dt_rl
6858: from ben_plip_f plp
6859: where plp.plip_id=c_plip_id
6860: and c_effective_date
6861: between plp.effective_start_date and plp.effective_end_date
6862: union

Line 7038: from ben_plip_f plp

7034: plp.rt_strt_dt_cd,
7035: plp.rt_strt_dt_rl,
7036: plp.rt_end_dt_cd,
7037: plp.rt_end_dt_rl
7038: from ben_plip_f plp
7039: where plp.plip_id=c_plip_id
7040: and c_effective_date
7041: between plp.effective_start_date and plp.effective_end_date
7042: and ( enrt_cvg_strt_dt_cd is not null

Line 7193: from ben_plip_f plp

7189: ,c_effective_date in date
7190: )
7191: is
7192: select plp.plip_id
7193: from ben_plip_f plp
7194: where plp.pgm_id = c_pgm_id
7195: and plp.pl_id = c_pl_id
7196: and c_effective_date
7197: between plp.effective_start_date and plp.effective_end_date;