APPS.PAY_SA_GENERAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 176: ,per_assignment_status_types pas

172: ,p_person_id IN NUMBER) RETURN VARCHAR2 AS
173: CURSOR get_multiple_assgts IS
174: SELECT count(DISTINCT paf.assignment_id)
175: FROM per_all_assignments_f paf
176: ,per_assignment_status_types pas
177: WHERE paf.assignment_type = 'E'
178: AND paf.PERSON_ID = p_person_id
179: AND p_effective_date between effective_start_date and effective_end_date
180: AND paf.assignment_status_type_id = pas.assignment_status_type_id