APPS.XTR_WRAPPER_API_P dependencies on XTR_DEAL_DATE_AMOUNTS_V

Line 123: from XTR_DEAL_DATE_AMOUNTS_V

119: CASHFLOW_AMOUNT,
120: /******** code below added by Ilavenil for CE Reconciliation project *******/
121: SETTLEMENT_NUMBER,
122: NETOFF_NUMBER
123: from XTR_DEAL_DATE_AMOUNTS_V
124: where DEAL_NUMBER = p_deal_no
125: and TRANSACTION_NUMBER = p_trans_no
126: and DATE_TYPE = p_date_type
127: and AMOUNT_TYPE = p_amount_type

Line 210: update XTR_DEAL_DATE_AMOUNTS_V

206: Into v_reconciled_reference
207: From dual;
208:
209:
210: update XTR_DEAL_DATE_AMOUNTS_V
211: set RECONCILED_REFERENCE = v_reconciled_reference,
212: RECONCILED_PASS_CODE = decode(DATE_TYPE,'FORCAST','^'||'M','M'),
213: RECONCILED_DAYS_ADJUST = (nvl(P_VAL_DATE,SYSDATE) - U_AMOUNT_DATE),
214: AMOUNT_DATE = decode(DATE_TYPE,'FORCAST',nvl(P_VAL_DATE,SYSDATE),AMOUNT_DATE),