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_EXT_BANK_ACCOUNTS

Line 2003: l_bank_account_name IBY_EXT_BANK_ACCOUNTS.bank_account_name%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;
2007: l_bank_name HZ_PARTIES.party_name%TYPE;

Line 2004: l_bank_account_num IBY_EXT_BANK_ACCOUNTS.bank_account_num%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;
2007: l_bank_name HZ_PARTIES.party_name%TYPE;
2008: l_bank_branch_name HZ_PARTIES.party_name%TYPE;

Line 2005: l_bank_id IBY_EXT_BANK_ACCOUNTS.bank_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;
2007: l_bank_name HZ_PARTIES.party_name%TYPE;
2008: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2009: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;

Line 2006: l_bank_branch_id IBY_EXT_BANK_ACCOUNTS.branch_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;
2007: l_bank_name HZ_PARTIES.party_name%TYPE;
2008: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2009: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2010:

Line 2011: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;

2007: l_bank_name HZ_PARTIES.party_name%TYPE;
2008: l_bank_branch_name HZ_PARTIES.party_name%TYPE;
2009: l_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2010:
2011: l_instrument_id IBY_EXT_BANK_ACCOUNTS.ext_bank_account_id%TYPE;
2012:
2013:
2014:
2015:

Line 2095: IBY_EXT_BANK_ACCOUNTS_V B,

2091: , l_bank_name
2092: , l_bank_branch_name
2093: FROM IBY_CREDITCARD C,
2094: IBY_CREDITCARD_ISSUERS_VL I,
2095: IBY_EXT_BANK_ACCOUNTS_V B,
2096: IBY_FNDCPT_PMT_CHNNLS_VL P,
2097: IBY_FNDCPT_TX_EXTENSIONS X,
2098: IBY_FNDCPT_TX_OPERATIONS OP,
2099: IBY_PMT_INSTR_USES_ALL U,

Line 2130: IBY_EXT_BANK_ACCOUNTS

2126: bank_account_num
2127: INTO
2128: l_bank_account_num
2129: FROM
2130: IBY_EXT_BANK_ACCOUNTS
2131: WHERE
2132: ext_bank_account_id = l_instrument_id;
2133: EXCEPTION
2134: WHEN no_data_found THEN

Line 2192: , IBY_EXT_BANK_ACCOUNTS ibybanks

2188: , ibybanks.bank_account_num
2189: , ibybanks.bank_id
2190: , ibybanks.branch_id
2191: FROM IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
2192: , IBY_EXT_BANK_ACCOUNTS ibybanks
2193: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
2194: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
2195: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = l_ext_payer_id
2196: AND ExtPartyInstrumentsEO.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT'