APPS.XTR_IAC_TRANSFERS_PKG dependencies on XTR_BANK_ACCOUNTS

Line 81: from XTR_BANK_ACCOUNTS_V a,

77: c_curr IN VARCHAR2,
78: c_party_acct IN VARCHAR2) is
79: select a.BANK_CODE,
80: a.AUTHORISED
81: from XTR_BANK_ACCOUNTS_V a,
82: XTR_PARTY_INFO b
83: where a.party_code = c_party
84: and a.currency = c_curr
85: and nvl(a.setoff_account_yn,'N') <> 'Y'

Line 90: l_bank_code xtr_bank_accounts.bank_code%TYPE;

86: and a.account_number = c_party_acct
87: and a.bank_code = b.party_code
88: order by nvl(a.authorised,'N') desc;
89:
90: l_bank_code xtr_bank_accounts.bank_code%TYPE;
91: l_auth VARCHAR2(1);
92:
93: begin
94: open curs (p_party, p_curr, p_party_acct);