APPS.FII_AR_REVENUE_B_C dependencies on FII_AR_REVENUE_RATES_TEMP

Line 1475: FROM FII_AR_REVENUE_RATES_TEMP

1471: CURSOR c3 IS SELECT DISTINCT FUNCTIONAL_CURRENCY,
1472: decode( prim_conversion_rate,
1473: -3, to_date( '01/01/1999', 'MM/DD/YYYY' ),
1474: trunc(least(TRX_DATE,sysdate))) TRX_DATE
1475: FROM FII_AR_REVENUE_RATES_TEMP
1476: WHERE prim_conversion_rate < 0;
1477:
1478: CURSOR c4 IS SELECT DISTINCT FUNCTIONAL_CURRENCY,
1479: decode( sec_conversion_RATE,

Line 1482: FROM FII_AR_REVENUE_RATES_TEMP

1478: CURSOR c4 IS SELECT DISTINCT FUNCTIONAL_CURRENCY,
1479: decode( sec_conversion_RATE,
1480: -3, to_date( '01/01/1999', 'MM/DD/YYYY' ),
1481: trunc(least(TRX_DATE,sysdate))) TRX_DATE
1482: FROM FII_AR_REVENUE_RATES_TEMP
1483: WHERE sec_conversion_RATE < 0;
1484:
1485: BEGIN
1486:

Line 1505: FROM FII_AR_REVENUE_RATES_TEMP

1501: -- Bug 4942753: Change to return 1 if any row exists
1502: BEGIN
1503: SELECT 1
1504: INTO l_miss_rates
1505: FROM FII_AR_REVENUE_RATES_TEMP
1506: WHERE ((prim_conversion_rate < 0) OR (sec_conversion_rate < 0))
1507: AND ROWNUM = 1;
1508: EXCEPTION
1509: WHEN NO_DATA_FOUND THEN

Line 1565: FROM FII_AR_REVENUE_RATES_TEMP

1561: -- Bug 4942753: Change to return 1 if any row exists
1562: BEGIN
1563: SELECT 1
1564: INTO l_miss_rates_prim
1565: FROM FII_AR_REVENUE_RATES_TEMP
1566: WHERE prim_conversion_rate < 0
1567: AND ROWNUM = 1;
1568: EXCEPTION
1569: WHEN NO_DATA_FOUND THEN

Line 1577: FROM FII_AR_REVENUE_RATES_TEMP

1573: -- Bug 4942753: Change to return 1 if any row exists
1574: BEGIN
1575: SELECT 1
1576: INTO l_miss_rates_sec
1577: FROM FII_AR_REVENUE_RATES_TEMP
1578: WHERE sec_conversion_rate < 0
1579: AND ROWNUM = 1;
1580: EXCEPTION
1581: WHEN NO_DATA_FOUND THEN

Line 3462: insert into fii_ar_revenue_rates_temp

3458: fii_util.put_line('');
3459: end if;
3460:
3461:
3462: insert into fii_ar_revenue_rates_temp
3463: (FUNCTIONAL_CURRENCY,
3464: TRX_DATE,
3465: PRIM_CONVERSION_RATE,
3466: SEC_CONVERSION_RATE)

Line 3602: FROM fii_ar_revenue_rates_temp rates, FII_AR_REVENUE_STG stg

3598: stg.invoice_date,
3599: stg.fin_cat_type_code,
3600: stg.REV_BOOKED_DATE,
3601: stg.CHILD_ORDER_LINE_ID
3602: FROM fii_ar_revenue_rates_temp rates, FII_AR_REVENUE_STG stg
3603: where TRUNC(stg.GL_DATE) = rates.trx_date
3604: and stg.functional_currency = rates.functional_currency;
3605:
3606: if g_debug_flag = 'Y' then