APPS.CSD_MIGRATE_FROM_12X_PKG9 SQL Statements

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

Line: 6

    /* This procedure updates the existing CSD_AHL_W_CONTRACT_XREF table to */
    /* support the supplier warranty enhancement. The instance_id for the   */
    /* existing records will be added to the new column INSTANCE_ID.        */
    /* @param. None                                                         */


    PROCEDURE CSD_AHL_W_CONTRACT_XREF_MIG9 IS

    -- Definitions --
        TYPE W_CONTRACT_XREF_ID_ARRAY_TYPE IS VARRAY (1000)
             OF CSD_AHL_W_CONTRACT_XREF.WARRANTY_CONTRACT_XREF_ID%TYPE;

Line: 35

          SELECT DISTINCT
            wc.warranty_contract_xref_id, rep.customer_product_id
          FROM
            CSD_AHL_W_CONTRACT_XREF wc,
            CSD_REPAIRS rep
          WHERE wc.instance_id IS NULL
            AND rep.repair_line_id = wc.repair_line_id;

Line: 56

              UPDATE
                CSD_AHL_W_CONTRACT_XREF
              SET
                instance_id = instance_id_arr(i)
              WHERE warranty_contract_xref_id = w_contract_xref_id_arr(i);