181: hz_cust_site_uses hzsu,
182: ra_customer_trx ract,
183: -- ra_site_uses rasu,
184: hz_locations loc,
185: hz_party_sites pty
186: WHERE arps.payment_schedule_id = pay_sched_id
187: AND ract.customer_trx_id = arps.customer_trx_id
188: AND hzsu.site_use_id = ract.bill_to_site_use_id
189: AND ad.cust_acct_site_id = hzsu.cust_acct_site_id
918: hz_cust_site_uses hzsu,
919: ra_customer_trx ract,
920: --ra_site_uses rasu,
921: hz_locations loc,
922: hz_party_sites pty
923: WHERE arps.payment_schedule_id = pay_sched_id
924: AND ract.customer_trx_id = arps.customer_trx_id
925: AND hzsu.site_use_id = ract.bill_to_site_use_id
926: AND ad.cust_acct_site_id = hzsu.cust_acct_site_id