The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
ORGANIZATION_NAME
INTO
L_ORG
FROM
ORG_ORGANIZATION_DEFINITIONS
WHERE ORGANIZATION_ID = P_ORG_ID;
SELECT
CURRENCY_CODE
INTO
L_CURRENCY_CODE
FROM
GL_SETS_OF_BOOKS GSB,
FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE GSB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID;
SELECT
PRECISION
INTO
L_DOC_CURR_PRECISION
FROM
FND_CURRENCIES
WHERE CURRENCY_CODE = CURRENCY_CODE;
SELECT
CATEGORY_SET_NAME
INTO
CAT_SET_NAME
FROM
MTL_CATEGORY_SETS
WHERE CATEGORY_SET_ID = CAT_SET_ID;
SELECT
STRUCTURE_ID
INTO
L_P_STRUCT_NUM
FROM
MTL_DEFAULT_SETS_VIEW
WHERE FUNCTIONAL_AREA_ID = 2;
SELECT
PSP.MANUAL_RECEIPT_NUM_TYPE
INTO
RECEIPT_NUMBERING_TYPE
FROM
PO_SYSTEM_PARAMETERS PSP;
SELECT
DISTINCT
MANUAL_RECEIPT_NUM_TYPE
INTO
RECEIPT_NUMBERING_TYPE
FROM
RCV_RECEIVING_PARAMETERS_V
WHERE ORGANIZATION_ID = P_ORG_ID;
SELECT
NVL((SUM(NVL(PO_TAX_SV.GET_TAX('PO'
,POD.PO_DISTRIBUTION_ID)
,0)) / SUM(POD.QUANTITY_ORDERED))
,0)
INTO
L_TOT_TAX
FROM
PO_DISTRIBUTIONS_ALL POD,
RCV_TRANSACTIONS RT
WHERE RT.TRANSACTION_ID = TRX_ID
AND ( ( RT.PO_DISTRIBUTION_ID IS NOT NULL
AND RT.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID )
OR ( RT.PO_DISTRIBUTION_ID IS NULL
AND RT.PO_LINE_LOCATION_ID = POD.LINE_LOCATION_ID ) );
SELECT
DECODE(SIGN(NVL(SUM(ACCOUNTED_NR_TAX)
,0))
,0
,0
,1) * L_TOT_TAX
INTO
L_TOT_TAX
FROM
RCV_RECEIVING_SUB_LEDGER
WHERE RCV_TRANSACTION_ID = TRX_ID;