APPS.HR_CONTINGENT_WORKER_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1722: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

1718: l_max_tpe_end_date date;
1719: l_name_combination_warning boolean;
1720: l_orig_hire_warning boolean;
1721: l_per_object_version_number number;
1722: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1723: l_person_id number;
1724: l_date_start date;
1725: l_person_type_id number;
1726: l_proc varchar2(72)

Line 3621: FROM per_assignment_status_types

3617: --
3618: hr_utility.set_location(l_proc,75);
3619: SELECT per_system_status
3620: INTO l_per_system_status
3621: FROM per_assignment_status_types
3622: WHERE assignment_status_type_id = c_asg_rec.assignment_status_type_id;
3623: --
3624: -- Get the assignment_status_id from the record which ended on ATD
3625: -- so that we can set the other records for this assignment which