APPS.PAY_AE_GENERAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 264: ,per_assignment_status_types pas

260: ,p_person_id IN NUMBER) RETURN VARCHAR2 AS
261: CURSOR get_multiple_assgts IS
262: SELECT count(DISTINCT paf.assignment_id)
263: FROM per_all_assignments_f paf
264: ,per_assignment_status_types pas
265: WHERE paf.assignment_type = 'E'
266: AND paf.PERSON_ID = p_person_id
267: AND p_effective_date between effective_start_date and effective_end_date
268: AND paf.assignment_status_type_id = pas.assignment_status_type_id