APPS.XTR_MISC_P dependencies on XTR_BANK_ACCOUNTS

Line 1231: from XTR_BANK_ACCOUNTS a,

1227: l_settle_acct VARCHAR2(20);
1228: --
1229: cursor GET_OLD_ACCT_BALS is
1230: select a.ACCOUNT_NUMBER,a.OPENING_BALANCE,a.STATEMENT_DATE,a.CURRENCY,a.PARTY_CODE
1231: from XTR_BANK_ACCOUNTS a,
1232: XTR_PARTIES_V b
1233: where nvl(a.PROJECTED_BALANCE_UPDATED_ON,to_date('01/01/1980','DD/MM/YYYY')) < trunc(SYSDATE)
1234: and nvl(a.SETOFF_ACCOUNT_YN,'N') <> 'Y'
1235: and b.PARTY_CODE = a.PARTY_CODE

Line 1255: update XTR_BANK_ACCOUNTS

1251: fetch GET_OLD_ACCT_BALS INTO l_acct,l_op_balance,l_state_date,l_ccy,l_acct_party;
1252: EXIT WHEN GET_OLD_ACCT_BALS%NOTFOUND;
1253: if l_state_date = (trunc(sysdate) - 1) then
1254: -- Balances are up to date therefore set projected balance = actual balance
1255: update XTR_BANK_ACCOUNTS
1256: set PROJECTED_BALANCE = OPENING_BALANCE,
1257: PROJECTED_BALANCE_UPDATED_ON = trunc(SYSDATE),
1258: PROJECTED_BALANCE_DATE = STATEMENT_DATE
1259: where ACCOUNT_NUMBER = l_acct

Line 1266: update XTR_BANK_ACCOUNTS

1262: else
1263: open CFLOWS;
1264: fetch CFLOWS INTO l_cflow,l_settle_acct,l_acct_ccy;
1265: if CFLOWS%FOUND then
1266: update XTR_BANK_ACCOUNTS
1267: set PROJECTED_BALANCE = nvl(l_op_balance,0) + nvl(l_cflow,0),
1268: PROJECTED_BALANCE_UPDATED_ON = trunc(SYSDATE),
1269: PROJECTED_BALANCE_DATE = (trunc(SYSDATE) -1)
1270: where ACCOUNT_NUMBER = l_settle_acct

Line 1274: update XTR_BANK_ACCOUNTS

1270: where ACCOUNT_NUMBER = l_settle_acct
1271: and PARTY_CODE = l_acct_party
1272: and CURRENCY = l_acct_ccy;
1273: else
1274: update XTR_BANK_ACCOUNTS
1275: set PROJECTED_BALANCE = nvl(l_op_balance,0),
1276: PROJECTED_BALANCE_UPDATED_ON = trunc(SYSDATE),
1277: PROJECTED_BALANCE_DATE = (trunc(SYSDATE) -1)
1278: where ACCOUNT_NUMBER = l_acct

Line 1457: from XTR_BANK_ACCOUNTS;

1453: --
1454: cursor SEL_SETOFF_ACCT is
1455: select distinct rtrim(SETOFF),rtrim(BANK_CODE),
1456: SETOFF_COMPANY,CURRENCY
1457: from XTR_BANK_ACCOUNTS;
1458:
1459: cursor FIND_SETOFF_RATE is
1460: select INTEREST_RATE
1461: from XTR_INTEREST_RATE_RANGES