APPS.XTR_REVAL_PROCESS_P dependencies on XTR_MARKET_PRICES

Line 5: /* This procedure get rates information from xtr_market_prices */

1: PACKAGE BODY XTR_REVAL_PROCESS_P as
2: /* $Header: xtrrevlb.pls 120.59 2006/11/15 10:11:20 eaggarwa ship $ */
3: -------------------------------------------------------------------------------------------------------
4: /***************************************************************/
5: /* This procedure get rates information from xtr_market_prices */
6: /* based on time and input into XTR_REVALUATION_RATES table */
7: /* Also it generates a batch ID for the new period */
8: /***************************************************************/
9: PROCEDURE GET_ALL_REVAL_RATES(l_company IN VARCHAR2,

Line 60: from XTR_MARKET_PRICES

56: -- Get Volatility (O, V) rows from Market Price table
57: cursor OPTION_VOLS is
58: select RIC_CODE, CURRENCY_A, CURRENCY_B, TERM_TYPE, TERM_LENGTH,
59: LAST_DOWNLOAD_TIME, NOS_OF_DAYS
60: from XTR_MARKET_PRICES
61: where TERM_TYPE in ('O', 'V');
62:
63: -- This Cursor will find the snap shot of market rate for the above row found
64: cursor STORED_VOL_RATE is

Line 93: from XTR_MARKET_PRICES

89: cursor INSTRUMENTS_MAINTAINED is
90: select RIC_CODE,TERM_LENGTH,TERM_YEAR,CURRENCY_A,CURRENCY_B,TERM_TYPE, DAY_COUNT_BASIS,
91: nvl(BID_PRICE, 0),nvl(ASK_PRICE,0),LAST_DOWNLOAD_TIME,
92: NOS_OF_DAYS
93: from XTR_MARKET_PRICES
94: where TERM_TYPE not in('O','V','A')
95: and ((TERM_TYPE = 'S' and (CURRENCY_A = 'USD' or CURRENCY_B = 'USD'))
96: or (TERM_TYPE <> 'S'));
97: