APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ELIG_PER_F

Line 1974: FROM ben_elig_per_f new_pep, ben_elig_per_f old_pep

1970: CURSOR get_pep
1971: IS
1972: SELECT new_pep.elig_per_id, new_pep.object_version_number,
1973: MIN (old_pep.effective_start_date) - 1 end_date
1974: FROM ben_elig_per_f new_pep, ben_elig_per_f old_pep
1975: WHERE new_pep.person_id = p_person_id
1976: AND old_pep.person_id = new_pep.person_id
1977: AND new_pep.per_in_ler_id = p_per_in_ler_id
1978: AND old_pep.per_in_ler_id = new_pep.per_in_ler_id