APPS.AP_WEB_DB_AP_INT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 770: per_assignment_status_types peras
766: begin
767: SELECT pera.default_code_comb_id
768: INTO l_default_emp_ccid
769: FROM per_assignments_f pera, 770: per_assignment_status_types peras 771: WHERE pera.person_id = p_employee_id
772: AND pera.assignment_status_type_id = peras.assignment_status_type_id
773: AND trunc(p_as_of_date) between pera.effective_start_date and pera.effective_end_date
774: AND pera.assignment_type in ('C', 'E')