APPS.XTR_MISC_P dependencies on XTR_BANK_ACCOUNTS

Line 1218: from XTR_BANK_ACCOUNTS a,

1214: l_settle_acct VARCHAR2(20);
1215: --
1216: cursor GET_OLD_ACCT_BALS is
1217: select a.ACCOUNT_NUMBER,a.OPENING_BALANCE,a.STATEMENT_DATE,a.CURRENCY,a.PARTY_CODE
1218: from XTR_BANK_ACCOUNTS a,
1219: XTR_PARTIES_V b
1220: where nvl(a.PROJECTED_BALANCE_UPDATED_ON,to_date('01/01/1980','DD/MM/YYYY')) < trunc(SYSDATE)
1221: and nvl(a.SETOFF_ACCOUNT_YN,'N') <> 'Y'
1222: and b.PARTY_CODE = a.PARTY_CODE

Line 1242: update XTR_BANK_ACCOUNTS

1238: fetch GET_OLD_ACCT_BALS INTO l_acct,l_op_balance,l_state_date,l_ccy,l_acct_party;
1239: EXIT WHEN GET_OLD_ACCT_BALS%NOTFOUND;
1240: if l_state_date = (trunc(sysdate) - 1) then
1241: -- Balances are up to date therefore set projected balance = actual balance
1242: update XTR_BANK_ACCOUNTS
1243: set PROJECTED_BALANCE = OPENING_BALANCE,
1244: PROJECTED_BALANCE_UPDATED_ON = trunc(SYSDATE),
1245: PROJECTED_BALANCE_DATE = STATEMENT_DATE
1246: where ACCOUNT_NUMBER = l_acct

Line 1253: update XTR_BANK_ACCOUNTS

1249: else
1250: open CFLOWS;
1251: fetch CFLOWS INTO l_cflow,l_settle_acct,l_acct_ccy;
1252: if CFLOWS%FOUND then
1253: update XTR_BANK_ACCOUNTS
1254: set PROJECTED_BALANCE = nvl(l_op_balance,0) + nvl(l_cflow,0),
1255: PROJECTED_BALANCE_UPDATED_ON = trunc(SYSDATE),
1256: PROJECTED_BALANCE_DATE = (trunc(SYSDATE) -1)
1257: where ACCOUNT_NUMBER = l_settle_acct

Line 1261: update XTR_BANK_ACCOUNTS

1257: where ACCOUNT_NUMBER = l_settle_acct
1258: and PARTY_CODE = l_acct_party
1259: and CURRENCY = l_acct_ccy;
1260: else
1261: update XTR_BANK_ACCOUNTS
1262: set PROJECTED_BALANCE = nvl(l_op_balance,0),
1263: PROJECTED_BALANCE_UPDATED_ON = trunc(SYSDATE),
1264: PROJECTED_BALANCE_DATE = (trunc(SYSDATE) -1)
1265: where ACCOUNT_NUMBER = l_acct

Line 1444: from XTR_BANK_ACCOUNTS;

1440: --
1441: cursor SEL_SETOFF_ACCT is
1442: select distinct rtrim(SETOFF),rtrim(BANK_CODE),
1443: SETOFF_COMPANY,CURRENCY
1444: from XTR_BANK_ACCOUNTS;
1445:
1446: cursor FIND_SETOFF_RATE is
1447: select INTEREST_RATE
1448: from XTR_INTEREST_RATE_RANGES