109: SELECT employee_id
110: INTO l_EmployeeId
111: FROM (
112: SELECT h.employee_id
113: FROM per_employees_current_x h,
114: financials_system_params_all f
115: WHERE h.employee_num = P_EmployeeNum
116: AND AP_WEB_DB_HR_INT_PKG.isPersonCwk(h.employee_id)='N'
117: AND h.business_group_id = f.business_group_id