APPS.FV_SLA_UTL_PROCESSING_PKG dependencies on GL_BC_PACKETS

Line 1529: FROM gl_bc_packets gbc,

1525: trace(C_STATE_LEVEL, l_procedure_name, ' gl_balances l_tot_amount='||l_tot_amount);
1526:
1527: SELECT SUM(NVL(accounted_dr,0) - NVL(accounted_cr,0))
1528: INTO l_amount
1529: FROM gl_bc_packets gbc,
1530: gl_account_hierarchies gah
1531: WHERE gbc.ledger_id = p_Ledger_id
1532: AND gah.ledger_id = p_Ledger_id
1533: AND gah.template_id = l_template_id

Line 1541: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_amount='||l_amount);

1537: AND gbc.period_year = l_period_year
1538: AND gbc.period_num <= l_period_num
1539: AND gbc.status_code = 'A';
1540:
1541: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_amount='||l_amount);
1542:
1543: l_tot_amount := l_tot_amount + NVL(l_amount, 0);
1544:
1545: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_tot_amount='||l_tot_amount);

Line 1545: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_tot_amount='||l_tot_amount);

1541: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_amount='||l_amount);
1542:
1543: l_tot_amount := l_tot_amount + NVL(l_amount, 0);
1544:
1545: trace(C_STATE_LEVEL, l_procedure_name, ' gl_bc_packets l_tot_amount='||l_tot_amount);
1546: END LOOP;
1547: dbms_sql.close_cursor (l_fund_cur_id);
1548: END IF;
1549: