DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on PER_ASSIGNMENTS_F

Line 769: FROM per_assignments_f pera,

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