DBA Data[Home] [Help]

APPS.BEN_UPDATE_LEDGERS dependencies on BEN_ACTY_BASE_RT_F

Line 319: ben_acty_base_rt_f abr

315: c_pgm_id in number) is
316: select ecr.enrt_rt_id, abr.acty_base_rt_id, abr.element_type_id,
317: epe.elig_per_elctbl_chc_id , pil.lf_evt_ocrd_dt
318: from ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
319: ben_acty_base_rt_f abr
320: where epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
321: and epe.pgm_id = c_pgm_id
322: and epe.comp_lvl_cd = 'PLANFC'
323: and pil.per_in_ler_id = epe.per_in_ler_id

Line 333: from ben_acty_base_rt_f abr

329: --
330: --GEVITY
331: cursor c_abr(cv_acty_base_rt_id number)
332: is select rate_periodization_rl
333: from ben_acty_base_rt_f abr
334: where abr.acty_base_rt_id = cv_acty_base_rt_id
335: and p_effective_start_date between abr.effective_start_date
336: and abr.effective_end_date ;
337: --