DBA Data[Home] [Help]

APPS.ARP_PROGRAM_BR_REMIT dependencies on CE_BANK_ACCOUNTS

Line 863: ce_bank_accounts cba,

859: bank.bank_branch_name
860: INTO l_remit_bank,
861: l_remit_bank_branch
862: FROM ce_bank_branches_v bank,
863: ce_bank_accounts cba,
864: ce_bank_acct_uses cbau
865: WHERE cbau.bank_acct_use_id = l_batch_rec.remit_bank_acct_use_id
866: AND cbau.bank_account_id = cba.bank_account_id
867: AND cba.bank_branch_id = bank.branch_party_id;

Line 1086: ce_bank_accounts cba,

1082: hz_cust_accounts hca,
1083: hz_parties party,
1084: /* Need to pass country code for SEPA specific receipts */
1085: ce_bank_acct_uses bau,
1086: ce_bank_accounts cba,
1087: hz_parties bank,
1088: hz_organization_profiles pr
1089: WHERE br.remittance_batch_id = p_batch_id
1090: and hca.party_id = party.party_id