APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 383: from ben_elig_per_elctbl_chc epe,ben_per_in_ler pil

379: epe.pgm_id,
380: epe.business_group_id,
381: epe.per_in_ler_id,
382: pil.ler_id
383: from ben_elig_per_elctbl_chc epe,ben_per_in_ler pil
384: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
385: and epe.per_in_ler_id = pil.per_in_ler_id;
386: --
387: -- FONM

Line 491: ben_elig_per_elctbl_chc epe

487: cursor c_enrt_prem is
488: select ecr.val
489: from ben_enrt_prem ecr,
490: ben_per_in_ler pil,
491: ben_elig_per_elctbl_chc epe
492: where ecr.actl_prem_id = l_actl_prem_id
493: and ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
494: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
495: and pil.per_in_ler_id = epe.per_in_ler_id