DBA Data[Home] [Help]

APPS.HR_NO_VALIDATE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1456: from per_all_people_f papf, per_all_assignments_f paaf

1452: ) IS
1453:
1454: CURSOR get_person_details (p_assignment_id NUMBER) IS
1455: select papf.date_of_birth, papf.start_date
1456: from per_all_people_f papf, per_all_assignments_f paaf
1457: where papf.per_information_category ='NO'
1458: and paaf.PERSON_ID = papf.PERSON_ID
1459: and paaf.ASSIGNMENT_ID = p_assignment_id
1460: and p_effective_date BETWEEN paaf.EFFECTIVE_START_DATE and paaf.EFFECTIVE_END_DATE