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 902: xtr_master_currencies mc

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

Line 914: xtr_master_currencies mc

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

Line 934: xtr_master_currencies mc

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

Line 971: FROM xtr_master_currencies

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