DBA Data[Home] [Help]

APPS.XTR_EXP_TRANSFERS_PKG dependencies on XTR_BANK_ACCOUNTS_V

Line 430: from xtr_bank_accounts_v

426: p_comp_acct IN VARCHAR2,
427: p_curr IN VARCHAR2) return boolean IS
428: CURSOR comp_acct IS
429: select COUNT(*)
430: from xtr_bank_accounts_v
431: where party_code = p_comp
432: and currency = p_curr
433: and account_number = p_comp_acct
434: and NVL(authorised,'N') = 'Y';

Line 550: from xtr_bank_accounts_v

546: p_cparty IN VARCHAR2,
547: p_curr IN VARCHAR2) return boolean IS
548: CURSOR cparty_ref IS
549: select COUNT(*)
550: from xtr_bank_accounts_v
551: where party_code = p_cparty
552: and account_number = p_cparty_account_no
553: and currency = p_curr
554: and NVL(authorised,'N') = 'Y';

Line 1303: from XTR_BANK_ACCOUNTS_V

1299: p_cparty_ref IN VARCHAR2) return varchar2 IS
1300:
1301: cursor REF_ACC is
1302: select ACCOUNT_NUMBER
1303: from XTR_BANK_ACCOUNTS_V
1304: where PARTY_CODE = p_cparty_code
1305: and CURRENCY = p_curr
1306: and BANK_SHORT_CODE = p_cparty_ref;
1307: