The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
CFREQ.PARTY_CODE,
CFREQ.ACCOUNT_NO_FROM,
CFREQ.ACCOUNT_NO_TO,
CFREQ.DEAL_TYPE,
CFREQ.DEAL_NUMBER_FROM,
CFREQ.DEAL_NUMBER_TO,
CFREQ.CREATION_DATE,
CFREQ.STARTING_CFLOW_DATE,
CFREQ.ENDING_CFLOW_DATE,
CFREQ.INCLUDE_JOURNALIZED_FLAG
INTO P_PARTY_CODE,P_OLD_ACCOUNT,P_NEW_ACCOUNT,P_DEAL_TYPE,P_STARTING_DEAL_NO,P_ENDING_DEAL_NO,P_EXECUTION_DATE,P_STARTING_DATE,P_ENDING_DATE,P_INCLUDE_JOURNALIZED
FROM
XTR_CFLOW_REQUEST_DETAILS CFREQ
WHERE CFREQ.CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID;
P_NO_RECORDS_UPDATED := 'Y';
IF (P_NO_RECORDS_UPDATED = 'N') THEN
BEGIN
SELECT
count(*)
INTO L_COUNT
FROM
XTR_CFLOW_UPDATED_RECORDS
WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID;
P_NO_RECORDS_UPDATED := 'Y';
P_NO_RECORDS_UPDATED := 'Y';
IF (P_NO_RECORDS_UPDATED = 'N') THEN
BEGIN
SELECT
'Y'
INTO P_NO_RECORDS_UPDATED
FROM
XTR_CFLOW_UPDATED_RECORDS
WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID
AND MESSAGE_NAME = 'XTR_CFLOW_ACCT_UNAUTHORIZED';
IF (NVL(P_NO_RECORDS_UPDATED
,'N') = 'Y') THEN
FND_MESSAGE.SET_NAME('XTR'
,'XTR_CFLOW_ACCT_UNAUTHORIZED');
P_NO_RECORDS_UPDATED := 'N';
IF (P_NO_RECORDS_UPDATED = 'N') THEN
BEGIN
SELECT
'Y'
INTO P_NO_RECORDS_UPDATED
FROM
XTR_CFLOW_UPDATED_RECORDS
WHERE CASHFLOW_REQUEST_DETAILS_ID = P_CFLOW_REQUEST_DETAILS_ID
AND MESSAGE_NAME = 'XTR_CFLOW_CURRENCY_MISMATCH';
IF (NVL(P_NO_RECORDS_UPDATED
,'N') = 'Y') THEN
FND_MESSAGE.SET_NAME('XTR'
,'XTR_CFLOW_CURRENCY_MISMATCH');
P_NO_RECORDS_UPDATED := 'N';
IF (P_NO_RECORDS_UPDATED = 'N') THEN
FND_MESSAGE.SET_NAME('XTR'
,'XTR_CFLOW_UPDATED');
P_MESSAGE_CODE_FOR_UPDATE := FND_MESSAGE.GET;
,'XTR_CFLOW_NOT_UPDATED');