DBA Data[Home] [Help]

APPS.BEN_UPDATE_LEDGERS dependencies on BEN_PGM_F

Line 201: from ben_prtt_enrt_rslt_f pen, ben_pgm_f pgm

197: cursor c_rslt (c_prtt_enrt_rslt_id in number,
198: c_effective_date in date) is
199: select distinct pen.person_id, pen.pgm_id,
200: pgm.acty_ref_perd_cd, pgm.enrt_info_rt_freq_cd
201: from ben_prtt_enrt_rslt_f pen, ben_pgm_f pgm
202: where pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
203: and pen.pgm_id = pgm.pgm_id
204: and pen.prtt_enrt_rslt_stat_cd is null
205: and c_effective_date between