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

Line 297: select opt_id from ben_oipl_f oipl

293: --
294: -- Define cursors
295: --
296: cursor c_opt is
297: select opt_id from ben_oipl_f oipl
298: where oipl.oipl_id = p_oipl_id
299: and oipl.business_group_id = p_business_group_id
300: and l_lf_evt_ocrd_dt
301: between oipl.effective_start_date

Line 581: from ben_oipl_f oipl

577: from ben_dsgn_rqmt_f ddr
578: where (ddr.oipl_id = p_oipl_id
579: or ddr.pl_id = p_pl_id
580: or ddr.opt_id = (select oipl.opt_id
581: from ben_oipl_f oipl
582: where oipl.oipl_id = p_oipl_id
583: and oipl.business_group_id =
584: p_business_group_id
585: and l_lf_evt_ocrd_dt

Line 642: ben_oipl_f oipl,

638: select decode(pln.invk_dcln_prtn_pl_flag,
639: 'N', nvl(opt.invk_wv_opt_flag,'N'),
640: 'Y') dcln_pl_opt_flag
641: from ben_pl_f pln,
642: ben_oipl_f oipl,
643: ben_opt_f opt
644: where pln.pl_id = p_pl_id
645: and oipl.oipl_id (+) = p_oipl_id
646: and oipl.pl_id (+) = pln.pl_id