APPS.XTR_MARKET_DATA_INTERFACE_P dependencies on GL_DAILY_RATES_INTERFACE

Line 944: FROM gl_daily_rates_interface

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

Line 1005: insert into gl_daily_rates_interface(

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

Line 1090: delete from gl_daily_rates_interface

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