APPS.XTR_ACCOUNT_BAL_MAINT_P dependencies on XTR_DEAL_DATE_AMOUNTS

Line 911: from XTR_DEAL_DATE_AMOUNTS_V

907: l_prv_accrual_int NUMBER;
908: --
909: cursor DEAL_NUM is
910: select DEAL_NUMBER
911: from XTR_DEAL_DATE_AMOUNTS_V
912: where DEAL_TYPE = 'CA'
913: and AMOUNT_TYPE = 'BAL'
914: and ACCOUNT_NO = p_account_number
915: and CURRENCY = p_currency

Line 1180: update XTR_DEAL_DATE_AMOUNTS

1176: --
1177: open DEAL_NUM;
1178: fetch DEAL_NUM into l_deal_nos;
1179: if DEAL_NUM%FOUND then
1180: update XTR_DEAL_DATE_AMOUNTS
1181: set AMOUNT =abs(l_open_bal),
1182: CASHFLOW_AMOUNT = 0,
1183: HCE_AMOUNT = abs(nvl(round(l_open_bal/l_hce_rate,roundfac),0)),
1184: AMOUNT_DATE = l_calc_date,

Line 1202: insert into XTR_DEAL_DATE_AMOUNTS

1198: open EXP_NUM;
1199: fetch EXP_NUM into l_deal_nos;
1200: close EXP_NUM;
1201: --
1202: insert into XTR_DEAL_DATE_AMOUNTS
1203: (DEAL_TYPE,AMOUNT_TYPE,DATE_TYPE,DEAL_NUMBER,TRANSACTION_NUMBER,
1204: TRANSACTION_DATE,CURRENCY,AMOUNT,HCE_AMOUNT,AMOUNT_DATE,
1205: COMPANY_CODE,ACCOUNT_NO,ACTION_CODE,CASHFLOW_AMOUNT,
1206: DEAL_SUBTYPE,PRODUCT_TYPE,LIMIT_CODE,PORTFOLIO_CODE,STATUS_CODE,

Line 1236: update XTR_DEAL_DATE_AMOUNTS

1232: --
1233: open DEAL_NUM;
1234: fetch DEAL_NUM into l_deal_nos;
1235: if DEAL_NUM%FOUND then
1236: update XTR_DEAL_DATE_AMOUNTS
1237: set AMOUNT = 0,
1238: CASHFLOW_AMOUNT = 0,
1239: HCE_AMOUNT = 0
1240: where DEAL_TYPE = 'CA'