APPS.CE_CSH_FCST_POP dependencies on GL_SETS_OF_BOOKS

Line 443: gl_sets_of_books org ';

439: from_clause := from_clause || ' ,
440: ce_forecast_oe_orgs_v org ';
441: ELSIF(CE_CASH_FCST.G_app_short_name = 'XTR')THEN
442: from_clause := from_clause || ' ,
443: gl_sets_of_books org ';
444: END IF;
445: END IF;
446:
447: --

Line 724: FROM GL_SETS_OF_BOOKS

720: ELSIF( CE_CASH_FCST.G_set_of_books_id IS NOT NULL AND
721: CE_CASH_FCST.G_set_of_books_id <> -1) THEN
722: where_clause := where_clause ||'
723: AND (src.set_of_books_id IN (SELECT DISTINCT(set_of_books_id)
724: FROM GL_SETS_OF_BOOKS
725: WHERE set_of_books_id = '||to_char(CE_CASH_FCST.G_set_of_books_id)||' )) ';
726: END IF;
727: ELSE
728: IF( CE_CASH_FCST.G_org_id <> -1 AND CE_CASH_FCST.G_org_id <> -99 )THEN

Line 1083: gl_sets_of_books org,

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

Line 1154: gl_sets_of_books org,

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

Line 1196: gl_sets_of_books org,

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

Line 1233: gl_sets_of_books org,

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