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 376: ben_pl_f pln

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

Line 410: ben_pl_f pln

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

Line 627: ben_pl_f pln

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