APPS.PER_QH_ACTION dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 49: l_per_system_status per_assignment_status_types.per_system_status%type;

45: l_full_name per_all_people_f.full_name%type;
46: l_per_object_version_number per_all_people_f.object_version_number%type;
47: l_per_object_version_number2 per_all_people_f.object_version_number%type;
48: l_asg_object_version_number per_all_assignments_f.object_version_number%type;
49: l_per_system_status per_assignment_status_types.per_system_status%type;
50: l_employee_number per_all_people_f.employee_number%type;
51: l_applicant_number per_all_people_f.applicant_number%type;
52: l_datetrack_update_mode varchar2(30);
53: l_dummyb boolean;

Line 88: per_assignment_status_types pas

84: select pas.per_system_status
85: , asg.object_version_number
86: , asg.effective_start_date
87: from per_assignments_f asg,
88: per_assignment_status_types pas
89: where asg.assignment_id=p_assignment_id
90: and asg.assignment_status_type_id = pas.assignment_status_type_id
91: and p_date between asg.effective_start_date
92: and asg.effective_end_date;