APPS.AHL_PRD_WO_LOGIN_PVT dependencies on MTL_EMPLOYEES_CURRENT_VIEW

Line 522: FROM mtl_employees_current_view pf,

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

Line 882: FROM mtl_employees_current_view pf,

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

Line 1203: FROM mtl_employees_current_view pf,

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

Line 2391: FROM MTL_EMPLOYEES_CURRENT_VIEW

2387:
2388: -- To get the employee ID based on an employee number.
2389: CURSOR c_get_employee_id (p_employee_number IN VARCHAR2) IS
2390: SELECT employee_id
2391: FROM MTL_EMPLOYEES_CURRENT_VIEW
2392: WHERE employee_num = p_employee_number
2393: AND rownum < 2;
2394:
2395: l_employee_ID NUMBER;

Line 2481: FROM MTL_EMPLOYEES_CURRENT_VIEW

2477:
2478: -- To get employee name.
2479: CURSOR get_emp_name (p_employee_id IN NUMBER) IS
2480: SELECT full_name
2481: FROM MTL_EMPLOYEES_CURRENT_VIEW
2482: WHERE employee_id = p_employee_id
2483: AND rownum < 2;
2484:
2485:

Line 2645: FROM mtl_employees_current_view pf

2641: -- validate employee.
2642: CURSOR c_is_emp_valid (p_employee_id IN NUMBER,
2643: p_org_id IN NUMBER) IS
2644: SELECT pf.employee_id
2645: FROM mtl_employees_current_view pf
2646: WHERE pf.employee_id = p_employee_id
2647: AND pf.organization_id = p_org_id;
2648:
2649: /*