APPS.HR_FI_UTILITY dependencies on PER_CONTACT_RELATIONSHIPS

Line 649: FROM per_contact_relationships c

645: BEGIN
646:
647: SELECT COUNT(distinct(c.contact_person_id))
648: INTO l_dependent_number
649: FROM per_contact_relationships c
650: WHERE c.person_id = (SELECT b.person_id from per_all_assignments_f b
651: WHERE b.assignment_id = p_assignment_id
652: AND p_process_date between b.effective_start_date AND b.effective_end_date
653: )