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_IREC_PAYMENTS dependencies on IBY_EXT_BANK_ACCOUNTS_V

Line 1896: FROM iby_ext_bank_accounts_v ba

1892: AND IBY.CARD_HOLDER_NAME <> p_account_holder_name;
1893:
1894: CURSOR ba_cur IS
1895: SELECT count(1) ba_exists
1896: FROM iby_ext_bank_accounts_v ba
1897: WHERE ba.branch_number = p_routing_number
1898: AND ba.bank_account_number = p_bank_account_number
1899: AND ROWNUM = 1
1900: AND ba.bank_account_name <> p_account_holder_name;

Line 2976: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;

2972:
2973: l_api_version NUMBER := 1.0;
2974: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
2975: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
2976: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
2977: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
2979: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
2980: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 2977: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;

2973: l_api_version NUMBER := 1.0;
2974: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
2975: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
2976: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
2977: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
2979: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
2980: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2981: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;

Line 2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;

2974: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
2975: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
2976: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
2977: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
2979: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;
2980: l_bank_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2981: l_branch_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2982: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.extbank_rec_type;