DBA Data[Home] [Help]

APPS.AHL_PRD_WO_LOGIN_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 424: ORG_ORGANIZATION_DEFINITIONS ORG

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