APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ELIG_PER_F

Line 1977: FROM ben_elig_per_f new_pep, ben_elig_per_f old_pep

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