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 166: from ben_oipl_f

162: or
163: (p.oipl_id = p_new_oipl_id)
164: or
165: (p.opt_id = (select opt_id
166: from ben_oipl_f
167: where oipl_id = p_new_oipl_id
168: and p_effective_date between effective_start_date
169: and effective_end_date
170: and business_group_id = p_business_group_id)))

Line 208: from ben_oipl_f

204: or
205: (p3.oipl_id = p_new_oipl_id)
206: or
207: (p3.opt_id = (select opt_id
208: from ben_oipl_f
209: where oipl_id = p_new_oipl_id
210: and p_effective_date between effective_start_date
211: and effective_end_date
212: and business_group_id = p_business_group_id)))

Line 311: FROM ben_oipl_f oipl,

307: then we do not copy the beneficiaries to the new result.
308: */
309: CURSOR c_waive_pl_opt IS
310: SELECT NULL
311: FROM ben_oipl_f oipl,
312: ben_opt_f opt
313: WHERE oipl.opt_id = opt.opt_id
314: AND oipl.oipl_id = p_new_oipl_id
315: AND p_effective_date BETWEEN oipl.effective_start_date AND oipl.effective_end_date