APPS.CE_CSH_FCST_POP dependencies on GL_SETS_OF_BOOKS

Line 504: gl_sets_of_books org ';

500: from_clause := from_clause || ' ,
501: ce_forecast_oe_orgs_v org ';
502: ELSIF(CE_CASH_FCST.G_app_short_name = 'XTR')THEN
503: from_clause := from_clause || ' ,
504: gl_sets_of_books org ';
505: END IF;
506: END IF;
507:
508: --

Line 785: FROM GL_SETS_OF_BOOKS

781: ELSIF( CE_CASH_FCST.G_set_of_books_id IS NOT NULL AND
782: CE_CASH_FCST.G_set_of_books_id <> -1) THEN
783: where_clause := where_clause ||'
784: AND (src.set_of_books_id IN (SELECT DISTINCT(set_of_books_id)
785: FROM GL_SETS_OF_BOOKS
786: WHERE set_of_books_id = '||to_char(CE_CASH_FCST.G_set_of_books_id)||' )) ';
787: END IF;
788: ELSE
789: IF( CE_CASH_FCST.G_org_id <> -1 AND CE_CASH_FCST.G_org_id <> -99 )THEN

Line 1151: gl_sets_of_books org,

1147: 35, NVL(PERIOD_AGGREGATE35,0)-NVL(PERIOD_AGGREGATE34,0),0)*
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

Line 1222: gl_sets_of_books org,

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
1226: WHERE curr.forecast_request_id = CE_CASH_FCST.G_forecast_id

Line 1265: gl_sets_of_books org,

1261: DECODE(CE_CASH_FCST.G_rp_exchange_type, 'User', CE_CASH_FCST.G_rp_exchange_rate, curr.exchange_rate)),0)
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

Line 1302: gl_sets_of_books org,

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