DBA Data[Home] [Help]

APPS.XTR_CALCULATION_P dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 359: from XTR_ROLLOVER_TRANSACTIONS_V b

355: and a.status_code = 'CURRENT'
356: and a.deal_subtype = P_DEAL_SUBTYPE
357: and a.product_type = P_PRODUCT_TYPE
358: and a.maturity_date > (select max(b.maturity_date)
359: from XTR_ROLLOVER_TRANSACTIONS_V b
360: where b.deal_number = a.deal_no);
361: l_deal_no NUMBER;
362: c_deal DEAL%ROWTYPE;
363:

Line 367: from XTR_ROLLOVER_TRANSACTIONS_V

363:
364: cursor LAST_TRANS is
365: select start_date,maturity_date,expected_balance_out,balance_out,
366: accum_interest,interest_rate,pi_amount_due
367: from XTR_ROLLOVER_TRANSACTIONS_V
368: where deal_number = l_deal_no
369: -- and maturity_date >= l_start_date
370: order by start_date desc,maturity_date desc,transaction_number desc;
371:

Line 383: from XTR_ROLLOVER_TRANSACTIONS_V

379: l_cparty_account_no varchar2(20);
380:
381: cursor T_NOS is
382: select nvl(max(TRANSACTION_NUMBER), 0) + 1
383: from XTR_ROLLOVER_TRANSACTIONS_V
384: where DEAL_NUMBER = l_deal_no;
385:
386: TRANS_NO number;
387: