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.JMF_GTA_TRX_UTIL dependencies on IBY_EXTERNAL_PAYERS_ALL

Line 2002: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;

1998: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
1999: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;
2000: l_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2001: l_paying_party_id HZ_CUST_ACCOUNTS.party_id%TYPE;
2002: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
2003: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%TYPE;
2004: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%TYPE;
2005: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_id%TYPE;
2006: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_id%TYPE;

Line 2168: IBY_EXTERNAL_PAYERS_ALL

2164: ext_payer_id
2165: INTO
2166: l_ext_payer_id
2167: FROM
2168: IBY_EXTERNAL_PAYERS_ALL
2169: WHERE party_id = l_paying_party_id
2170: AND CUST_ACCOUNT_ID = l_paying_customer_id
2171: AND ACCT_SITE_USE_ID = l_paying_site_use_id
2172: AND ORG_ID = p_org_id -- org id