DBA Data[Home] [Help]

APPS.BEN_ENROLLMENT_RATE_API dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 25: ,ben_elig_per_elctbl_chc epe

21: cursor c_person is
22: select full_name
23: from per_all_people_f per
24: ,ben_per_in_ler pil
25: ,ben_elig_per_elctbl_chc epe
26: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
27: and epe.per_in_ler_id = pil.per_in_ler_id
28: and pil.person_id = per.person_id
29: and p_effective_date between per.EFFECTIVE_START_DATE and per.EFFECTIVE_END_DATE;