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_EVALUATE_ELIG_PROFILES dependencies on BEN_OIPL_F

Line 8913: l_oipl_rec ben_oipl_f%rowtype;

8909: l_found_profile varchar2(1) := 'N';
8910: l_pl_rec ben_pl_f%rowtype;
8911: l_pl3_rec ben_pl_f%rowtype;
8912: l_ptip2_rec ben_ptip_f%rowtype;
8913: l_oipl_rec ben_oipl_f%rowtype;
8914: l_plip_rec ben_plip_f%rowtype;
8915: l_ptip_rec ben_ptip_f%rowtype;
8916: --
8917: l_inst_set ben_elig_rl_cache.g_elig_rl_inst_tbl;

Line 9090: from ben_oipl_f oipl,

9086: between pln.effective_start_date and pln.effective_end_date ;
9087: --
9088: cursor c_oipl_pl_typ(c_effective_date date) is
9089: select pln.pl_typ_id
9090: from ben_oipl_f oipl,
9091: ben_pl_f pln
9092: where oipl_id = p_oipl_id
9093: and c_effective_date
9094: between oipl.effective_start_date and oipl.effective_end_date