APPS.XTR_SETTLEMENT_SUMMARY_P dependencies on XTR_DEAL_DATE_AMOUNTS

Line 79: From Xtr_Deal_Date_Amounts

75: Procedure UPD_SETTLEMENT_SUMMARY(p_flag IN Char, p_netoff_number in number, p_settlement_ID IN Number)
76: Is
77: Cursor C1 is
78: Select settlement_number, deal_number, transaction_number
79: From Xtr_Deal_Date_Amounts
80: Where netoff_number = p_netoff_number;
81:
82: Begin
83: For C1_Rec in C1

Line 108: From Xtr_Deal_Date_Amounts

104: Procedure UPD_Settlement_Summary(p_flag IN Char, p_netoff_number IN Number, p_settlement_ID IN Number, p_amount IN Number)
105: Is
106: Cursor C1 is
107: Select settlement_number, deal_number, transaction_number
108: From Xtr_Deal_Date_Amounts
109: Where netoff_number = p_netoff_number;
110: Begin
111:
112: For C1_Rec in C1 Loop

Line 192: From Xtr_Deal_Date_Amounts

188: v_upd_single Char(1);
189:
190: Cursor C2 is
191: Select settlement_number
192: From Xtr_Deal_Date_Amounts
193: where ACTUAL_SETTLEMENT_DATE = p_settle_DATE
194: and CASHFLOW_AMOUNT <> 0
195: and CURRENCY = p_CURRENCY
196: and ACCOUNT_NO = p_ACCT_NO

Line 339: From Xtr_Deal_Date_Amounts

335: End;
336:
337: Select settlement_number
338: Into v_settlement_number
339: From Xtr_Deal_Date_Amounts
340: Where netoff_number = p_netoff_number
341: And rownum < 2;
342:
343: Select net_ID