DBA Data[Home] [Help]

APPS.GHR_PER_SUM dependencies on PER_PEOPLE_F

Line 732: ,per_people_f per

728: SELECT per.date_of_birth
729: ,ast.per_system_status
730: FROM per_assignment_status_types ast
731: ,per_assignments_f asg
732: ,per_people_f per
733: WHERE asg.assignment_id = p_assignment_id
734: AND asg.person_id = per.person_id
735: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
736: AND ast.assignment_status_type_id = asg.assignment_status_type_id