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

Line 91: from ben_oipl_f

87: or
88: (r.oipl_id = p_new_oipl_id)
89: or
90: (r.opt_id = (select opt_id
91: from ben_oipl_f
92: where oipl_id = p_new_oipl_id
93: and p_effective_date between effective_start_date
94: and effective_end_date
95: and business_group_id = p_business_group_id)))

Line 251: from ben_oipl_f

247: or
248: (p.oipl_id = p_new_oipl_id)
249: or
250: (p.opt_id = (select opt_id
251: from ben_oipl_f
252: where oipl_id = p_new_oipl_id
253: and p_effective_date between effective_start_date
254: and effective_end_date
255: and business_group_id = p_business_group_id)))

Line 293: from ben_oipl_f

289: or
290: (p3.oipl_id = p_new_oipl_id)
291: or
292: (p3.opt_id = (select opt_id
293: from ben_oipl_f
294: where oipl_id = p_new_oipl_id
295: and p_effective_date between effective_start_date
296: and effective_end_date
297: and business_group_id = p_business_group_id)))

Line 396: FROM ben_oipl_f oipl,

392: then we do not copy the beneficiaries to the new result.
393: */
394: CURSOR c_waive_pl_opt IS
395: SELECT NULL
396: FROM ben_oipl_f oipl,
397: ben_opt_f opt
398: WHERE oipl.opt_id = opt.opt_id
399: AND oipl.oipl_id = p_new_oipl_id
400: AND p_effective_date BETWEEN oipl.effective_start_date AND oipl.effective_end_date