APPS.XTR_MISC_P dependencies on XTR_BANK_BAL_INTERFACE

Line 1475: from XTR_BANK_BAL_INTERFACE)

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;
1478: --
1479: cursor SETOFF_PRV_RATE is

Line 1512: from XTR_BANK_BAL_INTERFACE);

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;
1514: LOOP
1515: fetch SETOFF_CAL_DATE INTO l_calc_date;
1516: EXIT WHEN SETOFF_CAL_DATE%NOTFOUND;