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.AP_PAY_SINGLE_INVOICE_PKG dependencies on CE_BANK_ACCOUNTS

Line 127: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;

123: l_last_updated_by ap_checks.last_updated_by%TYPE; -- Bug3343314
124: l_last_update_login ap_checks.last_update_login%TYPE; -- Bug3343314
125: l_org_id NUMBER;
126: l_bank_account_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE;
127: l_bank_account_name ce_bank_accounts.bank_account_name%TYPE;
128: l_processing_type iby_payment_profiles.processing_type%TYPE;
129: l_print_instr_immed_flag iby_payment_profiles.print_instruction_immed_flag%TYPE;
130: l_default_printer iby_payment_profiles.default_printer%TYPE;
131: l_payment_document_id ce_payment_documents.payment_document_id %TYPE;

Line 175: ,Bank_Account_Name CE_BANK_ACCOUNTS.bank_account_name%TYPE

171: ,Xrate_type AP_CHECKS_ALL.exchange_rate_type%TYPE
172: ,Check_id AP_CHECKS_ALL.check_id%TYPE
173: ,Checkrun_Name AP_CHECKS_ALL.checkrun_name%TYPE
174: ,Internal_Bank_Acct_Id CE_BANK_ACCT_USES_ALL.bank_acct_use_id%TYPE
175: ,Bank_Account_Name CE_BANK_ACCOUNTS.bank_account_name%TYPE
176: ,Bank_Account_Num CE_BANK_ACCOUNTS.bank_account_num%TYPE
177: ,Bank_Account_Type CE_BANK_ACCOUNTS.account_classification%TYPE
178: ,Bank_Num CE_BANK_BRANCHES_V.branch_number%TYPE
179: ,Legal_Entity_Id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE

Line 176: ,Bank_Account_Num CE_BANK_ACCOUNTS.bank_account_num%TYPE

172: ,Check_id AP_CHECKS_ALL.check_id%TYPE
173: ,Checkrun_Name AP_CHECKS_ALL.checkrun_name%TYPE
174: ,Internal_Bank_Acct_Id CE_BANK_ACCT_USES_ALL.bank_acct_use_id%TYPE
175: ,Bank_Account_Name CE_BANK_ACCOUNTS.bank_account_name%TYPE
176: ,Bank_Account_Num CE_BANK_ACCOUNTS.bank_account_num%TYPE
177: ,Bank_Account_Type CE_BANK_ACCOUNTS.account_classification%TYPE
178: ,Bank_Num CE_BANK_BRANCHES_V.branch_number%TYPE
179: ,Legal_Entity_Id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE
180: ,Status_Lookup_Code AP_CHECKS_ALL.status_lookup_code%TYPE

Line 177: ,Bank_Account_Type CE_BANK_ACCOUNTS.account_classification%TYPE

173: ,Checkrun_Name AP_CHECKS_ALL.checkrun_name%TYPE
174: ,Internal_Bank_Acct_Id CE_BANK_ACCT_USES_ALL.bank_acct_use_id%TYPE
175: ,Bank_Account_Name CE_BANK_ACCOUNTS.bank_account_name%TYPE
176: ,Bank_Account_Num CE_BANK_ACCOUNTS.bank_account_num%TYPE
177: ,Bank_Account_Type CE_BANK_ACCOUNTS.account_classification%TYPE
178: ,Bank_Num CE_BANK_BRANCHES_V.branch_number%TYPE
179: ,Legal_Entity_Id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE
180: ,Status_Lookup_Code AP_CHECKS_ALL.status_lookup_code%TYPE
181: );

Line 179: ,Legal_Entity_Id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE

175: ,Bank_Account_Name CE_BANK_ACCOUNTS.bank_account_name%TYPE
176: ,Bank_Account_Num CE_BANK_ACCOUNTS.bank_account_num%TYPE
177: ,Bank_Account_Type CE_BANK_ACCOUNTS.account_classification%TYPE
178: ,Bank_Num CE_BANK_BRANCHES_V.branch_number%TYPE
179: ,Legal_Entity_Id CE_BANK_ACCOUNTS.account_owner_org_id%TYPE
180: ,Status_Lookup_Code AP_CHECKS_ALL.status_lookup_code%TYPE
181: );
182:
183: TYPE r_ap_ven_sites_info IS RECORD

Line 416: FROM CE_BANK_ACCOUNTS BA,

412: l_check_rec.bank_account_name,
413: l_check_rec.bank_account_num,
414: l_check_rec.bank_account_type,
415: l_check_rec.bank_num
416: FROM CE_BANK_ACCOUNTS BA,
417: CE_BANK_BRANCHES_V CBB,
418: CE_BANK_ACCT_USES_OU_V CBAU
419: WHERE CBAU.BANK_ACCOUNT_ID = BA.BANK_ACCOUNT_ID
420: AND CBB.branch_party_id = BA.bank_branch_id