DBA Data[Home] [Help]

APPS.BEN_UPDATE_LEDGERS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 272: ben_pil_elctbl_chc_popl pel

268: c_effective_date in date,
269: c_prvdd_val in number)is
270: select distinct ann_val, cmcd_val
271: from ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,
272: ben_pil_elctbl_chc_popl pel
273: where ecr.acty_base_rt_id = c_acty_base_rt_id
274: -- make sure we're dealing with the exact same rate
275: and ecr.val = c_prvdd_val
276: and pel.acty_ref_perd_cd = c_acty_ref_perd_cd

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