DBA Data[Home] [Help]

APPS.ARRX_BRS dependencies on AP_BANK_ACCOUNTS

Line 142: v_drawee_bank_acc_name AP_BANK_ACCOUNTS.bank_account_name%TYPE;

138: v_drawee_bank_name ce_bank_branches_v.bank_name%TYPE;
139: v_drawee_bank_number ce_bank_branches_v.bank_number%TYPE;
140: v_drawee_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
141: v_drawee_branch_number ce_bank_branches_v.branch_number%TYPE;
142: v_drawee_bank_acc_name AP_BANK_ACCOUNTS.bank_account_name%TYPE;
143: v_drawee_bank_acc_number AP_BANK_ACCOUNTS.bank_account_num%TYPE;
144: v_drawee_branch_city ce_bank_branches_v.city%TYPE;
145: v_drawee_branch_state ce_bank_branches_v.state%TYPE;
146: v_drawee_branch_country ce_bank_branches_v.country%TYPE;

Line 143: v_drawee_bank_acc_number AP_BANK_ACCOUNTS.bank_account_num%TYPE;

139: v_drawee_bank_number ce_bank_branches_v.bank_number%TYPE;
140: v_drawee_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
141: v_drawee_branch_number ce_bank_branches_v.branch_number%TYPE;
142: v_drawee_bank_acc_name AP_BANK_ACCOUNTS.bank_account_name%TYPE;
143: v_drawee_bank_acc_number AP_BANK_ACCOUNTS.bank_account_num%TYPE;
144: v_drawee_branch_city ce_bank_branches_v.city%TYPE;
145: v_drawee_branch_state ce_bank_branches_v.state%TYPE;
146: v_drawee_branch_country ce_bank_branches_v.country%TYPE;
147: v_drawee_branch_postal_code ce_bank_branches_v.zip%TYPE;

Line 151: v_drawee_bank_acc_check_digits AP_BANK_ACCOUNTS.check_digits%TYPE;

147: v_drawee_branch_postal_code ce_bank_branches_v.zip%TYPE;
148: v_drawee_branch_address1 ce_bank_branches_v.address_line1%TYPE;
149: v_drawee_branch_address2 ce_bank_branches_v.address_line2%TYPE;
150: v_drawee_branch_address3 ce_bank_branches_v.address_line3%TYPE;
151: v_drawee_bank_acc_check_digits AP_BANK_ACCOUNTS.check_digits%TYPE;
152: v_drawee_bank_acc_curr AP_BANK_ACCOUNTS.currency_code%TYPE;
153: v_comments RA_CUSTOMER_TRX.comments%TYPE;
154: v_days_late NUMBER;
155: v_remittance_batch_name AR_BATCHES.name%TYPE;

Line 152: v_drawee_bank_acc_curr AP_BANK_ACCOUNTS.currency_code%TYPE;

148: v_drawee_branch_address1 ce_bank_branches_v.address_line1%TYPE;
149: v_drawee_branch_address2 ce_bank_branches_v.address_line2%TYPE;
150: v_drawee_branch_address3 ce_bank_branches_v.address_line3%TYPE;
151: v_drawee_bank_acc_check_digits AP_BANK_ACCOUNTS.check_digits%TYPE;
152: v_drawee_bank_acc_curr AP_BANK_ACCOUNTS.currency_code%TYPE;
153: v_comments RA_CUSTOMER_TRX.comments%TYPE;
154: v_days_late NUMBER;
155: v_remittance_batch_name AR_BATCHES.name%TYPE;
156: v_remittance_method AR_BATCHES.remit_method_code%TYPE;

Line 489: ,ap_bank_accounts_all aba

485: ,hz_cust_account_roles acct_role
486: ,hz_parties rel_party
487: ,hz_relationships rel
488: ,hz_cust_site_uses_all rasu
489: ,ap_bank_accounts_all aba
490: ,ce_bank_branches_v abb
491: ,hz_cust_accounts cust_acct
492: ,hz_parties party
493: ,ce_bank_branches_v rabb