The following lines contain the word 'select', 'insert', 'update' or 'delete':
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_T
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_T
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 = 'XTRCCYGL';
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_P
AND DEAL_TYPE = DEAL_TYPE_P;
SELECT
SUBSTR(MEANING
,1
,30)
INTO
L_USER_DEAL_SUBTYPE
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'XTR_HEDGE_TYPES'
AND LOOKUP_CODE = DEAL_SUBTYPE_p;
SELECT
SUBSTR(USER_DEAL_TYPE
,1
,30)
INTO
L_USER_DEAL_TYPE
FROM
XTR_DEAL_TYPES
WHERE DEAL_TYPE = DEAL_TYPE_p;
SELECT
SUBSTR(MEANING
,1
,30)
INTO
L_USER_DEAL_TYPE
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'XTR_HEDGE_MISC'
AND LOOKUP_CODE = 'HEDGE';
SELECT
A.FAIR_VALUE
FROM
XTR_REVALUATION_DETAILS_SUM_V A,
XTR_BATCHES B
WHERE A.COMPANY_CODE = COMPANY_p
AND A.COMPANY_CODE = B.COMPANY_CODE
AND A.BATCH_ID = B.BATCH_ID
AND A.REF_NUMBER = REF_NUMBER_P
AND B.PERIOD_END <= PERIOD_END_p
AND A.REALIZED_FLAG = P_REALIZED_FLAG_T
ORDER BY
B.PERIOD_END DESC;
SELECT
INITIAL_FAIR_VALUE
FROM
XTR_DEALS
WHERE DEAL_NO = REF_NUMBER_p;
SELECT
SUM(INITIAL_FAIR_VALUE)
FROM
XTR_ROLLOVER_TRANSACTIONS
WHERE DEAL_NUMBER = REF_NUMBER_p;
SELECT
SUM(INITIAL_FAIR_VALUE)
FROM
XTR_DEALS
WHERE INT_SWAP_REF = REF_NUMBER_p;
SELECT
FAIR_VALUE
FROM
XTR_REVALUATION_DETAILS
WHERE ACCOUNT_NO = REF_NUMBER_P
AND DEAL_TYPE = 'CA'
AND BATCH_ID = BATCH_ID_P
AND EFFECTIVE_DATE = (
SELECT
MAX(EFFECTIVE_DATE)
FROM
XTR_REVALUATION_DETAILS
WHERE ACCOUNT_NO = REF_NUMBER_p
AND DEAL_TYPE = 'CA'
AND BATCH_ID = BATCH_ID_p );
SELECT
FAIR_VALUE
FROM
XTR_REVALUATION_DETAILS
WHERE DEAL_NO = TO_NUMBER(REF_NUMBER_p)
AND DEAL_TYPE = 'IG'
AND BATCH_ID = BATCH_ID_p
AND EFFECTIVE_DATE = (
SELECT
MAX(EFFECTIVE_DATE)
FROM
XTR_REVALUATION_DETAILS
WHERE DEAL_NO = REF_NUMBER_p
AND DEAL_TYPE = 'IG'
AND BATCH_ID = BATCH_ID_p );
SELECT
SUM(FACE_VALUE)
FROM
XTR_REVALUATION_DETAILS
WHERE DEAL_NO = TO_NUMBER(REF_NUMBER_p)
AND DEAL_TYPE = 'ONC'
AND BATCH_ID = BATCH_ID_p
AND NVL(REALIZED_FLAG
,'N') = 'N'
AND ( ( COMPLETE_FLAG = 'Y'
AND TRANSACTION_NO in (
SELECT
TRANSACTION_NUMBER
FROM
XTR_ROLLOVER_TRANSACTIONS
WHERE DEAL_NUMBER = TO_NUMBER(REF_NUMBER_p)
AND START_DATE <= PERIOD_END_p
AND ( CROSS_REF_TO_TRANS is null
OR CROSS_REF_TO_TRANS not in (
SELECT
TRANSACTION_NO
FROM
XTR_REVALUATION_DETAILS
WHERE DEAL_NO = TO_NUMBER(REF_NUMBER_p)
AND BATCH_ID = BATCH_ID_p ) ) ) )
OR ( COMPLETE_FLAG = 'N'
AND TRANSACTION_NO = 1 ) );
SELECT
INITIAL_FAIR_VALUE
INTO
L_FAIR_VALUE
FROM
XTR_DEALS
WHERE DEAL_NO = REF_NUMBER_p;
SELECT
ROUND(A.EXCHANGE_RATE_ONE
,4)
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_p
AND B.PERIOD_END < PERIOD_START_p
AND A.REALIZED_FLAG = P_REALIZED_FLAG_T
ORDER BY
PERIOD_START desc;
SELECT
EXCHANGE_RATE_ONE
FROM
XTR_DEALS
WHERE DEAL_NO = REF_NUMBER_p;
SELECT
AVG(EXCHANGE_RATE_ONE)
FROM
XTR_DEALS
WHERE INT_SWAP_REF = REF_NUMBER_p;
SELECT
AVG(CURRENCY_EXCHANGE_RATE)
FROM
XTR_ROLLOVER_TRANSACTIONS
WHERE DEAL_NUMBER = REF_NUMBER_p;
SELECT
A.EXCHANGE_RATE_ONE
FROM
XTR_REVALUATION_DETAILS_SUM_V A,
XTR_BATCHES B
WHERE A.COMPANY_CODE = COMPANY_P
AND A.COMPANY_CODE = B.COMPANY_CODE
AND A.BATCH_ID = B.BATCH_ID
AND A.REF_NUMBER = REF_NUMBER_p
AND B.PERIOD_END <= PERIOD_END_p
AND A.REALIZED_FLAG = P_REALIZED_FLAG_T
ORDER BY
PERIOD_START DESC;
SELECT
EXCHANGE_RATE_ONE
FROM
XTR_DEALS
WHERE DEAL_NO = REF_NUMBER_p;
SELECT
CURRENCY_CODE
INTO
L_SOB_CCY
FROM
GL_SETS_OF_BOOKS B,
XTR_PARTY_INFO P
WHERE PARTY_CODE = COMPANY
AND PARTY_TYPE = 'C'
AND P.SET_OF_BOOKS_ID = B.SET_OF_BOOKS_ID;
SELECT
ROUNDING_FACTOR
FROM
XTR_MASTER_CURRENCIES_V
WHERE CURRENCY = REVAL_CCY;
SELECT
ROUNDING_FACTOR
FROM
XTR_MASTER_CURRENCIES_V
WHERE CURRENCY = REVAL_CCY;
SELECT
ROUNDING_FACTOR
FROM
XTR_MASTER_CURRENCIES_V
WHERE CURRENCY = REVAL_CCY;