[Home] [Help]
370: This procedure gets the balances for all the unique CCID's except for
371: EXPENSE, RESERVE and REVAL RESERVE CCID's. The total debit and credit
372: amounts for each CCID retrieved is stored in an array and each CCID
373: will have 1 entry in the array and running total is maintained. The
374: sum from FA_ADJUSTMENTS will give the entered balances and the sum
375: from FA_MC_ADJUSTMENTS will give the accounted balances.
376: ************************************************************************ */
377: -- join conditions added to the cursor inorder to resolve MRC Upgrade issue
378: CURSOR adj_bal IS
381: aj.code_combination_id,
382: aj.debit_credit_flag
383: FROM
384: fa_mc_adjustments maj,
385: fa_adjustments aj,
386: fa_mc_conversion_rates cr
387: WHERE
388: cr.set_of_books_id = p_rsob_id AND
389: maj.set_of_books_id = cr.set_of_books_id AND
417: l_index NUMBER;
418: BEGIN
419: if (g_print_debug) then
420: fa_debug_pkg.add('calculate_balances',
421: 'Getting Balances from FA_ADJUSTMENTS',
422: 'start');
423: end if;
424:
425: OPEN adj_bal;
488: CLOSE adj_bal;
489:
490: if (g_print_debug) then
491: fa_debug_pkg.add('calculate_balances',
492: 'Getting Balances from FA_ADJUSTMENTS',
493: 'success');
494: end if;
495:
496: /* Debug Statements to print contents of adjustments ccid array
957: p_book_type_code IN VARCHAR2) IS
958: /* ************************************************************************
959: This procedure gets the REVAL_RESERVE balances.
960: For all the reval reserve ccid's of assets that depreciated in the fiscal
961: year converted, the ccid is obtained from FA_ADJUSTMENTS. When a
962: revaluation is perfomed REVAL RESERVE rows are created in FA_ADJUSTMENTS
963: for each active distribution. If REVAL RESERVE is transferred, or retired
964: there will still be a row in FA_ADJUSTMENTS for the new distribution
965: ************************************************************************ */
958: /* ************************************************************************
959: This procedure gets the REVAL_RESERVE balances.
960: For all the reval reserve ccid's of assets that depreciated in the fiscal
961: year converted, the ccid is obtained from FA_ADJUSTMENTS. When a
962: revaluation is perfomed REVAL RESERVE rows are created in FA_ADJUSTMENTS
963: for each active distribution. If REVAL RESERVE is transferred, or retired
964: there will still be a row in FA_ADJUSTMENTS for the new distribution
965: ************************************************************************ */
966:
960: For all the reval reserve ccid's of assets that depreciated in the fiscal
961: year converted, the ccid is obtained from FA_ADJUSTMENTS. When a
962: revaluation is perfomed REVAL RESERVE rows are created in FA_ADJUSTMENTS
963: for each active distribution. If REVAL RESERVE is transferred, or retired
964: there will still be a row in FA_ADJUSTMENTS for the new distribution
965: ************************************************************************ */
966:
967: l_balance NUMBER;
968: l_ccid NUMBER;
977: aj.code_combination_id,
978: nvl(sum(dd.reval_reserve),0),
979: nvl(sum(mdd.reval_reserve),0)
980: FROM
981: fa_adjustments aj,
982: fa_deprn_detail dd,
983: fa_mc_deprn_detail mdd,
984: fa_mc_conversion_rates cr
985: WHERE