APPS.XTR_WRAPPER_API_P dependencies on XTR_DEAL_DATE_AMOUNTS

Line 75: From Xtr_Deal_Date_Amounts

71: v_net_Id number;
72: v_reconciled_reference number;
73: Cursor C1 is
74: Select *
75: From Xtr_Deal_Date_Amounts
76: Where settlement_number in
77: (Select settlement_number
78: From Xtr_Settlement_Summary
79: Where net_ID = p_settlement_summary_ID)

Line 101: Select Xtr_Deal_Date_Amounts_S.Nextval

97: Into v_settlement_number
98: From Xtr_Settlement_Summary
99: Where settlement_summary_id = p_settlement_summary_ID;
100:
101: Select Xtr_Deal_Date_Amounts_S.Nextval
102: Into v_reconciled_reference
103: From dual;
104:
105: /* This is to update DDA about the successful completion of Reconciliation */

Line 106: Update Xtr_Deal_Date_Amounts

102: Into v_reconciled_reference
103: From dual;
104:
105: /* This is to update DDA about the successful completion of Reconciliation */
106: Update Xtr_Deal_Date_Amounts
107: Set Reconciled_Reference = v_reconciled_reference,
108: Reconciled_Pass_Code = p_reconciled_method
109: Where settlement_number = v_settlement_number;
110:

Line 114: Update Xtr_Deal_Date_Amounts

110:
111: If SQL%NOTFOUND then
112: For C1_Rec in C1
113: Loop
114: Update Xtr_Deal_Date_Amounts
115: Set reconciled_reference = v_reconciled_reference,
116: reconciled_pass_code = p_reconciled_method
117: Where current of C1;
118: End Loop;

Line 136: Update Xtr_Deal_Date_Amounts

132: Into v_settlement_number
133: From Xtr_Settlement_Summary
134: Where settlement_summary_id = p_settlement_summary_ID;
135:
136: Update Xtr_Deal_Date_Amounts
137: Set Reconciled_Reference = null,
138: Reconciled_Pass_Code = null
139: Where settlement_number = v_settlement_number;
140:

Line 145: Update Xtr_Deal_Date_Amounts

141: If SQL%NOTFOUND then
142: For C1_Rec in C1
143: Loop
144: /* After successful un-reconciliation, DDA is updated such that the records are available for future reconciliation */
145: Update Xtr_Deal_Date_Amounts
146: Set reconciled_reference = null,
147: reconciled_pass_code = null
148: Where current of C1;
149: End Loop;

Line 749: xtr_deal_date_amounts dd,xtr_revaluation_details rd

745: cursor cur_reval_insbal IS
746: SELECT max(period_to)
747: FROM
748: xtr_bank_balances bb,xtr_bank_accounts ba,
749: xtr_deal_date_amounts dd,xtr_revaluation_details rd
750: WHERE
751: bb.company_code = p_company_code
752: AND bb.account_number = p_account_number
753: AND bb.company_code = ba.party_code

Line 765: xtr_deal_date_amounts dd,xtr_accrls_amort aa

761: cursor cur_accrl_insbal IS
762: SELECT max(period_to)
763: FROM
764: xtr_bank_balances bb,xtr_bank_accounts ba,
765: xtr_deal_date_amounts dd,xtr_accrls_amort aa
766: WHERE
767: bb.company_code = p_company_code
768: AND bb.account_number = p_account_number
769: AND bb.company_code = ba.party_code

Line 1487: from xtr_deal_date_amounts

1483: /* Bug 4231200 Added the last AND condition. */
1484:
1485: cursor chk_reconcile (l_amt_type VARCHAR2) is
1486: select 1
1487: from xtr_deal_date_amounts
1488: where deal_number = l_deal_num
1489: and transaction_number = l_tran_num
1490: and amount_type = l_amt_type
1491: and nvl(cashflow_amount,0) <> 0

Line 1605: xtr_deal_date_amounts B,

1601:
1602: cursor chk_reconcile (l_deal_type VARCHAR2) is
1603: select A.transaction_number
1604: from xtr_interacct_transfers A,
1605: xtr_deal_date_amounts B,
1606: xtr_deal_date_amounts C
1607: where A.company_code = l_company_code
1608: and A.transfer_amount = l_transfer_amount
1609: and A.transfer_date = l_transfer_date

Line 1606: xtr_deal_date_amounts C

1602: cursor chk_reconcile (l_deal_type VARCHAR2) is
1603: select A.transaction_number
1604: from xtr_interacct_transfers A,
1605: xtr_deal_date_amounts B,
1606: xtr_deal_date_amounts C
1607: where A.company_code = l_company_code
1608: and A.transfer_amount = l_transfer_amount
1609: and A.transfer_date = l_transfer_date
1610: and A.portfolio_code = l_portfolio