DBA Data[Home] [Help]

APPS.XTR_RATE_CHANGE dependencies on XTR_DEALS_V

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 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,