APPS.AHL_PRD_WO_LOGIN_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 427: ORG_ORGANIZATION_DEFINITIONS ORG

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
431: AND ORG.ORGANIZATION_CODE = p_org_code;