APPS.XTR_REVAL_PROCESS_P dependencies on XTR_INTEREST_PERIOD_RATES

Line 66: from XTR_INTEREST_PERIOD_RATES a

62:
63: -- This Cursor will find the snap shot of market rate for the above row found
64: cursor STORED_VOL_RATE is
65: select a.UNIQUE_PERIOD_ID,a.RATE_DATE,a.BID_RATE, a.OFFER_RATE
66: from XTR_INTEREST_PERIOD_RATES a
67: where a.UNIQUE_PERIOD_ID = l_vol_code
68: and ((a.CONTRA_OPTION_CCY = p_CURRENCYB and p_CURRENCYB is NOT NULL) or
69: (p_CURRENCYB is NULL))
70: and a.RATE_DATE < trunc(l_end_date+1)

Line 106: -- Fetch Rates OTHER RATES from XTR_INTEREST_PERIOD_RATES table

102: where a.CURRENCY = decode(p_CURRENCYA,'USD',p_CURRENCYB,p_CURRENCYA)
103: and a.RATE_DATE < trunc(l_end_date+1)
104: order by a.RATE_DATE desc;
105: --
106: -- Fetch Rates OTHER RATES from XTR_INTEREST_PERIOD_RATES table
107: cursor RATES_NON_FX is
108: select a.RATE_DATE,nvl(a.BID_RATE,0), nvl(a.OFFER_RATE,0)
109: from XTR_INTEREST_PERIOD_RATES a
110: where a.UNIQUE_PERIOD_ID = p_REVAL_TYPE

Line 109: from XTR_INTEREST_PERIOD_RATES a

105: --
106: -- Fetch Rates OTHER RATES from XTR_INTEREST_PERIOD_RATES table
107: cursor RATES_NON_FX is
108: select a.RATE_DATE,nvl(a.BID_RATE,0), nvl(a.OFFER_RATE,0)
109: from XTR_INTEREST_PERIOD_RATES a
110: where a.UNIQUE_PERIOD_ID = p_REVAL_TYPE
111: and a.RATE_DATE < trunc(l_end_date+1)
112: order by a.RATE_DATE desc;
113: --

Line 134: from XTR_INTEREST_PERIOD_RATES a

130: and ric_code IS NOT NULL;
131:
132: cursor BOND_PRICE is
133: select a.RATE_DATE,nvl(a.BID_RATE,0), nvl(a.OFFER_RATE,0)
134: from XTR_INTEREST_PERIOD_RATES a
135: where a.UNIQUE_PERIOD_ID = l_ric_code
136: and a.RATE_DATE < trunc(l_end_date+1)
137: order by a.RATE_DATE desc;
138: */