[Home] [Help]
586: -- Function to derive the balance amount for the fund and antipicated segment
587: -- returns the period balances for the account
588: -- Logic
589: -- 1. with the inputs constructs the CCID
590: -- 2. queries the gl_balances for the period and returns the balances
591: --
592: --
593: FUNCTION get_anticipated_fund_amt( p_Fund_value IN VARCHAR2,
594: p_Balancing_segment IN NUMBER,
737:
738: /*SELECT SUM((begin_balance_dr - begin_balance_cr) +
739: (period_net_dr - period_net_cr))
740: INTO l_amount
741: FROM Gl_Balances
742: WHERE ledger_id = p_Ledger_id
743: --AND currency_code = vp_currency_code
744: AND code_combination_id = l_ccid
745: AND period_name = p_period_name;
763: trace(C_STATE_LEVEL, l_procedure_name, 'l_currency_code='||l_currency_code);
764: SELECT SUM((begin_balance_dr - begin_balance_cr) +
765: (period_net_dr - period_net_cr))
766: INTO l_amount
767: FROM Gl_Balances
768: WHERE ledger_id = p_Ledger_id
769: AND currency_code = l_currency_code
770: AND code_combination_id = l_ccid
771: AND period_name = p_period_name;
768: WHERE ledger_id = p_Ledger_id
769: AND currency_code = l_currency_code
770: AND code_combination_id = l_ccid
771: AND period_name = p_period_name;
772: trace(C_STATE_LEVEL, l_procedure_name, ' gl_balances l_amount='||l_amount);
773: -------------------------------------------------------------------------
774: /* l_amount := 0;
775: l_amount := gl_funds_available_pkg.calc_funds(
776: l_ccid ,
782: trace(C_STATE_LEVEL, l_procedure_name, ' gl_funds_available_pkg l_amount='||l_amount);
783: */
784: l_tot_amount := l_tot_amount + NVL(l_amount, 0);
785:
786: trace(C_STATE_LEVEL, l_procedure_name, ' gl_balances l_tot_amount='||l_tot_amount);
787:
788: SELECT SUM(NVL(accounted_dr,0) - NVL(accounted_cr,0))
789: INTO l_amount
790: FROM Gl_bc_packets gbc,