The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
DECODE(DEBIT_CREDIT_FLAG
,'CR'
,-ADJ.ADJUSTMENT_AMOUNT
,'DR'
,ADJ.ADJUSTMENT_AMOUNT)
INTO L_NEW_DEP_RSV
FROM
FA_ADJUSTMENTS ADJ
WHERE ADJ.TRANSACTION_HEADER_ID = TH_ID
AND ADJ.BOOK_TYPE_CODE = C_NEW_DEP_RSVFORMULA.BOOK_TYPE_CODE
AND ADJ.ASSET_ID = C_NEW_DEP_RSVFORMULA.ASSET_ID
AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'
AND ADJ.ADJUSTMENT_TYPE = 'RESERVE';
SELECT
DECODE(FLEX1.APPLICATION_COLUMN_NAME
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1) || DECODE(NVL(FLEX2.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX2.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ') || DECODE(NVL(FLEX3.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX3.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ') || DECODE(NVL(FLEX4.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX4.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ') || DECODE(NVL(FLEX5.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX5.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ') || DECODE(NVL(FLEX6.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX6.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ') || DECODE(NVL(FLEX7.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX7.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ')
INTO L_ASSET_CLASS
FROM
FA_CATEGORIES C,
FND_ID_FLEXS FLEXID,
FND_ID_FLEX_SEGMENTS FLEX1,
FND_ID_FLEX_SEGMENTS FLEX2,
FND_ID_FLEX_SEGMENTS FLEX3,
FND_ID_FLEX_SEGMENTS FLEX4,
FND_ID_FLEX_SEGMENTS FLEX5,
FND_ID_FLEX_SEGMENTS FLEX6,
FND_ID_FLEX_SEGMENTS FLEX7
WHERE C.CATEGORY_ID = P_ASSET_CLASS
AND FLEXID.APPLICATION_TABLE_NAME = 'FA_CATEGORIES_B'
AND FLEXID.UNIQUE_ID_COLUMN_NAME = 'CATEGORY_ID'
AND FLEX1.ID_FLEX_CODE = FLEXID.ID_FLEX_CODE
AND FLEX1.SEGMENT_NUM = 1
AND FLEX1.ENABLED_FLAG = 'Y'
AND flex2.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex2.enabled_flag (+) = 'Y'
AND flex2.segment_num (+) = 2
AND flex3.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex3.enabled_flag (+) = 'Y'
AND flex3.segment_num (+) = 3
AND flex4.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex4.enabled_flag (+) = 'Y'
AND flex4.segment_num (+) = 4
AND flex5.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex5.enabled_flag (+) = 'Y'
AND flex5.segment_num (+) = 5
AND flex6.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex6.enabled_flag (+) = 'Y'
AND flex6.segment_num (+) = 6
AND flex7.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex7.enabled_flag (+) = 'Y'
AND flex7.segment_num (+) = 7;
SELECT
DECODE(FLEX1.APPLICATION_COLUMN_NAME
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1) || DECODE(NVL(FLEX2.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX2.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ') || DECODE(NVL(FLEX3.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX3.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ') || DECODE(NVL(FLEX4.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX4.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ') || DECODE(NVL(FLEX5.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX5.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ') || DECODE(NVL(FLEX6.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX6.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ') || DECODE(NVL(FLEX7.APPLICATION_COLUMN_NAME
,' ')
,' '
,' '
,'-') || DECODE(NVL(FLEX7.APPLICATION_COLUMN_NAME
,' ')
,'SEGMENT7'
,C.SEGMENT7
,'SEGMENT6'
,C.SEGMENT6
,'SEGMENT5'
,C.SEGMENT5
,'SEGMENT4'
,C.SEGMENT4
,'SEGMENT3'
,C.SEGMENT3
,'SEGMENT2'
,C.SEGMENT2
,'SEGMENT1'
,C.SEGMENT1
,' ')
INTO L_ASSET_CLASS
FROM
FA_CATEGORIES C,
FND_ID_FLEXS FLEXID,
FND_ID_FLEX_SEGMENTS FLEX1,
FND_ID_FLEX_SEGMENTS FLEX2,
FND_ID_FLEX_SEGMENTS FLEX3,
FND_ID_FLEX_SEGMENTS FLEX4,
FND_ID_FLEX_SEGMENTS FLEX5,
FND_ID_FLEX_SEGMENTS FLEX6,
FND_ID_FLEX_SEGMENTS FLEX7
WHERE C.CATEGORY_ID = ASSET_CLASS
AND FLEXID.APPLICATION_TABLE_NAME = 'FA_CATEGORIES_B'
AND FLEXID.UNIQUE_ID_COLUMN_NAME = 'CATEGORY_ID'
AND FLEX1.ID_FLEX_CODE = FLEXID.ID_FLEX_CODE
AND FLEX1.SEGMENT_NUM = 1
AND FLEX1.ENABLED_FLAG = 'Y'
AND flex2.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex2.enabled_flag (+) = 'Y'
AND flex2.segment_num (+) = 2
AND flex3.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex3.enabled_flag (+) = 'Y'
AND flex3.segment_num (+) = 3
AND flex4.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex4.enabled_flag (+) = 'Y'
AND flex4.segment_num (+) = 4
AND flex5.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex5.enabled_flag (+) = 'Y'
AND flex5.segment_num (+) = 5
AND flex6.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex6.enabled_flag (+) = 'Y'
AND flex6.segment_num (+) = 6
AND flex7.id_flex_code (+) = FLEXID.ID_FLEX_CODE
AND flex7.enabled_flag (+) = 'Y'
AND flex7.segment_num (+) = 7;
SELECT
SUM(DECODE(DEBIT_CREDIT_FLAG
,'CR'
,ADJ.ADJUSTMENT_AMOUNT
,'DR'
,-ADJ.ADJUSTMENT_AMOUNT))
INTO L_TOT_REV_RSV
FROM
FA_ADJUSTMENTS ADJ
WHERE ADJ.ASSET_ID = C_OLD_REVAL_RSVFORMULA.ASSET_ID
AND ADJ.BOOK_TYPE_CODE = C_OLD_REVAL_RSVFORMULA.BOOK_TYPE_CODE
AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'
AND ADJ.ADJUSTMENT_TYPE = 'REVAL RESERVE';
SELECT
DECODE(DEBIT_CREDIT_FLAG
,'CR'
,ADJ.ADJUSTMENT_AMOUNT
,'DR'
,-ADJ.ADJUSTMENT_AMOUNT)
INTO L_NEW_REV_RSV
FROM
FA_ADJUSTMENTS ADJ
WHERE ADJ.TRANSACTION_HEADER_ID = TH_ID
AND ADJ.ASSET_ID = C_OLD_REVAL_RSVFORMULA.ASSET_ID
AND ADJ.BOOK_TYPE_CODE = C_OLD_REVAL_RSVFORMULA.BOOK_TYPE_CODE
AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'
AND ADJ.ADJUSTMENT_TYPE = 'REVAL RESERVE';
SELECT
SUM(DECODE(DEBIT_CREDIT_FLAG
,'CR'
,-ADJ.ADJUSTMENT_AMOUNT
,'DR'
,ADJ.ADJUSTMENT_AMOUNT))
INTO L_TOT_DEP_RSV
FROM
FA_ADJUSTMENTS ADJ
WHERE ADJ.ASSET_ID = C_OLD_DEP_RSVFORMULA.ASSET_ID
AND ADJ.BOOK_TYPE_CODE = C_OLD_DEP_RSVFORMULA.BOOK_TYPE_CODE
AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'
AND ADJ.ADJUSTMENT_TYPE = 'RESERVE';
SELECT
DECODE(DEBIT_CREDIT_FLAG
,'CR'
,-ADJ.ADJUSTMENT_AMOUNT
,'DR'
,ADJ.ADJUSTMENT_AMOUNT)
INTO L_NEW_DEP_RSV
FROM
FA_ADJUSTMENTS ADJ
WHERE ADJ.TRANSACTION_HEADER_ID = TH_ID
AND ADJ.ASSET_ID = C_OLD_DEP_RSVFORMULA.ASSET_ID
AND ADJ.BOOK_TYPE_CODE = C_OLD_DEP_RSVFORMULA.BOOK_TYPE_CODE
AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'
AND ADJ.ADJUSTMENT_TYPE = 'RESERVE';