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.HRI_APL_DGNSTC_OPEN_ENRT dependencies on BEN_PLIP_F

Line 79: ben_plip_f cpp

75: NULL col5
76: FROM ben_pgm_f pgm,
77: ben_popl_actn_typ_f pat,
78: ben_actn_typ_tl eat,
79: ben_plip_f cpp
80: WHERE pgm.pgm_id = cpp.pgm_id
81: AND cpp.pl_id = pat.pl_id
82: AND eat.actn_typ_id = pat.actn_typ_id
83: AND :p_end_date BETWEEN pgm.effective_start_date

Line 201: FROM ben_popl_actn_typ_f pat, ben_plip_f cpp

197: AND :p_end_date BETWEEN pat.effective_start_date
198: AND pat.effective_end_date)
199: AND NOT EXISTS (
200: SELECT 1
201: FROM ben_popl_actn_typ_f pat, ben_plip_f cpp
202: WHERE cpp.pgm_id = pgm.pgm_id
203: AND pat.pl_id = cpp.pl_id
204: AND :p_end_date BETWEEN pat.effective_start_date
205: AND pat.effective_end_date

Line 268: FROM ben_pgm_f pgm, ben_plip_f cpp, ben_pl_f pln

264: pln.NAME PLN_NAME,
265: NULL col3,
266: NULL col4,
267: NULL col5
268: FROM ben_pgm_f pgm, ben_plip_f cpp, ben_pl_f pln
269: WHERE pgm.pgm_id = cpp.pgm_id
270: AND cpp.pl_id = pln.pl_id
271: AND pgm.pgm_typ_cd IN (''CORE'', ''FLEX'', ''FPC'', ''OTHER'')
272: AND pln.invk_flx_cr_pl_flag = ''N''

Line 315: FROM ben_plip_f cpp, ben_pl_f pln

311: --
312: CURSOR c_pln
313: IS
314: SELECT null
315: FROM ben_plip_f cpp, ben_pl_f pln
316: WHERE cpp.pgm_id = cv_pgm_id
317: AND cpp.pl_id = pln.pl_id
318: AND pln.invk_flx_cr_pl_flag = 'N'
319: AND pln.imptd_incm_calc_cd IS NULL