APPS.AP_WEB_DB_AP_INT_PKG dependencies on PER_ASSIGNMENTS_F

Line 793: FROM per_assignments_f pera,

789: -----------------------------------------------------
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