DBA Data[Home] [Help]

APPS.HR_SA_VALIDATE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 707: FROM per_all_assignments_f

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