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 751: from ben_plip_f plip,

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

Line 5523: from ben_plip_f plip

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