DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on GL_CODE_COMBINATIONS

Line 1084: gl_code_combinations glcc,

1080: DECODE(CE_CASH_FCST.G_rp_exchange_type,'User',CE_CASH_FCST.G_rp_exchange_rate,curr.exchange_rate))
1081: INTO l_end_of_day
1082: FROM gl_daily_balances gdb,
1083: gl_sets_of_books org,
1084: gl_code_combinations glcc,
1085: ce_currency_rates_temp curr
1086: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1087: AND curr.currency_code = gdb.currency_code
1088: AND gdb.period_name = l_period_name

Line 1156: gl_code_combinations glcc,

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
1158: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1159: AND curr.currency_code = src.currency_code
1160: AND src.period_name = gp.period_name

Line 1197: gl_code_combinations glcc,

1193: INTO bal_to_date
1194: FROM gl_je_lines jl,
1195: gl_je_headers jh,
1196: gl_sets_of_books org,
1197: gl_code_combinations glcc,
1198: ce_currency_rates_temp curr
1199: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id
1200: AND curr.currency_code = jh.currency_code
1201: AND jl.effective_date <= CE_CASH_FCST.G_rp_forecast_start_date

Line 1234: gl_code_combinations glcc,

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