DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on GL_BALANCES

Line 1221: FROM gl_balances src,

1217: nvl(SUM((nvl(src.begin_balance_dr,0)-nvl(src.begin_balance_cr,0))*
1218: DECODE(CE_CASH_FCST.G_rp_exchange_type, 'User', CE_CASH_FCST.G_rp_exchange_rate, curr.exchange_rate)),0)
1219: INTO begin_period,
1220: begin_cash_bal
1221: FROM gl_balances src,
1222: gl_sets_of_books org,
1223: gl_periods gp,
1224: gl_code_combinations glcc,
1225: ce_currency_rates_temp curr

Line 1301: FROM gl_balances src,

1297: ELSE
1298: SELECT SUM((nvl(src.begin_balance_dr,0)-nvl(src.begin_balance_cr,0))*
1299: DECODE(CE_CASH_FCST.G_rp_exchange_type, 'User', CE_CASH_FCST.G_rp_exchange_rate, curr.exchange_rate))
1300: INTO initial_cash_pos
1301: FROM gl_balances src,
1302: gl_sets_of_books org,
1303: gl_code_combinations glcc,
1304: ce_currency_rates_temp curr
1305: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 2655: FROM gl_balances src,

2651: (nvl(src.period_net_dr,0)-nvl(src.period_net_cr,0))'; --bug4495616
2652: END IF;
2653:
2654: main_query := main_query || '
2655: FROM gl_balances src,
2656: gl_periods gp,
2657: ce_forecast_ext_temp cab ';
2658:
2659: IF( CE_CASH_FCST.G_rp_exchange_type <> 'User' OR