The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
MEANING
INTO NDF
FROM
PA_LOOKUPS
WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
AND LOOKUP_TYPE = 'MESSAGE';
SELECT
'Y'
INTO EXCEP
FROM
DUAL
WHERE exists (
SELECT
'yes'
FROM
PA_CC_DIST_LINES
WHERE TRANSFER_STATUS_CODE = 'R'
AND REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID );
SELECT
'Y'
INTO SUCCESS
FROM
DUAL
WHERE exists (
SELECT
'yes'
FROM
PA_CC_DIST_LINES
WHERE TRANSFER_STATUS_CODE = 'A'
AND REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID );
SELECT
GLB.CHART_OF_ACCOUNTS_ID,
GLB.NAME
INTO V_DUMMY,V_COMPANY_NAME
FROM
GL_SETS_OF_BOOKS GLB,
PA_IMPLEMENTATIONS IMP
WHERE GLB.SET_OF_BOOKS_ID = IMP.SET_OF_BOOKS_ID;