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:
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
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:
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