DBA Data[Home] [Help]

APPS.HRI_APL_DGNSTC_OPEN_ENRT dependencies on BEN_PL_F

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