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_DETERMINE_CHC_CTFN dependencies on BEN_PL_F

Line 378: ben_pl_f pln

374: --
375: cursor c_ler_rstrn is
376: select rstrn.ler_bnft_rstrn_id
377: from ben_ler_bnft_rstrn_f rstrn,
378: ben_pl_f pln
379: where rstrn.pl_id = p_pl_id
380: and rstrn.ler_id = p_ler_id
381: and rstrn.pl_id = pln.pl_id
382: and pln.bnft_or_option_rstrctn_cd = 'OPT'

Line 412: ben_pl_f pln

408: ctfn.ctfn_rqd_when_rl,
409: pln.susp_if_ctfn_not_prvd_flag,
410: pln.ctfn_determine_cd
411: from ben_bnft_rstrn_ctfn_f ctfn,
412: ben_pl_f pln
413: where pln.pl_id = p_pl_id
414: and pln.bnft_or_option_rstrctn_cd = 'OPT'
415: and pln.business_group_id = p_business_group_id
416: and pln.pl_id = ctfn.pl_id

Line 629: ben_pl_f pln

625: ecf.ctfn_rqd_when_rl,
626: pln.susp_if_ctfn_not_prvd_flag,
627: pln.ctfn_determine_cd
628: from ben_enrt_ctfn_f ecf,
629: ben_pl_f pln
630: where ecf.pl_id = l_pl_id
631: and pln.pl_id = ecf.pl_id
632: and ecf.business_group_id = l_business_group_id
633: and p_effective_date