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.AR_GTA_TRX_UTIL dependencies on IBY_EXT_BANK_ACCOUNTS

Line 2216: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;

2212: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2213: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2214: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2215: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2216: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2217: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2218: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2219: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2220: l_bank_name HZ_PARTIES.party_name%TYPE;

Line 2217: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;

2213: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2214: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2215: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2216: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2217: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2218: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2219: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2220: l_bank_name HZ_PARTIES.party_name%TYPE;
2221: l_bank_branch_name HZ_PARTIES.party_name%TYPE;

Line 2218: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;

2214: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2215: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2216: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2217: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2218: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2219: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2220: l_bank_name HZ_PARTIES.party_name%TYPE;
2221: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2222: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;

Line 2219: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;

2215: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2216: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2217: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2218: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2219: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2220: l_bank_name HZ_PARTIES.party_name%TYPE;
2221: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2222: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2223:

Line 2224: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;

2220: l_bank_name HZ_PARTIES.party_name%TYPE;
2221: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2222: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2223:
2224: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2225:
2226:
2227:
2228:

Line 2324: IBY_EXT_BANK_ACCOUNTS_V B,

2320: , l_bank_name
2321: , l_bank_branch_name
2322: FROM IBY_CREDITCARD C,
2323: IBY_CREDITCARD_ISSUERS_VL I,
2324: IBY_EXT_BANK_ACCOUNTS_V B,
2325: IBY_FNDCPT_PMT_CHNNLS_VL P,
2326: IBY_FNDCPT_TX_EXTENSIONS X,
2327: IBY_FNDCPT_TX_OPERATIONS OP,
2328: IBY_PMT_INSTR_USES_ALL U,

Line 2365: IBY_EXT_BANK_ACCOUNTS

2361: bank_account_num
2362: INTO
2363: l_bank_account_num
2364: FROM
2365: IBY_EXT_BANK_ACCOUNTS
2366: WHERE
2367: ext_bank_account_id = l_instrument_id;
2368: EXCEPTION
2369: WHEN no_data_found THEN

Line 2438: , IBY_EXT_BANK_ACCOUNTS ibybanks

2434: , ibybanks.bank_account_num
2435: , ibybanks.bank_id
2436: , ibybanks.branch_id
2437: FROM IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
2438: , IBY_EXT_BANK_ACCOUNTS ibybanks
2439: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
2440: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
2441: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = l_ext_payer_id
2442: AND ExtPartyInstrumentsEO.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT'

Line 2570: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;

2566: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2567: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2568: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2569: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2570: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2571: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2572: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2573: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2574: l_bank_name HZ_PARTIES.party_name%TYPE;

Line 2571: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;

2567: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2568: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2569: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2570: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2571: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2572: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2573: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2574: l_bank_name HZ_PARTIES.party_name%TYPE;
2575: l_bank_branch_name HZ_PARTIES.party_name%TYPE;

Line 2572: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;

2568: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2569: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2570: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2571: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2572: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2573: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2574: l_bank_name HZ_PARTIES.party_name%TYPE;
2575: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2576: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;

Line 2573: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;

2569: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2570: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2571: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2572: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2573: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2574: l_bank_name HZ_PARTIES.party_name%TYPE;
2575: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2576: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2577: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;

Line 2577: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;

2573: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;
2574: l_bank_name HZ_PARTIES.party_name%TYPE;
2575: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2576: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2577: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2578:
2579: l_ori_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2580: l_ori_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2581: l_ori_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

Line 2679: IBY_EXT_BANK_ACCOUNTS_V B,

2675: , l_bank_name
2676: , l_bank_branch_name
2677: FROM IBY_CREDITCARD C,
2678: IBY_CREDITCARD_ISSUERS_VL I,
2679: IBY_EXT_BANK_ACCOUNTS_V B,
2680: IBY_FNDCPT_PMT_CHNNLS_VL P,
2681: IBY_FNDCPT_TX_EXTENSIONS X,
2682: IBY_FNDCPT_TX_OPERATIONS OP,
2683: IBY_PMT_INSTR_USES_ALL U,

Line 2720: IBY_EXT_BANK_ACCOUNTS

2716: bank_account_num
2717: INTO
2718: l_bank_account_num
2719: FROM
2720: IBY_EXT_BANK_ACCOUNTS
2721: WHERE
2722: ext_bank_account_id = l_instrument_id;
2723: EXCEPTION
2724: WHEN no_data_found THEN

Line 2785: IBY_EXT_BANK_ACCOUNTS_V B,

2781: , l_bank_name
2782: , l_bank_branch_name
2783: FROM IBY_CREDITCARD C,
2784: IBY_CREDITCARD_ISSUERS_VL I,
2785: IBY_EXT_BANK_ACCOUNTS_V B,
2786: IBY_FNDCPT_PMT_CHNNLS_VL P,
2787: IBY_FNDCPT_TX_EXTENSIONS X,
2788: IBY_FNDCPT_TX_OPERATIONS OP,
2789: IBY_PMT_INSTR_USES_ALL U,

Line 2826: IBY_EXT_BANK_ACCOUNTS

2822: bank_account_num
2823: INTO
2824: l_bank_account_num
2825: FROM
2826: IBY_EXT_BANK_ACCOUNTS
2827: WHERE
2828: ext_bank_account_id = l_instrument_id;
2829: EXCEPTION
2830: WHEN no_data_found THEN

Line 2902: , IBY_EXT_BANK_ACCOUNTS ibybanks

2898: , ibybanks.bank_account_num
2899: , ibybanks.bank_id
2900: , ibybanks.branch_id
2901: FROM IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
2902: , IBY_EXT_BANK_ACCOUNTS ibybanks
2903: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
2904: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
2905: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = l_ext_payer_id
2906: AND ExtPartyInstrumentsEO.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT'