APPS.XTR_MARKET_DATA_INTERFACE_P dependencies on XTR_MASTER_CURRENCIES

Line 38: xtr_master_currencies b

34: --
35: CURSOR home_ccy_cursor IS
36: SELECT p.param_value, b.usd_quoted_spot, b.divide_or_multiply
37: FROM xtr_pro_param p,
38: xtr_master_currencies b
39: WHERE p.param_name = 'SYSTEM_FUNCTIONAL_CCY'
40: AND b.currency = p.param_value;
41: --
42: CURSOR rnd_factor_cursor (p_currency VARCHAR2) IS

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 140: UPDATE xtr_master_currencies

136: IF p_called_from_trigger THEN
137: OPEN rnd_factor_cursor(p_currency_a);
138: FETCH rnd_factor_cursor INTO v_rounding_factor;
139: CLOSE rnd_factor_cursor;
140: UPDATE xtr_master_currencies
141: SET current_spot_rate = (p_bid_price + p_ask_price) / 2,
142: hce_rate = (v_mid_usd_rate / v_old_base_hce_rate),
143: usd_quoted_spot = Decode(currency,'USD',1,(v_mid_usd_rate)), /* bug#2366624, rravunny */
144: spot_date = p_last_download_time,

Line 191: UPDATE xtr_master_currencies

187: IF p_called_from_trigger THEN
188: OPEN rnd_factor_cursor(p_currency_b);
189: FETCH rnd_factor_cursor INTO v_rounding_factor;
190: CLOSE rnd_factor_cursor;
191: UPDATE xtr_master_currencies
192: SET current_spot_rate = (p_bid_price + p_ask_price) / 2,
193: hce_rate = (v_mid_usd_rate / v_old_base_hce_rate),
194: usd_quoted_spot = Decode(currency,'USD',1,(v_mid_usd_rate)), /* bug#2366624, rravunny */
195: spot_date = p_last_download_time,

Line 250: UPDATE xtr_master_currencies

246: v_usd_hce_rate := (1 / ((p_bid_price + p_ask_price)/2)); /* bug#2366624, rravunny */
247: END IF;
248: --
249: IF p_called_from_trigger THEN
250: UPDATE xtr_master_currencies
251: SET current_spot_rate = 1,
252: hce_rate = Decode(v_home_ccy,'USD',1,v_usd_hce_rate),
253: usd_quoted_spot = 1,
254: spot_date = p_last_download_time,

Line 265: UPDATE xtr_master_currencies

261: /* ====== */
262: IF v_home_ccy <>'USD' then
263: --
264: IF p_called_from_trigger THEN
265: UPDATE xtr_master_currencies
266: SET current_spot_rate = ((p_bid_price + p_ask_price) / 2), /* bug#2366624, rravunny */
267: usd_quoted_spot = (v_mid_usd_rate), /* bug#2366624, rravunny */
268: hce_rate = 1,
269: spot_date = p_last_download_time,

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

Line 901: xtr_master_currencies mc

897: AVG(outer.bid_rate_against_usd) bid_rate_against_usd,
898: AVG(outer.offer_rate_against_usd) offer_rate_against_usd,
899: mc.divide_or_multiply
900: FROM xtr_spot_rates outer,
901: xtr_master_currencies mc
902: WHERE outer.currency <> 'USD'
903: AND outer.rate_date >= p_ref_date
904: AND outer.rate_date <= (p_ref_date+1)
905: AND outer.currency = mc.currency

Line 913: xtr_master_currencies mc

909: outer.bid_rate_against_usd,
910: outer.offer_rate_against_usd,
911: mc.divide_or_multiply
912: FROM xtr_spot_rates outer,
913: xtr_master_currencies mc
914: WHERE outer.currency <> 'USD'
915: AND outer.currency = mc.currency
916: AND NOT EXISTS (SELECT 1
917: FROM xtr_spot_rates inner

Line 933: xtr_master_currencies mc

929: outer.bid_rate_against_usd,
930: outer.offer_rate_against_usd,
931: mc.divide_or_multiply
932: FROM xtr_spot_rates outer,
933: xtr_master_currencies mc
934: WHERE outer.currency <> 'USD'
935: AND outer.currency = mc.currency
936: AND outer.rate_date = (SELECT max(rate_date)
937: FROM xtr_spot_rates inner

Line 970: FROM xtr_master_currencies

966: p_from_currency VARCHAR2(15);
967: p_to_currency VARCHAR2(15);
968: CURSOR get_is_no_upload IS
969: SELECT 1
970: FROM xtr_master_currencies
971: WHERE currency = p_currency
972: AND gl_no_upload='Y'
973: AND ROWNUM=1;
974: BEGIN