310: COUNT(FDD.DEPRN_ADJUSTMENT_AMOUNT),
311: SUM(FDD.DEPRN_ADJUSTMENT_AMOUNT)
312: INTO L_HAS_RESERVE_ADJUSTMENT,L_TOTAL_DEPRN_ADJUSTMENT
313: FROM
314: FA_DEPRN_DETAIL_MRC_V FDD
315: WHERE FDD.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
316: AND FDD.ASSET_ID = T_ASSET_ID
317: AND FDD.PERIOD_COUNTER between T_PERIOD_START
318: AND T_PERIOD_END
462: COUNT(FDD.DEPRN_ADJUSTMENT_AMOUNT),
463: SUM(FDD.DEPRN_ADJUSTMENT_AMOUNT)
464: INTO L_HAS_RESERVE_ADJUSTMENT,L_TOTAL_DEPRN_ADJUSTMENT
465: FROM
466: FA_DEPRN_DETAIL FDD
467: WHERE FDD.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
468: AND FDD.ASSET_ID = T_ASSET_ID
469: AND FDD.PERIOD_COUNTER between T_PERIOD_START
470: AND T_PERIOD_END
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';
965: LP_FA_BOOKS := 'FA_BOOKS';
966: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
965: LP_FA_BOOKS := 'FA_BOOKS';
966: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
967: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
968: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';
969: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL';
970: END IF;
971: RETURN (TRUE);
972: END AFTERPFORM;
973: