[Home] [Help]
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,
791: gl_account_hierarchies gah
792: WHERE gbc.ledger_id = p_Ledger_id
793: AND gah.ledger_id = p_Ledger_id
794: AND gah.template_id = l_template_id
797: AND gbc.code_combination_id = gah.detail_code_combination_id
798: AND gbc.period_year = l_period_year
799: AND gbc.period_num <= l_period_num
800: AND gbc.status_code = 'A';
801: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_amount='||l_amount);
802:
803: l_tot_amount := l_tot_amount + NVL(l_amount, 0);
804:
805: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_tot_amount='||l_tot_amount);
801: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_amount='||l_amount);
802:
803: l_tot_amount := l_tot_amount + NVL(l_amount, 0);
804:
805: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_tot_amount='||l_tot_amount);
806: END LOOP;
807: dbms_sql.close_cursor (l_fund_cur_id);
808: RETURN l_tot_amount;
809: -------------------------------------------------------------------------
1027: and xah.event_id = pbd.ae_event_id
1028: and xah.accounting_entry_status_code = 'F'));
1029:
1030: --currently we are using only po_bc_distributions only, but infuture we may
1031: --have to use gl_bc_packets or xla_events
1032:
1033: /*Get all the distribution ids in p_event_id event which belong to the same document*/
1034: CURSOR c_get_dist_ids IS
1035: SELECT pbd.distribution_id,pbd.code_combination_id,pbd.accounted_amt