DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on GL_CODE_COMBINATIONS

Line 1152: gl_code_combinations glcc,

1148: DECODE(CE_CASH_FCST.G_rp_exchange_type,'User',CE_CASH_FCST.G_rp_exchange_rate,curr.exchange_rate))
1149: INTO l_end_of_day
1150: FROM gl_daily_balances gdb,
1151: gl_sets_of_books org,
1152: gl_code_combinations glcc,
1153: ce_currency_rates_temp curr
1154: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1155: AND curr.currency_code = gdb.currency_code
1156: AND gdb.period_name = l_period_name

Line 1224: gl_code_combinations glcc,

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
1226: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1227: AND curr.currency_code = src.currency_code
1228: AND src.period_name = gp.period_name

Line 1266: gl_code_combinations glcc,

1262: INTO bal_to_date
1263: FROM gl_je_lines jl,
1264: gl_je_headers jh,
1265: gl_sets_of_books org,
1266: gl_code_combinations glcc,
1267: ce_currency_rates_temp curr
1268: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1269: AND curr.currency_code = jh.currency_code
1270: AND jl.effective_date <= CE_CASH_FCST.G_rp_forecast_start_date

Line 1303: gl_code_combinations glcc,

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
1306: AND curr.currency_code = src.currency_code
1307: AND src.period_name = CE_CASH_FCST.G_rp_forecast_start_period