177: SELECT loc.city
178: INTO city
179: FROM ar_payment_schedules arps,
180: hz_cust_acct_sites ad,
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
928: INTO city,
929: state --Bug 2319552
930: FROM ar_payment_schedules arps,
931: hz_cust_acct_sites ad,
932: hz_cust_site_uses hzsu,
933: ra_customer_trx ract,
934: --ra_site_uses rasu,
935: hz_locations loc,
936: hz_party_sites pty