DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on GL_BALANCES

Line 1153: FROM gl_balances src,

1149: nvl(SUM((nvl(src.begin_balance_dr,0)-nvl(src.begin_balance_cr,0))*
1150: DECODE(CE_CASH_FCST.G_rp_exchange_type, 'User', CE_CASH_FCST.G_rp_exchange_rate, curr.exchange_rate)),0)
1151: INTO begin_period,
1152: begin_cash_bal
1153: FROM gl_balances src,
1154: gl_sets_of_books org,
1155: gl_periods gp,
1156: gl_code_combinations glcc,
1157: ce_currency_rates_temp curr

Line 1232: FROM gl_balances src,

1228: ELSE
1229: SELECT SUM((nvl(src.begin_balance_dr,0)-nvl(src.begin_balance_cr,0))*
1230: DECODE(CE_CASH_FCST.G_rp_exchange_type, 'User', CE_CASH_FCST.G_rp_exchange_rate, curr.exchange_rate))
1231: INTO initial_cash_pos
1232: FROM gl_balances src,
1233: gl_sets_of_books org,
1234: gl_code_combinations glcc,
1235: ce_currency_rates_temp curr
1236: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 2579: FROM gl_balances src,

2575: (nvl(src.period_net_dr,0)-nvl(src.period_net_cr,0))'; --bug4495616
2576: END IF;
2577:
2578: main_query := main_query || '
2579: FROM gl_balances src,
2580: gl_periods gp,
2581: ce_forecast_ext_temp cab ';
2582:
2583: IF( CE_CASH_FCST.G_rp_exchange_type <> 'User' OR