APPS.HR_CONTINGENT_WORKER_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2095: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

2091: l_max_tpe_end_date date;
2092: l_name_combination_warning boolean;
2093: l_orig_hire_warning boolean;
2094: l_per_object_version_number number;
2095: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
2096: l_person_id number;
2097: l_date_start date;
2098: l_person_type_id number;
2099: l_proc varchar2(72)

Line 4078: FROM per_assignment_status_types

4074: --
4075: hr_utility.set_location(l_proc,75);
4076: SELECT per_system_status
4077: INTO l_per_system_status
4078: FROM per_assignment_status_types
4079: WHERE assignment_status_type_id = c_asg_rec.assignment_status_type_id;
4080: --
4081: -- Get the assignment_status_id from the record which ended on ATD
4082: -- so that we can set the other records for this assignment which