APPS.XTR_FPS2_P dependencies on XTR_MARKET_PRICES

Line 29: from XTR_MARKET_PRICES

25: l_freq_archive NUMBER;
26: --
27: cursor PREV_ARCHIVE is
28: select last_archive_time,archive_freq_type,freq_archive
29: from XTR_MARKET_PRICES
30: where (currency_a = quoted_1st or currency_b = quoted_1st)
31: and (currency_a = 'USD' or currency_b = 'USD')
32: and term_type = 'S';
33: --

Line 46: XTR_MARKET_PRICES sr2,

42: decode(sr3.currency_a, 'USD', sr3.bid_price, (1/sr3.ask_price))
43: tmp_offer_rate,
44: nvl(sr1.rate_date,sr1.spot_date) tmp_rate_date
45: from XTR_MASTER_CURRENCIES sr1,
46: XTR_MARKET_PRICES sr2,
47: XTR_MARKET_PRICES sr3
48: where sr1.currency = quoted_1st
49: and (sr2.currency_a = 'USD' or sr2.currency_b = 'USD')
50: and (sr3.currency_a = 'USD' or sr3.currency_b = 'USD')

Line 47: XTR_MARKET_PRICES sr3

43: tmp_offer_rate,
44: nvl(sr1.rate_date,sr1.spot_date) tmp_rate_date
45: from XTR_MASTER_CURRENCIES sr1,
46: XTR_MARKET_PRICES sr2,
47: XTR_MARKET_PRICES sr3
48: where sr1.currency = quoted_1st
49: and (sr2.currency_a = 'USD' or sr2.currency_b = 'USD')
50: and (sr3.currency_a = 'USD' or sr3.currency_b = 'USD')
51: and sr2.currency_a <> quoted_1st

Line 526: from XTR_MARKET_PRICES a

522: l_diff NUMBER;
523: --
524: cursor GET_LOWER_RATE is
525: select (a.BID_PRICE + a.ASK_PRICE) / 2,a.NOS_OF_DAYS
526: from XTR_MARKET_PRICES a
527: where a.CURRENCY_A = l_ccy
528: and a.TERM_TYPE IN('D','M','Y','A')
529: and a.NOS_OF_DAYS =
530: (select max(c.NOS_OF_DAYS)

Line 531: from XTR_MARKET_PRICES c

527: where a.CURRENCY_A = l_ccy
528: and a.TERM_TYPE IN('D','M','Y','A')
529: and a.NOS_OF_DAYS =
530: (select max(c.NOS_OF_DAYS)
531: from XTR_MARKET_PRICES c
532: where c.TERM_TYPE IN('D','M','Y','A')
533: and c.CURRENCY_A = l_ccy
534: and c.NOS_OF_DAYS < l_days);
535: --

Line 538: from XTR_MARKET_PRICES a

534: and c.NOS_OF_DAYS < l_days);
535: --
536: cursor GET_HIGHER_RATE is
537: select (a.BID_PRICE + a.ASK_PRICE) / 2,a.NOS_OF_DAYS
538: from XTR_MARKET_PRICES a
539: where a.CURRENCY_A = l_ccy
540: and a.TERM_TYPE IN('D','M','Y','A')
541: and a.NOS_OF_DAYS =
542: (select max(c.NOS_OF_DAYS)

Line 543: from XTR_MARKET_PRICES c

539: where a.CURRENCY_A = l_ccy
540: and a.TERM_TYPE IN('D','M','Y','A')
541: and a.NOS_OF_DAYS =
542: (select max(c.NOS_OF_DAYS)
543: from XTR_MARKET_PRICES c
544: where c.TERM_TYPE IN('D','M','Y','A')
545: and c.CURRENCY_A = l_ccy
546: and c.NOS_OF_DAYS >= l_days);
547: --

Line 2450: FROM xtr_market_prices

2446:
2447: CURSOR usd_cross IS
2448: SELECT decode(currency_a, p_currency_from ,ask_price,1/ask_price),
2449: decode(currency_a, p_currency_from ,bid_price,1/bid_price)
2450: FROM xtr_market_prices
2451: WHERE ((currency_a= p_currency_from AND currency_b=p_currency_to)
2452: OR (currency_a= p_currency_to AND currency_b=p_currency_from))
2453: AND term_type='S';
2454:

Line 2462: XTR_MARKET_PRICES sr2,

2458: decode(sr3.currency_a, p_currency_to, sr3.bid_price, (1/sr3.ask_price)),
2459: decode(sr2.currency_a,p_currency_from,sr2.ask_price, (1/sr2.bid_price)) /
2460: decode(sr3.currency_a, p_currency_to, sr3.ask_price, (1/sr3.bid_price))
2461: from
2462: XTR_MARKET_PRICES sr2,
2463: XTR_MARKET_PRICES sr3
2464: where (sr2.currency_a = 'USD' or sr2.currency_b = 'USD')
2465: and (sr3.currency_a = 'USD' or sr3.currency_b = 'USD')
2466: and (sr2.currency_a = p_currency_from or sr2.currency_b = p_currency_from)

Line 2463: XTR_MARKET_PRICES sr3

2459: decode(sr2.currency_a,p_currency_from,sr2.ask_price, (1/sr2.bid_price)) /
2460: decode(sr3.currency_a, p_currency_to, sr3.ask_price, (1/sr3.bid_price))
2461: from
2462: XTR_MARKET_PRICES sr2,
2463: XTR_MARKET_PRICES sr3
2464: where (sr2.currency_a = 'USD' or sr2.currency_b = 'USD')
2465: and (sr3.currency_a = 'USD' or sr3.currency_b = 'USD')
2466: and (sr2.currency_a = p_currency_from or sr2.currency_b = p_currency_from)
2467: and (sr3.currency_a = p_currency_to or sr3.currency_b= p_currency_to)