The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
SUM(A.FAIR_VALUE)
FROM
XTR_REVALUATION_DETAILS_SUM_V A,
XTR_BATCHES B
WHERE A.COMPANY_CODE = COMPANY
AND A.COMPANY_CODE = B.COMPANY_CODE
AND A.BATCH_ID = B.BATCH_ID
AND A.REF_NUMBER = BEGIN_FVFORMULA.REF_NUMBER
AND B.PERIOD_END < BEGIN_FVFORMULA.PERIOD_START
AND A.REALIZED_FLAG = P_REALIZED_FLAG
GROUP BY
B.PERIOD_START
ORDER BY
B.PERIOD_START DESC;
SELECT
SUM(INITIAL_FAIR_VALUE)
FROM
XTR_DEALS
WHERE DEAL_NO = REF_NUMBER;
SELECT
SUM(INITIAL_FAIR_VALUE)
FROM
XTR_ROLLOVER_TRANSACTIONS
WHERE DEAL_NUMBER = REF_NUMBER;
SELECT
SUM(A.FAIR_VALUE)
FROM
XTR_REVALUATION_DETAILS_SUM_V A,
XTR_BATCHES B
WHERE A.COMPANY_CODE = COMPANY
AND A.COMPANY_CODE = B.COMPANY_CODE
AND A.BATCH_ID = B.BATCH_ID
AND A.REF_NUMBER = REF_NUMBER_1
AND B.PERIOD_END <= PERIOD_END_1
AND A.REALIZED_FLAG = P_REALIZED_FLAG
GROUP BY
B.PERIOD_END
ORDER BY
B.PERIOD_END DESC;
SELECT
DECODE(SUBSTR(P_FACTOR
,1
,1)
,'U'
,1
,'T'
,1000
,'M'
,1000000
,'B'
,100000000),
MEANING
INTO L_FACTOR,P_USER_FACTOR
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'XTR_FACTOR'
AND LOOKUP_CODE = SUBSTR(P_FACTOR
,1
,1);
SELECT
MEANING
INTO Z2REALIZED_FLAG
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'XTR_MISC'
AND LOOKUP_CODE = P_REALIZED_FLAG;
SELECT
USER_DEAL_TYPE
INTO P_USER_DEAL_TYPE
FROM
XTR_DEAL_TYPES
WHERE DEAL_TYPE = P_DEAL_TYPE;
SELECT
MEANING
INTO P_USER_DEAL_TYPE
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'XTR_HEDGE_MISC'
AND LOOKUP_CODE = 'HEDGE';
SELECT
MEANING
INTO P_USER_GROUPBY
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'XTR_MISC'
AND LOOKUP_CODE = P_GROUPBY;
SELECT
SUBSTR(SHORT_NAME
,1
,30)
INTO P_USER_COMPANY
FROM
XTR_PARTY_INFO
WHERE PARTY_CODE = P_COMPANY
AND PARTY_TYPE = 'C';
SELECT
TO_CHAR(MIN(PERIOD_START)
,'YYYY/MM/DD HH24:MI:SS')
INTO P_DATE_FROM
FROM
XTR_BATCHES B,
XTR_BATCH_EVENTS E
WHERE B.BATCH_ID = E.BATCH_ID
AND E.EVENT_CODE = 'REVAL'
AND B.BATCH_ID >= P_BATCH_ID_FROM;
SELECT
TO_CHAR(MAX(PERIOD_END)
,'YYYY/MM/DD HH24:MI:SS')
INTO P_DATE_TO
FROM
XTR_BATCHES B,
XTR_BATCH_EVENTS E
WHERE B.BATCH_ID = E.BATCH_ID
AND E.EVENT_CODE = 'REVAL'
AND B.BATCH_ID <= P_BATCH_ID_TO;
SELECT
ITEM_NAME,
SUBSTR(TEXT
,1
,100) LANG_NAME
FROM
XTR_SYS_LANGUAGES_VL
WHERE MODULE_NAME = 'XTRREVGL';
SELECT
SHORT_NAME
INTO L_SHT_NAME
FROM
XTR_PARTY_INFO
WHERE PARTY_CODE = COMPANY
AND PARTY_TYPE = 'C';
SELECT
SUBSTR(CP.USER_CONCURRENT_PROGRAM_NAME
,INSTR(CP.USER_CONCURRENT_PROGRAM_NAME
,'-') + 2)
INTO L_REPORT_NAME
FROM
FND_CONCURRENT_PROGRAMS_VL CP,
FND_CONCURRENT_REQUESTS CR
WHERE CR.REQUEST_ID = P_CONC_REQUEST_ID
AND CP.APPLICATION_ID = CR.PROGRAM_APPLICATION_ID
AND CP.CONCURRENT_PROGRAM_ID = CR.CONCURRENT_PROGRAM_ID;
SELECT
SUBSTR(USER_DEAL_SUBTYPE
,1
,30)
INTO L_USER_DEAL_SUBTYPE
FROM
XTR_DEAL_SUBTYPES
WHERE
DEAL_SUBTYPE = DEAL_SUBTYPE_1
AND DEAL_TYPE = DEAL_TYPE_1;
SELECT
SUBSTR(MEANING
,1
,30)
INTO L_USER_DEAL_SUBTYPE
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'XTR_HEDGE_TYPES'
AND LOOKUP_CODE = DEAL_SUBTYPE_1;
SELECT
SUBSTR(USER_DEAL_TYPE
,1
,30)
INTO L_USER_DEAL_TYPE
FROM
XTR_DEAL_TYPES
WHERE DEAL_TYPE = DEAL_TYPE_1;
SELECT
MEANING
INTO L_USER_DEAL_TYPE
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'XTR_HEDGE_MISC'
AND LOOKUP_CODE = 'HEDGE';