APPS.AHL_PRD_WO_LOGIN_PVT dependencies on WIP_DISCRETE_JOBS

Line 423: FROM AHL_WORKORDERS AWOS, WIP_DISCRETE_JOBS WIP,

419:
420: CURSOR c_get_wo_id (p_workorder_name VARCHAR2,
421: p_org_code VARCHAR2) IS
422: SELECT workorder_id
423: FROM AHL_WORKORDERS AWOS, WIP_DISCRETE_JOBS WIP,
424: ORG_ORGANIZATION_DEFINITIONS ORG
425: WHERE AWOS.WIP_ENTITY_ID = WIP.WIP_ENTITY_ID
426: AND AWOS.WORKORDER_NAME = p_workorder_name
427: AND WIP.ORGANIZATION_ID = ORG.ORGANIZATION_ID