APPS.XTR_COF_P dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 1442: FROM xtr_rollover_transactions

1438:
1439: -- Added and changed for Interest Override
1440: SELECT SUM(interest), SUM(original_amount)
1441: INTO l_interest,l_original_amount
1442: FROM xtr_rollover_transactions
1443: WHERE deal_number = P_DEAL_NUMBER;
1444:
1445:
1446: IF l_interest = l_original_amount THEN

Line 2433: from XTR_ROLLOVER_TRANSACTIONS a,

2429: a.interest,
2430: -- Added for Interest Override feature
2431: a.first_transaction_flag,
2432: d.day_count_type
2433: from XTR_ROLLOVER_TRANSACTIONS a,
2434: -- Added for Interest Override feature
2435: XTR_DEALS d
2436: where a.deal_type in('TMM','RTMM')
2437: and a.start_date <=l_date

Line 2463: from XTR_ROLLOVER_TRANSACTIONS a,

2459: a.interest,
2460: -- Added for Interest Override feature
2461: a.first_transaction_flag,
2462: d.day_count_type
2463: from XTR_ROLLOVER_TRANSACTIONS a,
2464: -- Added for Interest Override feature
2465: XTR_DEALS d
2466: where a.deal_type ='ONC'
2467: and a.start_date <=l_date

Line 2494: from XTR_ROLLOVER_TRANSACTIONS a,

2490: a.interest,
2491: -- Added for Interest Override feature
2492: a.first_transaction_flag,
2493: d.day_count_type
2494: from XTR_ROLLOVER_TRANSACTIONS a,
2495: -- Added for Interest Override feature
2496: XTR_DEALS d
2497: where a.deal_type ='NI'
2498: and a.deal_subtype in ('BUY', 'ISSUE')

Line 2897: -- From xtr_rollover_transactions

2893: /*------------------------------------------------*/
2894: -- Changed for Interest Override
2895: -- Select SUM(orig_coupon_amount)
2896: -- Into l_coupon
2897: -- From xtr_rollover_transactions
2898: -- Where deal_number = p_deal_no;
2899: Select SUM(orig_coupon_amount),SUM(interest),SUM(original_amount)
2900: Into l_orig_coupon,l_interest,l_original_amount
2901: From xtr_rollover_transactions

Line 2901: From xtr_rollover_transactions

2897: -- From xtr_rollover_transactions
2898: -- Where deal_number = p_deal_no;
2899: Select SUM(orig_coupon_amount),SUM(interest),SUM(original_amount)
2900: Into l_orig_coupon,l_interest,l_original_amount
2901: From xtr_rollover_transactions
2902: Where deal_number = p_deal_no;
2903:
2904: SELECT COUNT(deal_no)
2905: INTO l_resale_count