DBA Data[Home] [Help]

APPS.BEN_UPDATE_LEDGERS dependencies on BEN_ENRT_BNFT

Line 296: ben_pil_elctbl_chc_popl pel, ben_enrt_bnft enb

292: c_enrt_info_rt_freq_cd in varchar2,
293: c_effective_date in date)is
294: select distinct epe.elig_per_elctbl_chc_id, ecr.enrt_rt_id, pil.lf_evt_ocrd_dt
295: from ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
296: ben_pil_elctbl_chc_popl pel, ben_enrt_bnft enb
297: where ecr.acty_base_rt_id = c_acty_base_rt_id
298: -- make sure we're dealing with the exact same rate
299: and pel.acty_ref_perd_cd = c_acty_ref_perd_cd
300: and ecr.cmcd_acty_ref_perd_cd = c_enrt_info_rt_freq_cd