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_F

Line 311: ,ben_pl_f pln

307: ,abr.context_pl_id pl_id
308: ,abr.oipl_id
309: ,pln.pl_typ_id
310: from ben_acty_base_rt_f abr
311: ,ben_pl_f pln
312: ,ben_pl_typ_f typ
313: where abr.element_type_id = p_element_type_id
314: and abr.business_group_id = p_business_group_id
315: and p_effective_date between

Line 361: ,ben_pl_f pln

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);
365:

Line 379: from ben_pl_f pln

375: where pon.opt_id = v_opt_id);
376:
377: cursor c_pln(v_pl_id number) is
378: select pln.object_version_number
379: from ben_pl_f pln
380: where pln.pl_id = v_pl_id
381: and p_effective_date between
382: pln.effective_start_date and pln.effective_end_date
383: and not exists

Line 396: from ben_pl_f pln

392: and p_effective_date between
393: typ.effective_start_date and typ.effective_end_date
394: and not exists
395: (select 'Y'
396: from ben_pl_f pln
397: where pln.pl_typ_id = v_pl_typ_id);
398:
399: cursor c_abr_exst is
400: select abr.acty_base_rt_id

Line 402: ,ben_pl_f pln

398:
399: cursor c_abr_exst is
400: select abr.acty_base_rt_id
401: from ben_acty_base_rt_f abr
402: ,ben_pl_f pln
403: ,ben_pl_typ_f typ
404: where abr.element_type_id = p_element_type_id
405: and abr.context_pl_id = pln.pl_id
406: and pln.pl_typ_id = typ.pl_typ_id