DBA Data[Home] [Help]

APPS.XTR_IG_TRANSFERS_PKG dependencies on XTR_BANK_ACCOUNTS

Line 367: from xtr_bank_Accounts

363:
364: Cursor party_dtls(party_code IN VARCHAR2,
365: party_acct_no IN VARCHAR2) is
366: select currency
367: from xtr_bank_Accounts
368: where account_number = party_acct_no
369: and party_code = party_code;
370:
371: l_jrnl VARCHAR2(1);

Line 510: from XTR_BANK_ACCOUNTS_V

506: cursor curs(c_party IN VARCHAR2,
507: c_curr IN VARCHAR2,
508: c_party_acct IN VARCHAR2) is
509: select 'Y'
510: from XTR_BANK_ACCOUNTS_V
511: where party_code = c_party
512: and currency = c_curr
513: and account_number = c_party_acct
514: and nvl(authorised,'N') = 'Y'