DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on HR_EMPLOYEES_CURRENT_V

Line 303: l_dummy hr_employees_current_v.employee_id%TYPE;

299: --
300: PROCEDURE Check_Valid_Employee(p_employee_id IN NUMBER,
301: x_valid OUT NOCOPY BOOLEAN
302: ) IS
303: l_dummy hr_employees_current_v.employee_id%TYPE;
304:
305: BEGIN
306: x_valid := TRUE;
307:

Line 310: FROM hr_employees_current_v

306: x_valid := TRUE;
307:
308: SELECT employee_id
309: INTO l_dummy
310: FROM hr_employees_current_v
311: WHERE employee_id = p_employee_id;
312:
313:
314: EXCEPTION

Line 1111: l_dummy hr_employees_current_v.employee_id%TYPE;

1107: --
1108: PROCEDURE Check_Valid_Hold_by(p_hold_by IN NUMBER,
1109: x_valid OUT NOCOPY BOOLEAN
1110: ) IS
1111: l_dummy hr_employees_current_v.employee_id%TYPE;
1112:
1113: BEGIN
1114: x_valid := TRUE;
1115:

Line 1118: FROM hr_employees_current_v

1114: x_valid := TRUE;
1115:
1116: SELECT employee_id
1117: INTO l_dummy
1118: FROM hr_employees_current_v
1119: WHERE employee_id = p_hold_by;
1120:
1121:
1122: EXCEPTION