APPS.AHL_PRD_WO_LOGIN_PVT dependencies on WIP_ENTITIES

Line 1482: l_workorder_name wip_entities.wip_entity_name%TYPE;

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

Line 2637: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE

2633:
2634: -- get WO status.
2635: CURSOR c_is_wo_valid(p_workorder_id IN NUMBER) IS
2636: SELECT wo.STATUS_CODE, wo.workorder_name, wo.wip_entity_id, we.organization_id
2637: FROM AHL_WORKORDERS WO, WIP_ENTITIES WE
2638: WHERE WO.wip_entity_id = we.wip_entity_id
2639: AND WORKORDER_ID = p_workorder_id;
2640:
2641: -- validate employee.