APPS.IGI_IMP_IAC_PURGE_PKG SQL Statements

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

Line: 30

SELECT COUNT(*)
INTO V_COUNT
FROM IGI_IMP_IAC_INTERFACE_CTRL
WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
AND TRANSFER_STATUS = 'C';

Line: 39

        SELECT count(*)
        INTO category_count
        FROM IGI_IMP_IAC_INTERFACE_CTRL
        WHERE BOOK_TYPE_CODE = p_book_type_code
          AND CATEGORY_ID <> p_category_id;

Line: 46

            SELECT count(*)
            INTO asset_count
            FROM IGI_IMP_IAC_INTERFACE
            WHERE BOOK_TYPE_CODE = p_book_type_code
              AND CATEGORY_ID = p_category_id
              AND ASSET_ID <> p_asset_id;

Line: 62

        DELETE FROM IGI_IMP_IAC_CONTROLS
        WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 65

        DELETE FROM IGI_IMP_IAC_INTERFACE
        WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 68

        DELETE FROM IGI_IMP_IAC_INTERFACE_CTRL
        WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 71

        DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD
        WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 74

        DELETE FROM IGI_IMP_IAC_INTERMEDIATE
        WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;

Line: 79

        DELETE FROM IGI_IMP_IAC_INTERFACE
        WHERE CATEGORY_ID = p_category_id;

Line: 82

        DELETE FROM IGI_IMP_IAC_INTERFACE_CTRL
        WHERE CATEGORY_ID = p_category_id;

Line: 85

        DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD
        WHERE CATEGORY_ID = p_category_id;

Line: 88

        DELETE FROM IGI_IMP_IAC_INTERMEDIATE
        WHERE CATEGORY_ID = p_category_id;

Line: 93

        DELETE FROM IGI_IMP_IAC_INTERFACE
        WHERE ASSET_ID = p_asset_id;

Line: 96

        DELETE FROM IGI_IMP_IAC_INTERFACE_PY_ADD
        WHERE ASSET_ID = p_asset_id;

Line: 99

        DELETE FROM IGI_IMP_IAC_INTERMEDIATE
        WHERE ASSET_ID = p_asset_id;