eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_UPDATE_LEDGERS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 271: from ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,

267: c_enrt_info_rt_freq_cd in varchar2,
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

Line 295: from ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,

291: c_acty_ref_perd_cd in varchar2,
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

Line 318: from ben_enrt_rt ecr, ben_elig_per_elctbl_chc epe, ben_per_in_ler pil,

314: cursor get_flex_shell_rt(c_per_in_ler_id in number,
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'