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_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PLIP_F

Line 752: from ben_plip_f plip,

748: p_effective_date between
749: effective_start_date and effective_end_date;
750: cursor c_plip(p_effective_date date) is
751: select pl.pl_typ_id , pl.pl_id
752: from ben_plip_f plip,
753: ben_pl_f pl
754: where plip.plip_id=p_plip_id and
755: plip.business_group_id=p_business_group_id and
756: p_effective_date between

Line 5524: from ben_plip_f plip

5520: between ptip.effective_start_date and ptip.effective_end_date ;
5521: --
5522: cursor c_plip is
5523: select pl_id
5524: from ben_plip_f plip
5525: where plip.plip_id = p_plip_id
5526: and nvl(g_fonm_cvg_strt_dt,p_effective_date)
5527: between plip.effective_start_date
5528: and plip.effective_end_date;