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 4288: ben_pl_regn_f plrg,

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

Line 4333: ben_pl_regn_f plrg,

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

Line 4415: ,ben_pl_regn_f plrg

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