APPS.ARP_PROGRAM_BR_REMIT dependencies on HZ_PARTIES

Line 1083: hz_parties party,

1079: br.payment_trxn_extension_id,
1080: pr.home_country
1081: FROM ra_customer_trx br,
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,

Line 1087: hz_parties bank,

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
1091: and hca.cust_account_id = br.drawee_id