APPS.XTR_ACCRUAL_PROCESS_P dependencies on XTR_DEAL_DATE_AMOUNTS

Line 1235: from XTR_DEAL_DATE_AMOUNTS

1231: -- Get Accrued Interest for Discount/Premium
1232: ----------------------------------------------
1233: cursor GET_BOND_DDA_INT is
1234: select amount
1235: from XTR_DEAL_DATE_AMOUNTS
1236: where deal_number = l_deal_nos
1237: and transaction_number = 1
1238: and amount_type = 'INT'
1239: and date_type = 'COMENCE';

Line 3436: from XTR_DEAL_DATE_AMOUNTS_V

3432:
3433: --
3434: cursor CA_DEAL_NUM(v_account_number varchar2,v_currency varchar2) is
3435: select DEAL_NUMBER,TRANSACTION_NUMBER,PRODUCT_TYPE
3436: from XTR_DEAL_DATE_AMOUNTS_V
3437: where DEAL_TYPE = 'CA'
3438: --and AMOUNT_TYPE = 'BAL'
3439: and ACCOUNT_NO = v_account_number
3440: and CURRENCY = v_currency

Line 4351: insert into XTR_DEAL_DATE_AMOUNTS

4347: l_old_ccy := l_ccy;
4348: --
4349: l_amt_hce := round((l_acclrs_amount / nvl(l_hce_rate,1)),2);
4350: --
4351: insert into XTR_DEAL_DATE_AMOUNTS
4352: (deal_type,amount_type,date_type,deal_number,transaction_date,
4353: currency,amount,hce_amount,amount_date,action_code,
4354: cashflow_amount,company_code,transaction_number,
4355: deal_subtype,authorised,product_type,status_code,