APPS.FII_AP_INV_SUM_INC dependencies on FII_AP_RATES_GT

Line 510: INSERT INTO FII_AP_RATES_GT(

506:
507: BEGIN
508:
509:
510: INSERT INTO FII_AP_RATES_GT(
511: Trx_Currency,
512: Func_Currency,
513: Exchange_Date,
514: Exchange_Rate_Type,

Line 565: FROM FII_AP_RATES_GT);

561: least(Trx_Date,sysdate))) SEC_CONVERSION_RATE
562: FROM (SELECT /*+ no_merge */ DISTINCT
563: Func_Currency Functional_Currency,
564: Invoice_Date Trx_Date
565: FROM FII_AP_RATES_GT);
566:
567: if g_debug_flag = 'Y' then
568: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');
569: fii_util.stop_timer;

Line 606: FROM FII_AP_RATES_GT);

602: Exchange_Date Trx_Date,
603: Exchange_Rate_Type,
604: DECODE(Exchange_Rate_Type, 'User', Exchange_Rate, null) Exchange_Rate,
605: Functional_MAU
606: FROM FII_AP_RATES_GT);
607:
608:
609: if g_debug_flag = 'Y' then
610: fii_util.put_line('Processed '||SQL%ROWCOUNT||' rows');