APPS.FA_MC_UPG3_PKG dependencies on FA_ADJUSTMENTS

Line 369: sum from FA_ADJUSTMENTS will give the entered balances and the sum

365: This procedure gets the balances for all the unique CCID's except for
366: EXPENSE, RESERVE and REVAL RESERVE CCID's. The total debit and credit
367: amounts for each CCID retrieved is stored in an array and each CCID
368: will have 1 entry in the array and running total is maintained. The
369: sum from FA_ADJUSTMENTS will give the entered balances and the sum
370: from FA_MC_ADJUSTMENTS will give the accounted balances.
371: ************************************************************************ */
372:
373: CURSOR adj_bal IS

Line 380: fa_adjustments aj,

376: aj.code_combination_id,
377: aj.debit_credit_flag
378: FROM
379: fa_mc_adjustments maj,
380: fa_adjustments aj,
381: fa_mc_conversion_rates cr
382: WHERE
383: cr.set_of_books_id = p_rsob_id AND
384: maj.set_of_books_id = cr.set_of_books_id AND

Line 412: 'Getting Balances from FA_ADJUSTMENTS',

408: l_index NUMBER;
409: BEGIN
410: if (g_print_debug) then
411: fa_debug_pkg.add('calculate_balances',
412: 'Getting Balances from FA_ADJUSTMENTS',
413: 'start');
414: end if;
415:
416: OPEN adj_bal;

Line 483: 'Getting Balances from FA_ADJUSTMENTS',

479: CLOSE adj_bal;
480:
481: if (g_print_debug) then
482: fa_debug_pkg.add('calculate_balances',
483: 'Getting Balances from FA_ADJUSTMENTS',
484: 'success');
485: end if;
486:
487: /* Debug Statements to print contents of adjustments ccid array

Line 952: year converted, the ccid is obtained from FA_ADJUSTMENTS. When a

948: p_book_type_code IN VARCHAR2) IS
949: /* ************************************************************************
950: This procedure gets the REVAL_RESERVE balances.
951: For all the reval reserve ccid's of assets that depreciated in the fiscal
952: year converted, the ccid is obtained from FA_ADJUSTMENTS. When a
953: revaluation is perfomed REVAL RESERVE rows are created in FA_ADJUSTMENTS
954: for each active distribution. If REVAL RESERVE is transferred, or retired
955: there will still be a row in FA_ADJUSTMENTS for the new distribution
956: ************************************************************************ */

Line 953: revaluation is perfomed REVAL RESERVE rows are created in FA_ADJUSTMENTS

949: /* ************************************************************************
950: This procedure gets the REVAL_RESERVE balances.
951: For all the reval reserve ccid's of assets that depreciated in the fiscal
952: year converted, the ccid is obtained from FA_ADJUSTMENTS. When a
953: revaluation is perfomed REVAL RESERVE rows are created in FA_ADJUSTMENTS
954: for each active distribution. If REVAL RESERVE is transferred, or retired
955: there will still be a row in FA_ADJUSTMENTS for the new distribution
956: ************************************************************************ */
957:

Line 955: there will still be a row in FA_ADJUSTMENTS for the new distribution

951: For all the reval reserve ccid's of assets that depreciated in the fiscal
952: year converted, the ccid is obtained from FA_ADJUSTMENTS. When a
953: revaluation is perfomed REVAL RESERVE rows are created in FA_ADJUSTMENTS
954: for each active distribution. If REVAL RESERVE is transferred, or retired
955: there will still be a row in FA_ADJUSTMENTS for the new distribution
956: ************************************************************************ */
957:
958: l_balance NUMBER;
959: l_ccid NUMBER;

Line 972: fa_adjustments aj,

968: aj.code_combination_id,
969: nvl(sum(dd.reval_reserve),0),
970: nvl(sum(mdd.reval_reserve),0)
971: FROM
972: fa_adjustments aj,
973: fa_deprn_detail dd,
974: fa_mc_deprn_detail mdd,
975: fa_mc_conversion_rates cr
976: WHERE