APPS.XTR_FPS2_P dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 1588: from xtr_rollover_transactions_v

1584: l_pre_int VARCHAR2(1) := NULL;
1585:
1586: Cursor last_int_set is
1587: select max(maturity_date)
1588: from xtr_rollover_transactions_v
1589: where deal_number = p_deal_no
1590: and org_trans_no in (select min(transaction_number)
1591: from xtr_deal_date_amounts
1592: where deal_number = p_deal_no

Line 1830: from XTR_ROLLOVER_TRANSACTIONS_V

1826: pmt TMM_ROLL%ROWTYPE;
1827:
1828: cursor LAST_TMM is
1829: select rowid
1830: from XTR_ROLLOVER_TRANSACTIONS_V
1831: where deal_number = p_deal_no
1832: and status_code = 'CURRENT'
1833: order by maturity_date desc, start_date desc, transaction_number desc;
1834:

Line 1878: v_RT Xtr_Rollover_Transactions_V%Rowtype;

1874: l_int_settle_hce NUMBER;
1875: l_prin_adj NUMBER;
1876: l_rounding_type VARCHAR2(1); -- Add Interest Override
1877:
1878: v_RT Xtr_Rollover_Transactions_V%Rowtype;
1879: v_first_time Char(1) := 'Y';
1880: v_last_trans Varchar2(1) ;
1881: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
1882: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;

Line 2122: from XTR_ROLLOVER_TRANSACTIONS_V r,

2118: r.balance_out,
2119: d.settle_account_no,
2120: d.company_code, d.cparty_code, d.year_calc_type
2121: /**********/
2122: from XTR_ROLLOVER_TRANSACTIONS_V r,
2123: XTR_DEALS d
2124: where r.deal_number = d.deal_no
2125: and r.deal_type = p_deal_type
2126: and r.deal_type = 'TMM'

Line 2135: from XTR_ROLLOVER_TRANSACTIONS_V

2131: pmt TMM_ROLL%ROWTYPE;
2132:
2133: cursor LAST_TMM is
2134: select rowid
2135: from XTR_ROLLOVER_TRANSACTIONS_V
2136: where deal_number = p_deal_no
2137: and status_code = 'CURRENT'
2138: order by maturity_date desc, start_date desc, transaction_number desc;
2139:

Line 2178: v_RT Xtr_Rollover_Transactions_V%Rowtype;

2174: l_hce_rate NUMBER;
2175: l_int_settle_hce NUMBER;
2176: l_prin_adj NUMBER;
2177:
2178: v_RT Xtr_Rollover_Transactions_V%Rowtype;
2179: v_first_time Char(1) := 'Y';
2180: v_last_trans Varchar2(1) ;
2181: v_prncpl_ctype Xtr_Tax_Brokerage_Setup.Calc_Type%type;
2182: v_prncpl_method Xtr_Tax_Brokerage_Setup.tax_settle_method%type;

Line 2529: p_RT IN OUT NOCOPY XTR_ROLLOVER_TRANSACTIONS_V%ROWTYPE) IS

2525: p_income_ctype IN VARCHAR2,
2526: p_income_method IN VARCHAR2,
2527: p_settle_acct IN VARCHAR2,
2528: p_last_tran IN VARCHAR2,
2529: p_RT IN OUT NOCOPY XTR_ROLLOVER_TRANSACTIONS_V%ROWTYPE) IS
2530:
2531: l_hce_rate NUMBER;
2532: l_hce_rounding NUMBER;
2533: l_orig_prncpl_amt NUMBER;