APPS.HR_PROCESS_EIT_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1506: select assignment_id from per_all_assignments_f

1502: l_assignment_id number;
1503: l_eit_type_id number;
1504:
1505: cursor csr_asg_id is
1506: select assignment_id from per_all_assignments_f
1507: where assignment_type = 'E'
1508: and primary_flag = 'Y'
1509: and person_id = p_person_id
1510: order by effective_start_date desc;