The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
COUNT(1)
INTO CP_TRL_ROW_COUNT
FROM
ZX_REP_CONTEXT_T CON,
ZX_REP_TRX_DETAIL_T DET
WHERE CON.REQUEST_ID = P_CONC_REQUEST_ID
AND DET.REQUEST_ID = CON.REQUEST_ID
AND NVL(DET.REP_CONTEXT_ID
,CON.REP_CONTEXT_ID) = CON.REP_CONTEXT_ID;
SELECT
GL.SET_OF_BOOKS_ID
INTO L_SET_OF_BOOKS_ID
FROM
GL_SETS_OF_BOOKS GL,
AR_SYSTEM_PARAMETERS AR
WHERE GL.SET_OF_BOOKS_ID = AR.SET_OF_BOOKS_ID;
SELECT
GL.PERIOD_NAME
INTO L_PERIOD_FROM
FROM
GL_PERIOD_STATUSES GL,
AR_SYSTEM_PARAMETERS AR
WHERE GL.START_DATE = P_GL_DATE_LOW
AND GL.SET_OF_BOOKS_ID = L_SET_OF_BOOKS_ID
AND GL.APPLICATION_ID = 222
AND ROWNUM = 1;
SELECT
GL.PERIOD_NAME
INTO L_PERIOD_TO
FROM
GL_PERIOD_STATUSES GL,
AR_SYSTEM_PARAMETERS AR
WHERE GL.END_DATE = P_GL_DATE_HIGH
AND GL.SET_OF_BOOKS_ID = L_SET_OF_BOOKS_ID
AND GL.APPLICATION_ID = 222
AND ROWNUM = 1;
SELECT
MEANING
INTO L_DETAIL_LEVEL
FROM
AR_LOOKUPS
WHERE LOOKUP_TYPE = 'ARXVATRN_DETAIL_OPTION'
AND LOOKUP_CODE = P_DETAIL_LEVEL;
SELECT
SOB.NAME
INTO P_COMPANY_NAME_DESC
FROM
GL_SETS_OF_BOOKS SOB
WHERE SET_OF_BOOKS_ID = P_REP_CONTEXT_ENTITY_NAME;
SELECT
LEDGER_NAME
INTO P_COMPANY_NAME_DESC
FROM
GL_LEDGER_LE_V
WHERE LEGAL_ENTITY_ID = P_REP_CONTEXT_ENTITY_NAME;
SELECT
SOB.NAME
INTO P_COMPANY_NAME_DESC
FROM
HR_OPERATING_UNITS HR,
GL_SETS_OF_BOOKS SOB
WHERE HR.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND HR.ORGANIZATION_ID = P_REP_CONTEXT_ENTITY_NAME;
SELECT
MEANING
INTO CP_NLS_YES
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = 'Y';
SELECT
MEANING
INTO CP_NLS_NO
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = 'N';
SELECT
MEANING
INTO CP_REPORT_TITLE
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'ZXARRECV'
AND LOOKUP_CODE = P_REPORT_NAME;
SELECT
'SUCCESS'
INTO L_DUMMY
FROM
JG_ZZ_AR_SRC_TRX_TY ST,
RA_BATCH_SOURCES SRC
WHERE ST.BATCH_SOURCE_ID = DECODE(SRC.GLOBAL_ATTRIBUTE1
,NULL
,SRC.BATCH_SOURCE_ID
,SRC.GLOBAL_ATTRIBUTE1)
AND SRC.NAME = TRX_SOURCE
AND ST.ENABLE_FLAG = 'Y';
SELECT
SUM(A.TAXABLE_AMT)
INTO L_INV_TAXABLE_AMT
FROM
ZX_REP_TRX_DETAIL_T A
WHERE A.TRX_ID = C_TRANSACTION_ID
AND A.TRX_LINE_ID = C_TRANSACTION_LINE
AND A.REQUEST_ID = P_CONC_REQUEST_ID
AND A.ROWID = (
SELECT
MIN(B.ROWID)
FROM
ZX_REP_TRX_DETAIL_T B
WHERE A.TRX_ID = B.TRX_ID
AND A.TRX_LINE_ID = B.TRX_LINE_ID
AND B.REQUEST_ID = P_CONC_REQUEST_ID );
SELECT
SUM(A.TAXABLE_AMT_FUNCL_CURR)
INTO L_INV_TAXABLE_AMT
FROM
ZX_REP_TRX_DETAIL_T A
WHERE A.TRX_ID = C_TRANSACTION_ID
AND A.TRX_LINE_ID = C_TRANSACTION_LINE
AND A.REQUEST_ID = P_CONC_REQUEST_ID
AND A.ROWID = (
SELECT
MIN(B.ROWID)
FROM
ZX_REP_TRX_DETAIL_T B
WHERE A.TRX_ID = B.TRX_ID
AND A.TRX_LINE_ID = B.TRX_LINE_ID
AND B.REQUEST_ID = P_CONC_REQUEST_ID );
SELECT
SUM(NVL(A.TAXABLE_AMT
,0) + NVL(A.TAX_AMT
,0)),
SUM(NVL(A.TAXABLE_AMT_FUNCL_CURR
,0) + NVL(A.TAX_AMT_FUNCL_CURR
,0))
INTO CF_TOT_AMOUNT,CF_TOT_FUNC_AMT
FROM
ZX_REP_TRX_DETAIL_T A
WHERE A.TRX_ID = C_TRANSACTION_ID
AND A.TRX_LINE_ID = C_TRANSACTION_LINE
AND A.REQUEST_ID = P_CONC_REQUEST_ID
AND A.ROWID = (
SELECT
MIN(B.ROWID)
FROM
ZX_REP_TRX_DETAIL_T B
WHERE A.TRX_ID = B.TRX_ID
AND A.TRX_LINE_ID = B.TRX_LINE_ID
AND B.REQUEST_ID = P_CONC_REQUEST_ID );
SELECT
PARTY.PARTY_NAME
INTO L_CUST_NAME
FROM
HZ_CUST_ACCOUNTS CUST,
HZ_PARTIES PARTY
WHERE CUST.PARTY_ID = PARTY.PARTY_ID
AND CUST.CUST_ACCOUNT_ID = P_CUSTOMER_ID;
SELECT
CURRENCY_CODE
INTO L_LEDGER_CURRENCY
FROM
GL_LEDGERS
WHERE LEDGER_ID = P_REP_CONTEXT_ENTITY_NAME;
SELECT
CURRENCY_CODE
INTO L_LEDGER_CURRENCY
FROM
GL_LEDGER_LE_V
WHERE LEGAL_ENTITY_ID = P_REP_CONTEXT_ENTITY_NAME;
SELECT
B.CURRENCY_CODE
INTO L_LEDGER_CURRENCY
FROM
HR_OPERATING_UNITS A,
GL_LEDGERS B
WHERE A.SET_OF_BOOKS_ID = B.LEDGER_ID
AND A.ORGANIZATION_ID = P_REP_CONTEXT_ENTITY_NAME;
GUI_TABLE.DELETE;