DBA Data[Home] [Help]

APPS.AP_VENDORS_PKG dependencies on HR_EMPLOYEES

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

2201: --
2202: current_calling_sequence := 'AP_VENDORS_PKG.RESOLVE_EMPLOYEE<-' ||
2203: X_calling_sequence;
2204:
2205: -- For bug 2437569. Changed the view from hr_employees to
2206: -- hr_employees_current_v. This is to retrive the record details
2207: -- of only active employees .
2208:
2209: -- For bug2900352. Backing out the changes done for bug 2437569 .

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

2202: current_calling_sequence := 'AP_VENDORS_PKG.RESOLVE_EMPLOYEE<-' ||
2203: X_calling_sequence;
2204:
2205: -- For bug 2437569. Changed the view from hr_employees to
2206: -- hr_employees_current_v. This is to retrive the record details
2207: -- of only active employees .
2208:
2209: -- For bug2900352. Backing out the changes done for bug 2437569 .
2210:

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

2208:
2209: -- For bug2900352. Backing out the changes done for bug 2437569 .
2210:
2211:
2212: debug_info := 'Get employee name and number from HR_Employees using ID';
2213: select full_name,
2214: employee_num
2215: into x_Employee_name,
2216: x_Employee_number

Line 2217: from hr_employees --bug: 2900352

2213: select full_name,
2214: employee_num
2215: into x_Employee_name,
2216: x_Employee_number
2217: from hr_employees --bug: 2900352
2218: where employee_id = x_employee_id;
2219:
2220: EXCEPTION
2221: WHEN NO_DATA_FOUND THEN