The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
FREIGHT_TERMS
FROM
OE_FRGHT_TERMS_ACTIVE_V
WHERE FREIGHT_TERMS_CODE = CF_FREIGHT_TERMSFORMULA.FREIGHT_TERMS_CODE;
SELECT
DISTINCT
NAME
FROM
RA_TERMS
WHERE TERM_ID = TERMS_ID;
SELECT
SOB.NAME,
SOB.CURRENCY_CODE
INTO L_COMPANY_NAME,L_FUNCTIONAL_CURRENCY
FROM
GL_SETS_OF_BOOKS SOB,
FND_CURRENCIES CUR
WHERE SOB.SET_OF_BOOKS_ID = P_SOB_ID
AND SOB.CURRENCY_CODE = CUR.CURRENCY_CODE;
SELECT
CP.USER_CONCURRENT_PROGRAM_NAME
INTO L_REPORT_NAME
FROM
FND_CONCURRENT_PROGRAMS_VL CP,
FND_CONCURRENT_REQUESTS CR
WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;
SELECT
ORDER_NUMBER
INTO L_QUALIFIER_ATTR_VALUE
FROM
OE_BLANKET_HEADERS_ALL
WHERE HEADER_ID = QUALIFIER_ATTR_VALUE;
SELECT
H.ORDER_NUMBER || '-' || L.LINE_NUMBER
INTO L_QUALIFIER_ATTR_VALUE
FROM
OE_BLANKET_HEADERS_ALL H,
OE_BLANKET_LINES_ALL L
WHERE L.LINE_ID = QUALIFIER_ATTR_VALUE
AND H.HEADER_ID = L.HEADER_ID;
SELECT
APPLICATION_ID
FROM
FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = APP_SHORT_NAME;
SELECT
NAME
FROM
QP_PRICE_FORMULAS_VL
WHERE PRICE_FORMULA_ID = BASE_MARKUP_FORMULA_ID;
SELECT
NAME
FROM
QP_PRICE_FORMULAS_VL
WHERE PRICE_FORMULA_ID = CF_PRICE_FORMULAFORMULA.PRICE_FORMULA_ID;
SELECT
NAME
FROM
QP_PRICE_FORMULAS_VL
WHERE PRICE_FORMULA_ID = MARKUP_FORMULA_ID;
SELECT
CONCATENATED_SEGMENTS
INTO V_ITEM_NAME
FROM
MTL_SYSTEM_ITEMS_VL
WHERE INVENTORY_ITEM_ID = TO_NUMBER(PRODUCT_ATTR_VALUE)
AND ORGANIZATION_ID = P_ITEM_ORGANIZATION;
SELECT
ORDER_NUMBER
INTO L_QUALIFIER_ATTR_VALUE_TO
FROM
OE_BLANKET_HEADERS_ALL
WHERE HEADER_ID = QUALIFIER_ATTR_VALUE_TO;
SELECT
H.ORDER_NUMBER || '-' || L.LINE_NUMBER
INTO L_QUALIFIER_ATTR_VALUE_TO
FROM
OE_BLANKET_HEADERS_ALL H,
OE_BLANKET_LINES_ALL L
WHERE L.LINE_ID = QUALIFIER_ATTR_VALUE_TO
AND H.HEADER_ID = L.HEADER_ID;