APPS.BEN_UPDATE_LEDGERS dependencies on BEN_PRTT_RT_VAL

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

Line 255: from ben_prtt_rt_val prv

251: c_enrt_info_rt_freq_cd in varchar2,
252: c_effective_date in date,
253: c_prvdd_val in number)is
254: select distinct ann_rt_val, cmcd_rt_val
255: from ben_prtt_rt_val prv
256: where prv.rt_val = c_prvdd_val
257: and prv.acty_ref_perd_cd = c_acty_ref_perd_cd
258: and prv.cmcd_ref_perd_cd = c_enrt_info_rt_freq_cd
259: and prv.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id;