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_EXTERNAL_PAYERS_ALL

Line 2215: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;

2211: l_paying_customer_id ra_customer_trx_all.paying_customer_id%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;

Line 2414: IBY_EXTERNAL_PAYERS_ALL

2410: ext_payer_id
2411: INTO
2412: l_ext_payer_id
2413: FROM
2414: IBY_EXTERNAL_PAYERS_ALL
2415: WHERE party_id = l_paying_party_id
2416: AND CUST_ACCOUNT_ID = l_valid_customer_id--Yao Zhang modified for bug#8404856
2417: AND ACCT_SITE_USE_ID =l_valid_site_use_id--Yao Zhang modified for bug#8404856
2418: AND ORG_ID = p_org_id -- org id

Line 2569: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;

2565: l_paying_customer_id ra_customer_trx_all.paying_customer_id%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;

Line 2878: IBY_EXTERNAL_PAYERS_ALL

2874: ext_payer_id
2875: INTO
2876: l_ext_payer_id
2877: FROM
2878: IBY_EXTERNAL_PAYERS_ALL
2879: WHERE party_id = l_paying_party_id
2880: AND CUST_ACCOUNT_ID = l_valid_customer_id--Yao Zhang modified for bug#8404856
2881: AND ACCT_SITE_USE_ID = l_valid_site_use_id--Yao Zhang modified for bug#8404856
2882: AND ORG_ID = p_org_id -- org id