eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 67: external_bank_account_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,

63: /* holds list of format linked to each profile */
64: l_profile_format_tab profileFormatTabType;
65:
66: TYPE externalBankAcctType IS RECORD (
67: external_bank_account_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
68: country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
69: end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE,
70: foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE
71: );

Line 68: country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,

64: l_profile_format_tab profileFormatTabType;
65:
66: TYPE externalBankAcctType IS RECORD (
67: external_bank_account_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
68: country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
69: end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE,
70: foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE
71: );
72: --

Line 69: end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE,

65:
66: TYPE externalBankAcctType IS RECORD (
67: external_bank_account_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
68: country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
69: end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE,
70: foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE
71: );
72: --
73: TYPE externalBankAcctTabType IS TABLE OF externalBankAcctType

Line 70: foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE

66: TYPE externalBankAcctType IS RECORD (
67: external_bank_account_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE,
68: country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE,
69: end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE,
70: foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE
71: );
72: --
73: TYPE externalBankAcctTabType IS TABLE OF externalBankAcctType
74: INDEX BY BINARY_INTEGER;

Line 642: l_ext_bank_acct_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE;

638:
639: l_print_var VARCHAR2(1) := '';
640: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
641: l_doc_token_tab trxnErrTokenTabType;
642: l_ext_bank_acct_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE;
643: l_end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE;
644: l_country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE;
645: l_foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE;
646:

Line 643: l_end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE;

639: l_print_var VARCHAR2(1) := '';
640: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
641: l_doc_token_tab trxnErrTokenTabType;
642: l_ext_bank_acct_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE;
643: l_end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE;
644: l_country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE;
645: l_foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE;
646:
647: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;

Line 644: l_country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE;

640: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
641: l_doc_token_tab trxnErrTokenTabType;
642: l_ext_bank_acct_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE;
643: l_end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE;
644: l_country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE;
645: l_foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE;
646:
647: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
648: l_country CE_BANK_BRANCHES_V.country%TYPE;

Line 645: l_foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE;

641: l_doc_token_tab trxnErrTokenTabType;
642: l_ext_bank_acct_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE;
643: l_end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE;
644: l_country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE;
645: l_foreign_pmts_ok_flag IBY_EXT_BANK_ACCOUNTS_V.foreign_payment_use_flag%TYPE;
646:
647: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
648: l_country CE_BANK_BRANCHES_V.country%TYPE;
649: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;

Line 3015: IBY_EXT_BANK_ACCOUNTS_V eba

3011: /* Payee */
3012: HZ_PARTIES payee,
3013: HZ_LOCATIONS payee_loc,
3014: /* Payee bank */
3015: IBY_EXT_BANK_ACCOUNTS_V eba
3016: WHERE
3017: /* document related */
3018: doc.document_payable_id = p_doc_id
3019: AND doc.payment_reason_code = pmt_reason.payment_reason_code(+)