APPS.XTR_MARKET_DATA_INTERFACE_P dependencies on GL_DAILY_RATES_INTERFACE

Line 945: FROM gl_daily_rates_interface

941: ORDER BY outer.currency;
942:
943: cursor get_failed_imports(p_start_date DATE,p_end_date DATE) is
944: SELECT DECODE(FROM_CURRENCY,'USD',TO_CURRENCY,FROM_CURRENCY) CURRENCY,NVL(ERROR_CODE,'VALIDATION_FAILURE') ERROR_CODE
945: FROM gl_daily_rates_interface
946: WHERE MODE_FLAG in ('X','F')
947: AND FROM_CONVERSION_DATE=p_start_date
948: AND TO_CONVERSION_DATE=p_end_date
949: AND USER_ID=fnd_global.user_id

Line 1006: insert into gl_daily_rates_interface(

1002: end if;
1003:
1004: put_log(rpad(p_currency,15)||rpad(p_rate,15)||rpad(1/p_rate,15));
1005:
1006: insert into gl_daily_rates_interface(
1007: FROM_CURRENCY,
1008: TO_CURRENCY,
1009: FROM_CONVERSION_DATE,
1010: TO_CONVERSION_DATE,

Line 1092: delete from gl_daily_rates_interface

1088: end if;
1089: put_log(rpad(c_error.currency,15)||rpad(c_error.error_code,30));
1090: end loop;
1091:
1092: delete from gl_daily_rates_interface
1093: where MODE_FLAG in ('X','F')
1094: and USER_ID=fnd_global.user_id
1095: and FROM_CONVERSION_DATE=TO_CONVERSION_DATE
1096: and FROM_CONVERSION_DATE>=v_start_date