DBA Data[Home] [Help]

APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on BEN_LER_F

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