The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
SUM((API.INVOICE_AMOUNT - NVL(AMOUNT_PAID
,0)) * NVL(EXCHANGE_RATE
,1)) AMOUNT
INTO V_AMOUNT
FROM
AP_INVOICES_ALL API
WHERE API.VENDOR_ID = VEND_ID
AND TRUNC(API.INVOICE_DATE) BETWEEN TRUNC(DT1)
AND TRUNC(DT2)
AND API.PAYMENT_STATUS_FLAG IN ( 'N' , 'P' )
AND API.INVOICE_TYPE_LOOKUP_CODE <> LV_PREPAYMENT
AND ( API.ORG_ID = P_ORG_ID
OR API.ORG_ID IS NULL );
SELECT
SUM((API.INVOICE_AMOUNT - NVL(AMOUNT_PAID
,0)) * NVL(EXCHANGE_RATE
,1)) AMOUNT
INTO V_AMOUNT
FROM
AP_INVOICES_ALL API
WHERE API.VENDOR_ID = VEND_ID
AND TRUNC(API.INVOICE_DATE) < TRUNC(DT)
AND API.PAYMENT_STATUS_FLAG IN ( 'N' , 'P' )
AND API.INVOICE_TYPE_LOOKUP_CODE <> 'PREPAYMENT'
AND ( API.ORG_ID = P_ORG_ID
OR API.ORG_ID IS NULL );
SELECT
NAME
INTO V_NAME
FROM
HR_ORGANIZATION_UNITS
WHERE NVL(ORGANIZATION_ID
,0) = NVL(ORG_ID
,0);
SELECT
LOCATION_ID
FROM
HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = ORG_ID;
SELECT
ADDRESS_LINE_1 || ',' || ADDRESS_LINE_2 || ',' || ADDRESS_LINE_3 || ',' || TOWN_OR_CITY || ',' || COUNTRY || ',' || POSTAL_CODE || ',' || TELEPHONE_NUMBER_1 || ',' || TELEPHONE_NUMBER_2 || ',' || TELEPHONE_NUMBER_3
FROM
HR_LOCATIONS
WHERE LOCATION_ID = V_LOCATION_ID;
SELECT
CONCURRENT_PROGRAM_ID,
NVL(ENABLE_TRACE
,'N')
FROM
FND_CONCURRENT_REQUESTS
WHERE REQUEST_ID = P_REQUEST_ID;
SELECT
SET_OF_BOOKS_ID
FROM
ORG_ORGANIZATION_DEFINITIONS
WHERE NVL(OPERATING_UNIT
,0) = NVL(V_ORG_ID
,0);
SELECT
NAME
FROM
GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = SOB_ID;
SELECT
MULTI_ORG_FLAG
FROM
FND_PRODUCT_GROUPS;
SELECT
VENDOR_NAME
FROM
PO_VENDORS
WHERE VENDOR_ID = V_ID;
SELECT
SUM(PREPAY_AMOUNT_REMAINING) * NVL(EXCHANGE_RATE1
,1)
INTO AMOUNT
FROM
AP_INVOICE_DISTRIBUTIONS_ALL APD
GROUP BY
APD.INVOICE_ID
HAVING APD.INVOICE_ID = INVOICE_ID1;
SELECT
SUM(PREPAY_AMOUNT_REMAINING)
INTO AMOUNT
FROM
AP_INVOICE_DISTRIBUTIONS_ALL APD
GROUP BY
APD.INVOICE_ID
HAVING APD.INVOICE_ID = INVOICE_ID1;