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

Line 63: from ben_oipl_f oipl

59: pon.effective_start_date and pon.effective_end_date;
60:
61: cursor c_max_oipl is
62: select max(oipl.ordr_num)
63: from ben_oipl_f oipl
64: where oipl.pl_id = l_pl_id
65: and p_effective_date between
66: oipl.effective_start_date and oipl.effective_end_date;
67:

Line 344: from ben_oipl_f oipl

340:
341: cursor c_oipl(v_oipl_id number) is
342: select oipl.object_version_number
343: ,oipl.opt_id
344: from ben_oipl_f oipl
345: where oipl.oipl_id = v_oipl_id
346: and p_effective_date between
347: oipl.effective_start_date and oipl.effective_end_date;
348:

Line 360: from ben_oipl_f oipl

356: and p_effective_date between
357: pon.effective_start_date and pon.effective_end_date
358: and not exists
359: (select 'Y'
360: from ben_oipl_f oipl
361: ,ben_pl_f pln
362: where oipl.opt_id = v_opt_id
363: and oipl.pl_id = pln.pl_id
364: and pln.pl_typ_id = v_pl_typ_id);

Line 385: from ben_oipl_f oipl

381: and p_effective_date between
382: pln.effective_start_date and pln.effective_end_date
383: and not exists
384: (select 'Y'
385: from ben_oipl_f oipl
386: where oipl.pl_id = v_pl_id);
387:
388: cursor c_typ(v_pl_typ_id number) is
389: select typ.object_version_number