APPS.HR_DOCUMENT_EXTRA_INFO_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 1168: from per_all_assignments_f asg

1164: is
1165: --
1166: cursor c_reviewer (p_person_id varchar2, p_eff_date date) is
1167: select asg.supervisor_id
1168: from per_all_assignments_f asg
1169: where asg.person_id = p_person_id
1170: and p_eff_date between asg.effective_start_date and asg.effective_end_date
1171: and asg.primary_flag = 'Y'
1172: and asg.assignment_type in ('E','C');