APPS.AHL_PRD_WO_LOGIN_PVT dependencies on MTL_EMPLOYEES_CURRENT_VIEW

Line 525: FROM mtl_employees_current_view pf,

521: AND WOR.resource_id = nvl(p_resource_id, WOR.resource_id)
522: AND WOR.resource_seq_num = nvl(p_resource_seq_num, WOR.resource_seq_num)
523: -- qualified.
524: AND EXISTS (SELECT 'x'
525: FROM mtl_employees_current_view pf,
526: bom_resource_employees bre,
527: bom_dept_res_instances bdri,
528: wip_operations wo,
529: bom_department_resources bdr

Line 885: FROM mtl_employees_current_view pf,

881: AND BRS.resource_type = 2 -- person.
882: AND AW.workorder_id = p_workorder_id
883: -- qualified.
884: AND EXISTS (SELECT 'x'
885: FROM mtl_employees_current_view pf,
886: bom_resource_employees bre,
887: bom_dept_res_instances bdri,
888: wip_operations wo,
889: bom_department_resources bdr

Line 1206: FROM mtl_employees_current_view pf,

1202: AND BRS.resource_type = 2 -- person.
1203: AND AW.workorder_id = p_workorder_id
1204: -- qualified.
1205: AND EXISTS (SELECT 'x'
1206: FROM mtl_employees_current_view pf,
1207: bom_resource_employees bre,
1208: bom_dept_res_instances bdri,
1209: wip_operations wo,
1210: bom_department_resources bdr

Line 2399: FROM MTL_EMPLOYEES_CURRENT_VIEW

2395:
2396: -- To get the employee ID based on an employee number.
2397: CURSOR c_get_employee_id (p_employee_number IN VARCHAR2) IS
2398: SELECT employee_id
2399: FROM MTL_EMPLOYEES_CURRENT_VIEW
2400: WHERE employee_num = p_employee_number
2401: AND rownum < 2;
2402:
2403: l_employee_ID NUMBER;

Line 2489: FROM MTL_EMPLOYEES_CURRENT_VIEW

2485:
2486: -- To get employee name.
2487: CURSOR get_emp_name (p_employee_id IN NUMBER) IS
2488: SELECT full_name
2489: FROM MTL_EMPLOYEES_CURRENT_VIEW
2490: WHERE employee_id = p_employee_id
2491: AND rownum < 2;
2492:
2493:

Line 2653: FROM mtl_employees_current_view pf

2649: -- validate employee.
2650: CURSOR c_is_emp_valid (p_employee_id IN NUMBER,
2651: p_org_id IN NUMBER) IS
2652: SELECT pf.employee_id
2653: FROM mtl_employees_current_view pf
2654: WHERE pf.employee_id = p_employee_id
2655: AND pf.organization_id = p_org_id;
2656:
2657: /*