DBA Data[Home] [Help]

APPS.AP_WEB_UPLOAD_ACCUM_MILES_PKG dependencies on AP_WEB_DB_HR_INT_PKG

Line 116: AND AP_WEB_DB_HR_INT_PKG.isPersonCwk(h.employee_id)='N'

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
118: AND f.org_id = P_OrgId
119: UNION ALL
120: SELECT h.person_id employee_id