APPS.AHL_PRD_WO_LOGIN_PVT dependencies on WIP_ENTITIES

Line 1485: l_workorder_name wip_entities.wip_entity_name%TYPE;

1481:
1482:
1483: l_employee_num NUMBER;
1484: l_employee_id NUMBER;
1485: l_workorder_name wip_entities.wip_entity_name%TYPE;
1486: l_workorder_id NUMBER;
1487: l_org_code mtl_parameters.organization_code%TYPE;
1488: l_operation_seq_num wip_operations.operation_seq_num%TYPE;
1489:

Line 2645: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE

2641:
2642: -- get WO status.
2643: CURSOR c_is_wo_valid(p_workorder_id IN NUMBER) IS
2644: SELECT wo.STATUS_CODE, wo.workorder_name, wo.wip_entity_id, we.organization_id
2645: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE
2646: WHERE WO.wip_entity_id = we.wip_entity_id
2647: AND WORKORDER_ID = p_workorder_id;
2648:
2649: -- validate employee.

Line 3385: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE

3381:
3382: -- get WO status.
3383: CURSOR c_is_wo_valid(p_workorder_id IN NUMBER) IS
3384: SELECT wo.STATUS_CODE, wo.workorder_name, wo.wip_entity_id, we.organization_id
3385: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE
3386: WHERE WO.wip_entity_id = we.wip_entity_id
3387: AND WORKORDER_ID = p_workorder_id;
3388:
3389: