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_F

Line 312: ,ben_pl_typ_f typ

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
316: abr.effective_start_date and abr.effective_end_date

Line 390: from ben_pl_typ_f typ

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
390: from ben_pl_typ_f typ
391: where typ.pl_typ_id = v_pl_typ_id
392: and p_effective_date between
393: typ.effective_start_date and typ.effective_end_date
394: and not exists

Line 403: ,ben_pl_typ_f typ

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
407: and typ.opt_typ_cd = 'ICM';