DBA Data[Home] [Help]

APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on CE_BANK_BRANCHES_V

Line 178: ,Bank_Num CE_BANK_BRANCHES_V.branch_number%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: );
182:

Line 417: CE_BANK_BRANCHES_V CBB,

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
421: AND SYSDATE < NVL(BA.END_DATE,SYSDATE+1)