APPS.AP_WEB_DB_AP_INT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 794: per_assignment_status_types peras
790: begin
791: SELECT pera.default_code_comb_id
792: INTO l_default_emp_ccid
793: FROM per_assignments_f pera, 794: per_assignment_status_types peras 795: WHERE pera.person_id = p_employee_id
796: AND pera.assignment_status_type_id = peras.assignment_status_type_id
797: AND trunc(p_as_of_date) between pera.effective_start_date and pera.effective_end_date
798: AND pera.assignment_type in ('C', 'E')