DBA Data[Home] [Help]

APPS.HR_FI_UTILITY dependencies on PER_CONTACT_RELATIONSHIPS

Line 605: FROM per_contact_relationships c

601: BEGIN
602:
603: SELECT COUNT(distinct(c.contact_person_id))
604: INTO l_dependent_number
605: FROM per_contact_relationships c
606: WHERE c.person_id = (SELECT b.person_id from per_all_assignments_f b
607: WHERE b.assignment_id = p_assignment_id
608: AND p_process_date between b.effective_start_date AND b.effective_end_date
609: )