APPS.FII_GL_JE_B_C dependencies on FII_GL_REVENUE_RATES_TEMP

Line 200: FROM fii_gl_revenue_rates_temp

196: functional_currency,
197: decode( prim_conversion_rate,
198: -3, to_date( '01/01/1999', 'MM/DD/YYYY' ),
199: least(sysdate, trx_date) ) trx_date
200: FROM fii_gl_revenue_rates_temp
201: WHERE prim_conversion_rate < 0;
202:
203: --bug 3677737: use least(sysdate, trx_date) to replace trx_date
204: cursor SecMissingRate is

Line 210: FROM fii_gl_revenue_rates_temp

206: functional_currency,
207: decode( sec_conversion_rate,
208: -3, to_date( '01/01/1999', 'MM/DD/YYYY' ),
209: least(sysdate, trx_date) ) trx_date
210: FROM fii_gl_revenue_rates_temp
211: WHERE sec_conversion_rate < 0;
212:
213: BEGIN
214:

Line 742: FROM FII_GL_REVENUE_RATES_TEMP;

738: g_phase := 'For p_program_type = L ';
739: SELECT MIN(trx_date), MAX(trx_date), sum(decode(sign(prim_conversion_rate), -1, 1, 0)) +
740: sum(decode(sign(sec_conversion_rate), -1, 1, 0)), count(*)
741: INTO l_stg_min, l_stg_max, l_conv_rate_cnt, l_row_cnt
742: FROM FII_GL_REVENUE_RATES_TEMP;
743:
744: ELSE
745:
746: g_phase := 'For p_program_type <> L ';

Line 2443: g_phase := 'Inserting into fii_gl_revenue_rates_temp';

2439: fii_util.start_timer;
2440: fii_util.put_line('');
2441: end if;
2442:
2443: g_phase := 'Inserting into fii_gl_revenue_rates_temp';
2444: insert into fii_gl_revenue_rates_temp
2445: (FUNCTIONAL_CURRENCY,
2446: TRX_DATE,
2447: PRIM_CONVERSION_RATE,

Line 2444: insert into fii_gl_revenue_rates_temp

2440: fii_util.put_line('');
2441: end if;
2442:
2443: g_phase := 'Inserting into fii_gl_revenue_rates_temp';
2444: insert into fii_gl_revenue_rates_temp
2445: (FUNCTIONAL_CURRENCY,
2446: TRX_DATE,
2447: PRIM_CONVERSION_RATE,
2448: SEC_CONVERSION_RATE)

Line 2462: g_phase := 'Calling FND_STATS to collect statistics for fii_gl_revenue_rates_temp';

2458: );
2459:
2460:
2461: --Call FND_STATS to collect statistics after populating the table
2462: g_phase := 'Calling FND_STATS to collect statistics for fii_gl_revenue_rates_temp';
2463: FND_STATS.gather_table_stats
2464: (ownname => g_fii_schema,
2465: tabname => 'FII_GL_REVENUE_RATES_TEMP');
2466:

Line 2465: tabname => 'FII_GL_REVENUE_RATES_TEMP');

2461: --Call FND_STATS to collect statistics after populating the table
2462: g_phase := 'Calling FND_STATS to collect statistics for fii_gl_revenue_rates_temp';
2463: FND_STATS.gather_table_stats
2464: (ownname => g_fii_schema,
2465: tabname => 'FII_GL_REVENUE_RATES_TEMP');
2466:
2467: g_phase := 'Enabling parallel dml';
2468: execute immediate 'alter session enable parallel dml';
2469:

Line 2471: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_gl_revenue_rates_temp');

2467: g_phase := 'Enabling parallel dml';
2468: execute immediate 'alter session enable parallel dml';
2469:
2470: if g_debug_flag = 'Y' then
2471: fii_util.put_line('Inserted '||SQL%ROWCOUNT||' rows into fii_gl_revenue_rates_temp');
2472: fii_util.stop_timer;
2473: fii_util.print_timer('Duration');
2474: end if;
2475:

Line 2565: FROM FII_GL_JE_SUMMARY_STG stg, fii_gl_revenue_rates_temp r

2561: stg.created_by,
2562: stg.last_update_date,
2563: stg.last_update_login,
2564: stg.last_updated_by
2565: FROM FII_GL_JE_SUMMARY_STG stg, fii_gl_revenue_rates_temp r
2566: where stg.year IS NOT NULL
2567: AND stg.effective_date = r.trx_date
2568: AND stg.functional_currency = r.functional_currency
2569: GROUP BY stg.day,