APPS.XTR_MARKET_DATA_INTERFACE_P dependencies on XTR_MASTER_CURRENCIES_V

Line 44: FROM xtr_master_currencies_v

40: AND b.currency = p.param_value;
41: --
42: CURSOR rnd_factor_cursor (p_currency VARCHAR2) IS
43: SELECT rounding_factor
44: FROM xtr_master_currencies_v
45: WHERE currency = p_currency;
46: --
47: CURSOR c_interest_date_stamp (p_currency VARCHAR2,
48: p_ric_code VARCHAR2,

Line 273: UPDATE xtr_master_currencies_v a

269: spot_date = p_last_download_time,
270: rate_date = p_last_download_time
271: WHERE currency = v_home_ccy;
272: -- ie updating home currency therefore ALL hce rates need updating for each currency
273: UPDATE xtr_master_currencies_v a
274: SET hce_rate = (usd_quoted_spot / v_mid_usd_rate),
275: spot_date = p_last_download_time,
276: rate_date = p_last_download_time
277: WHERE currency <> v_home_ccy