APPS.XTR_MISC_P dependencies on XTR_BANK_BAL_INTERFACE

Line 1462: from XTR_BANK_BAL_INTERFACE)

1458: cursor SETOFF_CAL_DATE is
1459: select distinct BALANCE_DATE
1460: from XTR_BANK_BALANCES
1461: where BALANCE_DATE >= (select max(BALANCE_DATE)
1462: from XTR_BANK_BAL_INTERFACE)
1463: and SETOFF = l_setoff
1464: order by BALANCE_DATE asc;
1465: --
1466: cursor SETOFF_PRV_RATE is

Line 1499: from XTR_BANK_BAL_INTERFACE);

1495: EXIT WHEN SEL_SETOFF_ACCT%NOTFOUND;
1496: delete XTR_BANK_BALANCES
1497: where ACCOUNT_NUMBER = l_setoff||'-'||l_bank_code
1498: and BALANCE_DATE >= (select max(BALANCE_DATE)
1499: from XTR_BANK_BAL_INTERFACE);
1500: open SETOFF_CAL_DATE;
1501: LOOP
1502: fetch SETOFF_CAL_DATE INTO l_calc_date;
1503: EXIT WHEN SETOFF_CAL_DATE%NOTFOUND;