APPS.XTR_WRAPPER_API_P dependencies on DUAL

Line 207: From dual;

203: End If;
204:
205: Select Xtr_Deal_Date_Amounts_S.Nextval
206: Into v_reconciled_reference
207: From dual;
208:
209:
210: update XTR_DEAL_DATE_AMOUNTS_V
211: set RECONCILED_REFERENCE = v_reconciled_reference,

Line 263: From dual;

259: Where settlement_summary_id = p_settlement_summary_ID;
260:
261: Select Xtr_Deal_Date_Amounts_S.Nextval
262: Into v_reconciled_reference
263: From dual;
264:
265: /* This is to update DDA about the successful completion of Reconciliation */
266: Update Xtr_Deal_Date_Amounts
267: Set Reconciled_Reference = v_reconciled_reference,

Line 2093: open c_param ('DUAL_AUTHORISE');

2089: Return FALSE;
2090: END;
2091:
2092: BEGIN
2093: open c_param ('DUAL_AUTHORISE');
2094: fetch c_param into l_validate_deal;
2095: close c_param;
2096:
2097: open c_param ('DUAL_AUTHORISE_IAC');

Line 2097: open c_param ('DUAL_AUTHORISE_IAC');

2093: open c_param ('DUAL_AUTHORISE');
2094: fetch c_param into l_validate_deal;
2095: close c_param;
2096:
2097: open c_param ('DUAL_AUTHORISE_IAC');
2098: fetch c_param into l_validate_iac;
2099: close c_param;
2100:
2101: open c_param ('IAC_AUTO_SETTLE');