APPS.BEN_UPDATE_LEDGERS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 24: ben_prtt_enrt_rslt_f pen

20: bpl.object_version_number, bpl.per_in_ler_id,
21: bpl.frftd_val, bpl.used_val, bpl.prvdd_val, bpl.cash_recd_val, bpl.rld_up_val
22: from ben_bnft_prvdd_ldgr_f bpl,
23: ben_per_in_ler pil,
24: ben_prtt_enrt_rslt_f pen
25: where (bpl.acty_ref_perd_cd is null or
26: (bpl.used_val is not null and bpl.cmcd_used_val is null))
27: and bpl.per_in_ler_id = pil.per_in_ler_id
28: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

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

Line 233: from ben_prtt_rt_val prv, ben_prtt_enrt_rslt_f pen

229: c_enrt_info_rt_freq_cd in varchar2,
230: c_effective_date in date,
231: c_used_val in number)is
232: select distinct ann_rt_val, cmcd_rt_val
233: from ben_prtt_rt_val prv, ben_prtt_enrt_rslt_f pen
234: where prv.acty_base_rt_id = c_acty_base_rt_id
235: -- make sure we're dealing with the exact same rate
236: and prv.rt_val = c_used_val
237: and prv.acty_ref_perd_cd = c_acty_ref_perd_cd