APPS.XTR_STOCK_PKG dependencies on XTR_BANK_ACCOUNTS_V

Line 28: from XTR_BANK_ACCOUNTS_V

24: /* Bug 3737048 Added the new status in the cursor. */
25:
26: Cursor cur_cparty_acct is
27: select ACCOUNT_NUMBER
28: from XTR_BANK_ACCOUNTS_V
29: where PARTY_CODE = D.CPARTY_CODE
30: and CURRENCY = D.CURRENCY
31: and ((PARTY_TYPE = 'CP' and BANK_SHORT_CODE = D.CPARTY_REF)
32: or(PARTY_TYPE = 'C' and substr(BANK_SHORT_CODE, 1, 7) = D.CPARTY_REF));

Line 702: from XTR_BANK_ACCOUNTS_V

698: BUY DEAL_DETAIL%ROWTYPE;
699:
700: Cursor cur_cparty_acct is
701: select ACCOUNT_NUMBER
702: from XTR_BANK_ACCOUNTS_V
703: where PARTY_CODE = BUY.CPARTY_CODE
704: and CURRENCY = BUY.CURRENCY
705: and ((PARTY_TYPE = 'CP' and BANK_SHORT_CODE = BUY.CPARTY_REF)
706: or(PARTY_TYPE = 'C' and substr(BANK_SHORT_CODE, 1, 7) = BUY.CPARTY_REF));