APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_ELIG_PER_ELCTBL_CHC

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 283: from ben_elig_per_elctbl_chc

279: or (asg.assignment_type = 'A'
280: and asg.primary_flag = 'N'
281: and ben_manage_life_events.g_irec_old_ass_rec.assignment_id = asg.assignment_id)--12428282
282: and asg.business_group_id = (select business_group_id
283: from ben_elig_per_elctbl_chc
284: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id )) --10649969
285: and asg.assignment_status_type_id = ast.assignment_status_type_id(+)
286: and ast.per_system_status(+) = 'ACTIVE_ASSIGN' -- Bug 6399423 removed the outer join
287: -- Bug 7728455 Added back the outer join

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 525: ben_elig_per_elctbl_chc epe

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
529: and pil.per_in_ler_id = epe.per_in_ler_id