DBA Data[Home] [Help]

APPS.AP_WEB_UPLOAD_ACCUM_MILES_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 114: financials_system_params_all f

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
118: AND f.org_id = P_OrgId

Line 122: financials_system_params_all f

118: AND f.org_id = P_OrgId
119: UNION ALL
120: SELECT h.person_id employee_id
121: FROM PER_CONT_WORKERS_CURRENT_X h,
122: financials_system_params_all f
123: WHERE h.npw_number = P_EmployeeNum
124: AND h.business_group_id = f.business_group_id
125: AND f.org_id = P_OrgId
126: );