APPS.INV_INVARCPA_XMLP_PKG SQL Statements

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

Line: 101

          SELECT
            LICENSE_PLATE_NUMBER
          INTO M_OUTERMOST_LPN
          FROM
            WMS_LICENSE_PLATE_NUMBERS
          WHERE LPN_ID = OUTERMOST_LPN_ID;

Line: 124

          SELECT
            LICENSE_PLATE_NUMBER
          INTO M_PARENT_LPN
          FROM
            WMS_LICENSE_PLATE_NUMBERS
          WHERE LPN_ID = PARENT_LPN_ID;

Line: 144

        SELECT
          COST_GROUP
        INTO M_COST_GROUP
        FROM
          CST_COST_GROUPS
        WHERE COST_GROUP_ID = COST_GROUP_ID;