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_GENERATE_DPNT_COMM dependencies on BEN_PL_REGN_F

Line 4289: ben_pl_regn_f plrg,

4285: select pen.pgm_id, pen.pl_typ_id, max(pen.enrt_cvg_thru_dt)
4286: from ben_elig_cvrd_dpnt_f pdp,
4287: ben_prtt_enrt_rslt_f pen,
4288: ben_pl_f pln,
4289: ben_pl_regn_f plrg,
4290: ben_regn_f regn,
4291: ben_oipl_f cop,
4292: ben_opt_f opt
4293: where pdp.per_in_ler_id = p_per_in_ler_id

Line 4334: ben_pl_regn_f plrg,

4330: select max(pen.enrt_cvg_thru_dt)
4331: from ben_elig_cvrd_dpnt_f pdp,
4332: ben_prtt_enrt_rslt_f pen,
4333: ben_pl_f pln,
4334: ben_pl_regn_f plrg,
4335: ben_regn_f regn,
4336: ben_oipl_f cop,
4337: ben_opt_f opt
4338: where pdp.effective_start_date = p_effective_date

Line 4416: ,ben_pl_regn_f plrg

4412: from ben_prtt_enrt_rslt_f pen
4413: ,ben_pl_f pln
4414: ,ben_oipl_f cop
4415: ,ben_opt_f opt
4416: ,ben_pl_regn_f plrg
4417: ,ben_regn_f regn
4418: where pen.person_id = p_person_id
4419: and pen.prtt_enrt_rslt_stat_cd is null
4420: and pen.pl_typ_id = l_pl_typ_id