APPS.PAY_KW_GENERAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 250: ,per_assignment_status_types pas

246: ,p_person_id IN NUMBER) RETURN VARCHAR2 AS
247: CURSOR get_multiple_assgts IS
248: SELECT count(DISTINCT paf.assignment_id)
249: FROM per_all_assignments_f paf
250: ,per_assignment_status_types pas
251: WHERE paf.assignment_type = 'E'
252: AND paf.PERSON_ID = p_person_id
253: AND p_effective_date between effective_start_date and effective_end_date
254: AND paf.assignment_status_type_id = pas.assignment_status_type_id