eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_SLA_UTL_PROCESSING_PKG dependencies on GL_BALANCES

Line 1515: FROM gl_balances

1511:
1512: SELECT SUM((begin_balance_dr - begin_balance_cr) +
1513: (period_net_dr - period_net_cr))
1514: INTO l_amount
1515: FROM gl_balances
1516: WHERE ledger_id = p_Ledger_id
1517: AND currency_code = l_ledger_info.currency_code
1518: AND code_combination_id = l_ccid
1519: AND period_name = l_period_name;

Line 1521: trace(C_STATE_LEVEL, l_procedure_name, ' gl_balances l_amount='||l_amount);

1517: AND currency_code = l_ledger_info.currency_code
1518: AND code_combination_id = l_ccid
1519: AND period_name = l_period_name;
1520:
1521: trace(C_STATE_LEVEL, l_procedure_name, ' gl_balances l_amount='||l_amount);
1522:
1523: l_tot_amount := l_tot_amount + NVL(l_amount, 0);
1524:
1525: trace(C_STATE_LEVEL, l_procedure_name, ' gl_balances l_tot_amount='||l_tot_amount);

Line 1525: trace(C_STATE_LEVEL, l_procedure_name, ' gl_balances l_tot_amount='||l_tot_amount);

1521: trace(C_STATE_LEVEL, l_procedure_name, ' gl_balances l_amount='||l_amount);
1522:
1523: l_tot_amount := l_tot_amount + NVL(l_amount, 0);
1524:
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,