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

Line 317: from ben_oipl_f oipl

313: from ben_dsgn_rqmt_f ddr
314: where (ddr.oipl_id = p_oipl_id
315: or ddr.pl_id = p_pl_id
316: or ddr.opt_id = (select oipl.opt_id
317: from ben_oipl_f oipl
318: where oipl.oipl_id = p_oipl_id
319: and oipl.business_group_id =
320: p_business_group_id
321: and c_effective_date

Line 342: from ben_oipl_f oipl

338: and rl.rlshp_typ_cd = p_contact_type
339: and (ddr.oipl_id = p_oipl_id
340: or ddr.pl_id = p_pl_id
341: or ddr.opt_id = (select oipl.opt_id
342: from ben_oipl_f oipl
343: where oipl.oipl_id = p_oipl_id
344: and oipl.business_group_id =
345: p_business_group_id
346: and c_effective_date

Line 373: from ben_oipl_f oipl

369: where ddr.grp_rlshp_cd is null
370: and (ddr.oipl_id = p_oipl_id
371: or ddr.pl_id = p_pl_id
372: or ddr.opt_id = (select oipl.opt_id
373: from ben_oipl_f oipl
374: where oipl.oipl_id = p_oipl_id
375: and oipl.business_group_id =
376: p_business_group_id
377: and c_effective_date

Line 407: from ben_oipl_f oipl

403: and rl.rlshp_typ_cd <> l_contact.contact_type
404: and (ddr.oipl_id = p_oipl_id
405: or ddr.pl_id = p_pl_id
406: or ddr.opt_id = (select oipl.opt_id
407: from ben_oipl_f oipl
408: where oipl.oipl_id = p_oipl_id
409: and oipl.business_group_id =
410: p_business_group_id
411: and c_effective_date

Line 623: from ben_oipl_f oipl

619: (c_effective_date in date
620: )
621: is
622: select oipl.opt_id
623: from ben_oipl_f oipl
624: where oipl.oipl_id = p_oipl_id
625: and c_effective_date
626: between oipl.effective_start_date
627: and oipl.effective_end_date;