[Home] [Help]
266: COUNT(RET.RETIREMENT_ID)
267: INTO L_HAS_RETIREMENT
268: FROM
269: FA_RETIREMENTS_MRC_V RET,
270: FA_DEPRN_PERIODS_MRC_V FDP
271: WHERE RET.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
272: AND RET.STATUS <> 'DELETED'
273: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
274: AND RET.ASSET_ID = T_ASSET_ID
289: BKS.COST
290: INTO L_COST_BEGIN_YEAR
291: FROM
292: FA_BOOKS_MRC_V BKS,
293: FA_DEPRN_PERIODS_MRC_V DPP
294: WHERE DPP.PERIOD_COUNTER = T_PERIOD_START
295: AND BKS.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
296: AND DPP.BOOK_TYPE_CODE = BKS.BOOK_TYPE_CODE
297: AND BKS.ASSET_ID = T_ASSET_ID
351: RET.COST_RETIRED
352: INTO L_COST_RETIRED
353: FROM
354: FA_RETIREMENTS_MRC_V RET,
355: FA_DEPRN_PERIODS_MRC_V FDP
356: WHERE RET.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
357: AND RET.STATUS <> 'DELETED'
358: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
359: AND RET.ASSET_ID = T_ASSET_ID
748: MIN(PERIOD_COUNTER),
749: MAX(PERIOD_COUNTER)
750: INTO MIN_PER_COUNTER,MAX_PER_COUNTER
751: FROM
752: FA_DEPRN_PERIODS_MRC_V
753: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
754: AND FISCAL_YEAR = P_CURR_FY;
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN
765: SELECT
766: MAX(PERIOD_COUNTER)
767: INTO LAST_PER_COUNTER
768: FROM
769: FA_DEPRN_PERIODS_MRC_V
770: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
771: AND FISCAL_YEAR = P_CURR_FY - 1;
772: EXCEPTION
773: WHEN NO_DATA_FOUND THEN
956: IF UPPER(P_MRCSOBTYPE) = 'R' THEN
957: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
958: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
959: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
960: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
961: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
962: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
963: ELSE
964: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';