DBA Data[Home] [Help]

APPS.HR_SA_VALIDATE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 710: FROM per_all_assignments_f

706: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
707:
708: SELECT person_id
709: INTO l_person_id
710: FROM per_all_assignments_f
711: WHERE assignment_id = p_assignment_id
712: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
713: open csr_nationality;
714: fetch csr_nationality into l_nationality;