APPS.AHL_PRD_WO_LOGIN_PVT dependencies on WIP_DISCRETE_JOBS

Line 426: FROM AHL_WORKORDERS AWOS, WIP_DISCRETE_JOBS WIP,

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