APPS.PAY_AE_GENERAL dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 302: ,per_assignment_status_types pas
298: ,p_person_id IN NUMBER) RETURN VARCHAR2 AS
299: CURSOR get_multiple_assgts IS
300: SELECT count(DISTINCT paf.assignment_id)
301: FROM per_all_assignments_f paf 302: ,per_assignment_status_types pas 303: WHERE paf.assignment_type = 'E'
304: AND paf.PERSON_ID = p_person_id
305: AND p_effective_date between effective_start_date and effective_end_date
306: AND paf.assignment_status_type_id = pas.assignment_status_type_id