APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_PER_IN_LER

Line 273: from ben_ler_f ler, ben_per_in_ler pil, ben_elig_per_elctbl_chc epe

269: where asg.person_id = p_person_id
270: and ((asg.assignment_type <> 'C'
271: and asg.primary_flag = 'Y'
272: and 'IREC' <> ( select ler.typ_cd
273: from ben_ler_f ler, ben_per_in_ler pil, ben_elig_per_elctbl_chc epe
274: where epe.per_in_ler_id = pil.per_in_ler_id
275: and pil.ler_id = ler.ler_id
276: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
277: and cv_effective_date between ler.effective_start_date and ler.effective_end_date--12810996

Line 417: from ben_elig_per_elctbl_chc epe,ben_per_in_ler pil

413: epe.pgm_id,
414: epe.business_group_id,
415: epe.per_in_ler_id,
416: pil.ler_id
417: from ben_elig_per_elctbl_chc epe,ben_per_in_ler pil
418: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
419: and epe.per_in_ler_id = pil.per_in_ler_id;
420: --
421: -- FONM

Line 524: ben_per_in_ler pil,

520: --
521: cursor c_enrt_prem is
522: select ecr.val
523: from ben_enrt_prem ecr,
524: ben_per_in_ler pil,
525: ben_elig_per_elctbl_chc epe
526: where ecr.actl_prem_id = l_actl_prem_id
527: and ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
528: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id