DBA Data[Home] [Help]

APPS.AP_VENDORS_PKG dependencies on HR_EMPLOYEES

Line 2179: -- For bug 2437569. Changed the view from hr_employees to

2175: --
2176: current_calling_sequence := 'AP_VENDORS_PKG.RESOLVE_EMPLOYEE<-' ||
2177: X_calling_sequence;
2178:
2179: -- For bug 2437569. Changed the view from hr_employees to
2180: -- hr_employees_current_v. This is to retrive the record details
2181: -- of only active employees .
2182:
2183: -- For bug2900352. Backing out the changes done for bug 2437569 .

Line 2180: -- hr_employees_current_v. This is to retrive the record details

2176: current_calling_sequence := 'AP_VENDORS_PKG.RESOLVE_EMPLOYEE<-' ||
2177: X_calling_sequence;
2178:
2179: -- For bug 2437569. Changed the view from hr_employees to
2180: -- hr_employees_current_v. This is to retrive the record details
2181: -- of only active employees .
2182:
2183: -- For bug2900352. Backing out the changes done for bug 2437569 .
2184:

Line 2186: debug_info := 'Get employee name and number from HR_Employees using ID';

2182:
2183: -- For bug2900352. Backing out the changes done for bug 2437569 .
2184:
2185:
2186: debug_info := 'Get employee name and number from HR_Employees using ID';
2187: select full_name,
2188: employee_num
2189: into x_Employee_name,
2190: x_Employee_number

Line 2191: from hr_employees --bug: 2900352

2187: select full_name,
2188: employee_num
2189: into x_Employee_name,
2190: x_Employee_number
2191: from hr_employees --bug: 2900352
2192: where employee_id = x_employee_id;
2193:
2194: EXCEPTION
2195: WHEN NO_DATA_FOUND THEN