DBA Data[Home] [Help]

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')