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_PL_TYP_OPT_TYP_F

Line 55: from ben_pl_typ_opt_typ_f pon

51: and opt.name = v_name;
52:
53: cursor c_pon(v_opt_id number, v_pl_typ_id number) is
54: select pon.pl_typ_opt_typ_id
55: from ben_pl_typ_opt_typ_f pon
56: where pon.opt_id = v_opt_id
57: and pon.pl_typ_id = v_pl_typ_id
58: and p_effective_date between
59: pon.effective_start_date and pon.effective_end_date;

Line 353: from ben_pl_typ_opt_typ_f pon

349: cursor c_pon(v_opt_id number,
350: v_pl_typ_id number) is
351: select pon.pl_typ_opt_typ_id
352: ,pon.object_version_number
353: from ben_pl_typ_opt_typ_f pon
354: where pon.opt_id = v_opt_id
355: and pon.pl_typ_id = v_pl_typ_id
356: and p_effective_date between
357: pon.effective_start_date and pon.effective_end_date

Line 374: from ben_pl_typ_opt_typ_f pon

370: and p_effective_date between
371: opt.effective_start_date and opt.effective_end_date
372: and not exists
373: (select 'Y'
374: from ben_pl_typ_opt_typ_f pon
375: where pon.opt_id = v_opt_id);
376:
377: cursor c_pln(v_pl_id number) is
378: select pln.object_version_number