DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on HZ_ORGANIZATION_PROFILES

Line 3937: hz_organization_profiles pr

3933: /* Need to pass country code for SEPA specific receipts */
3934: ce_bank_acct_uses bau,
3935: ce_bank_accounts cba,
3936: hz_parties bank,
3937: hz_organization_profiles pr
3938: WHERE cr.selected_remittance_batch_id = p_batch_id
3939: AND g.cash_receipt_id = cr.cash_receipt_id
3940: AND hca.party_id = party.party_id
3941: AND hca.cust_account_id = cr.pay_from_customer

Line 4687: hz_organization_profiles pr

4683: ar_cash_receipts_all cr,
4684: ce_bank_acct_uses bau,
4685: ce_bank_accounts cba,
4686: hz_parties bank,
4687: hz_organization_profiles pr
4688: WHERE a.batch_id = p_batch_id
4689: AND a.current_worker = WORKER_NUMBER
4690: AND a.cash_receipt_id = cr.cash_receipt_id
4691: AND bau.bank_acct_use_id = cr.remit_bank_acct_use_id