APPS.WSH_WSHRDIST_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 56

      SELECT
        APPLICATION_NAME
      INTO APPL_NAME
      FROM
        FND_APPLICATION_VL
      WHERE APPLICATION_ID = P_APPLICATION_ID;

Line: 78

      SELECT
        SERVICE_PROVIDER
      INTO SERVICE_PROVIDER
      FROM
        WSH_ITM_VENDORS
      WHERE VENDOR_ID = P_VENDOR_ID;

Line: 100

      SELECT
        ORG.ORGANIZATION_NAME
      INTO MASTER_ORG_NAME
      FROM
        ORG_ORGANIZATION_DEFINITIONS2 ORG,
        MTL_PARAMETERS MTL,
        MFG_LOOKUPS A
      WHERE NVL(ORG.DISABLE_DATE
         ,SYSDATE + 1) > sysdate
        AND ( ( MTL.ORGANIZATION_ID = MTL.MASTER_ORGANIZATION_ID ) )
        AND mtl.organization_id (+) = ORG.ORGANIZATION_ID
        AND A.LOOKUP_CODE = NVL(MTL.PRIMARY_COST_METHOD
         ,1)
        AND A.LOOKUP_TYPE = 'MTL_PRIMARY_COST'
        AND ORG.ORGANIZATION_ID = P_MASTER_ORG_ID;

Line: 131

      SELECT
        ORGANIZATION_NAME
      INTO ORG_NAME
      FROM
        ORG_ORGANIZATION_DEFINITIONS
      WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 153

      SELECT
        USER_NAME
      INTO APPLICATION_USER
      FROM
        FND_USER
      WHERE USER_ID = P_APPL_USER_ID;