DBA Data[Home] [Help]

APPS.PAY_NO_EOY_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 1683: FROM per_all_people_f per

1679: ,p_effective_date IN DATE) IS
1680: SELECT per.full_name
1681: ,per.national_identifier
1682: ,per.employee_number
1683: FROM per_all_people_f per
1684: WHERE per.person_id = p_person_id
1685: AND p_effective_date BETWEEN per.effective_start_date
1686: AND per.effective_end_date;
1687: --