APPS.XTR_MISC_P dependencies on XTR_BANK_BALANCES

Line 1473: from XTR_BANK_BALANCES

1469: where CURRENCY = l_ccy;
1470: --
1471: cursor SETOFF_CAL_DATE is
1472: select distinct BALANCE_DATE
1473: from XTR_BANK_BALANCES
1474: where BALANCE_DATE >= (select max(BALANCE_DATE)
1475: from XTR_BANK_BAL_INTERFACE)
1476: and SETOFF = l_setoff
1477: order by BALANCE_DATE asc;

Line 1481: from XTR_BANK_BALANCES

1477: order by BALANCE_DATE asc;
1478: --
1479: cursor SETOFF_PRV_RATE is
1480: select INTEREST_RATE
1481: from XTR_BANK_BALANCES
1482: where ACCOUNT_NUMBER = l_setoff||'-'||l_bank_code
1483: and BALANCE_DATE = l_prv_date;
1484: --
1485: cursor SETOFF_PREV_DETAILS is

Line 1488: from XTR_BANK_BALANCES a

1484: --
1485: cursor SETOFF_PREV_DETAILS is
1486: select a.BALANCE_DATE,nvl(sum(a.BALANCE_CFLOW),0),
1487: nvl(sum(a.ACCUM_INT_CFWD),0)
1488: from XTR_BANK_BALANCES a
1489: where ACCOUNT_NUMBER = l_setoff||'-'||l_bank_code
1490: and a.BALANCE_DATE = (select max(b.BALANCE_DATE)
1491: from XTR_BANK_BALANCES b
1492: where ACCOUNT_NUMBER = l_setoff||'-'||l_bank_code

Line 1491: from XTR_BANK_BALANCES b

1487: nvl(sum(a.ACCUM_INT_CFWD),0)
1488: from XTR_BANK_BALANCES a
1489: where ACCOUNT_NUMBER = l_setoff||'-'||l_bank_code
1490: and a.BALANCE_DATE = (select max(b.BALANCE_DATE)
1491: from XTR_BANK_BALANCES b
1492: where ACCOUNT_NUMBER = l_setoff||'-'||l_bank_code
1493: and b.BALANCE_DATE < l_calc_date)
1494: group by a.BALANCE_DATE,a.ACCOUNT_NUMBER;
1495: --

Line 1498: from XTR_BANK_BALANCES a

1494: group by a.BALANCE_DATE,a.ACCOUNT_NUMBER;
1495: --
1496: cursor SETOFF_THIS_DETAILS is
1497: select nvl(sum(a.BALANCE_CFLOW),0)
1498: from XTR_BANK_BALANCES a
1499: where SETOFF = l_setoff
1500: and a.BALANCE_DATE = l_calc_date;
1501: --
1502: begin

Line 1509: delete XTR_BANK_BALANCES

1505: LOOP
1506: fetch SEL_SETOFF_ACCT INTO l_setoff,l_bank_code,
1507: l_setoff_company,l_ccy;
1508: EXIT WHEN SEL_SETOFF_ACCT%NOTFOUND;
1509: delete XTR_BANK_BALANCES
1510: where ACCOUNT_NUMBER = l_setoff||'-'||l_bank_code
1511: and BALANCE_DATE >= (select max(BALANCE_DATE)
1512: from XTR_BANK_BAL_INTERFACE);
1513: open SETOFF_CAL_DATE;

Line 1549: insert into XTR_BANK_BALANCES

1545: l_interest := round(l_prv_bal * l_prv_rate / 100 * l_no_days
1546: / yr_basis,roundfac);
1547: l_int_cf := l_int_bf + l_interest;
1548: l_rate := nvl(l_rate,0);
1549: insert into XTR_BANK_BALANCES
1550: (COMPANY_CODE,ACCOUNT_NUMBER,BALANCE_DATE,NO_OF_DAYS,
1551: STATEMENT_BALANCE,BALANCE_ADJUSTMENT,BALANCE_CFLOW,
1552: ACCUM_INT_BFWD,INTEREST,INTEREST_RATE,INTEREST_SETTLED,
1553: INTEREST_SETTLED_HCE,ACCUM_INT_CFWD,