DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on HR_EMPLOYEES_CURRENT_V

Line 393: l_dummy hr_employees_current_v.employee_id%TYPE;

389: --
390: PROCEDURE Check_Valid_Employee(p_employee_id IN NUMBER,
391: x_valid OUT NOCOPY BOOLEAN
392: ) IS
393: l_dummy hr_employees_current_v.employee_id%TYPE;
394:
395: BEGIN
396: x_valid := TRUE;
397:

Line 401: FROM hr_employees_current_v

397:
398: --bug 13535075
399: /* SELECT employee_id
400: INTO l_dummy
401: FROM hr_employees_current_v
402: WHERE employee_id = p_employee_id;*/
403:
404: SELECT employee_id
405: INTO l_dummy

Line 1379: l_dummy hr_employees_current_v.employee_id%TYPE;

1375: --
1376: PROCEDURE Check_Valid_Hold_by(p_hold_by IN NUMBER,
1377: x_valid OUT NOCOPY BOOLEAN
1378: ) IS
1379: l_dummy hr_employees_current_v.employee_id%TYPE;
1380:
1381: BEGIN
1382: x_valid := TRUE;
1383:

Line 1386: FROM hr_employees_current_v

1382: x_valid := TRUE;
1383:
1384: SELECT employee_id
1385: INTO l_dummy
1386: FROM hr_employees_current_v
1387: WHERE employee_id = p_hold_by;
1388:
1389:
1390: EXCEPTION