eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_RATE_CHANGE dependencies on XTR_DEALS

Line 43: from XTR_DEALS_V d

39: DEAL_SUBTYPE, PRODUCT_TYPE, INTEREST_RATE,
40: PI_AMOUNT_DUE, CURRENCY, SETTLE_DATE,
41: PORTFOLIO_CODE,COMPANY_CODE,DEAL_DATE,
42: CPARTY_CODE,CLIENT_CODE,DEALER_CODE
43: from XTR_DEALS_V d
44: where d.DEAL_TYPE = 'RTMM'
45: and d.DEAL_SUBTYPE = nvl(p_deal_subtype, d.DEAL_SUBTYPE)
46: and d.CURRENCY = nvl(p_currency, d.CURRENCY)
47: and d.PAYMENT_SCHEDULE_CODE = nvl(p_payment_schedule_code, d.PAYMENT_SCHEDULE_CODE)

Line 157: update XTR_DEALS

153: -- and nvl(RATE_EFFECTIVE_CREATED,l_effective_from_date )
154: -- <= l_effective_from_date;
155:
156: if SQL%FOUND then
157: update XTR_DEALS
158: set INTEREST_RATE = p_new_interest_rate
159: where DEAL_NO = deal.DEAL_NO;
160: end if;
161:

Line 316: from XTR_DEALS_V d

312: cursor DEAL_CUR is
313: select PAYMENT_SCHEDULE_CODE, DEAL_TYPE,DEAL_SUBTYPE,
314: PRODUCT_TYPE, INTEREST_RATE, MATURITY_DATE,
315: PI_AMOUNT_DUE, CURRENCY
316: from XTR_DEALS_V d
317: where d.DEAL_NO = p_deal_number;
318:
319: cursor THIS_ROW is
320: select START_DATE, MATURITY_DATE,