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 324: from ben_oipl_f oipl

320: from ben_dsgn_rqmt_f ddr
321: where (ddr.oipl_id = p_oipl_id
322: or ddr.pl_id = p_pl_id
323: or ddr.opt_id = (select oipl.opt_id
324: from ben_oipl_f oipl
325: where oipl.oipl_id = p_oipl_id
326: and oipl.business_group_id =
327: p_business_group_id
328: and c_effective_date

Line 349: from ben_oipl_f oipl

345: and rl.rlshp_typ_cd = p_contact_type
346: and (ddr.oipl_id = p_oipl_id
347: or ddr.pl_id = p_pl_id
348: or ddr.opt_id = (select oipl.opt_id
349: from ben_oipl_f oipl
350: where oipl.oipl_id = p_oipl_id
351: and oipl.business_group_id =
352: p_business_group_id
353: and c_effective_date

Line 380: from ben_oipl_f oipl

376: where ddr.grp_rlshp_cd is null
377: and (ddr.oipl_id = p_oipl_id
378: or ddr.pl_id = p_pl_id
379: or ddr.opt_id = (select oipl.opt_id
380: from ben_oipl_f oipl
381: where oipl.oipl_id = p_oipl_id
382: and oipl.business_group_id =
383: p_business_group_id
384: and c_effective_date

Line 414: from ben_oipl_f oipl

410: and rl.rlshp_typ_cd <> l_contact.contact_type
411: and (ddr.oipl_id = p_oipl_id
412: or ddr.pl_id = p_pl_id
413: or ddr.opt_id = (select oipl.opt_id
414: from ben_oipl_f oipl
415: where oipl.oipl_id = p_oipl_id
416: and oipl.business_group_id =
417: p_business_group_id
418: and c_effective_date

Line 631: from ben_oipl_f oipl

627: (c_effective_date in date
628: )
629: is
630: select oipl.opt_id
631: from ben_oipl_f oipl
632: where oipl.oipl_id = p_oipl_id
633: and c_effective_date
634: between oipl.effective_start_date
635: and oipl.effective_end_date;