APPS.RA_CUSTOMER_TEXT_PKG dependencies on HZ_LOCATIONS

Line 245: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,

241: /* Bug Fix: 4006266 */
242: FOR sites in (
243: SELECT cust_account_id, ac.cust_acct_site_id, ps.party_site_id, loc.address1||' '||loc.address2||' '||loc.address3||' '||loc.address4||' '|| loc.city||' '||loc.state||' '||
244: loc.province||' '||loc.postal_code || ' ' cust_address
245: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,
246: APPS.HZ_CUST_ACCT_SITES_ALL ac
247: WHERE ac.PARTY_SITE_ID=ps.PARTY_SITE_ID
248: AND loc.LOCATION_ID = ps.LOCATION_ID
249: AND ac.ROWID = rid)

Line 363: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,

359: /* Bug Fix: 4006266 */
360: FOR sites in (
361: SELECT ac.status, cust_account_id, ac.cust_acct_site_id, ps.party_site_id, loc.address1||' '||loc.address2||' '||loc.address3 ||' '||loc.address4||' '|| loc.city||' '||loc.state||' '||
362: loc.province||' '||loc.postal_code || ' ' cust_address
363: FROM APPS.HZ_LOCATIONS loc, APPS.HZ_PARTY_SITES ps,
364: APPS.HZ_CUST_ACCT_SITES_ALL ac
365: WHERE ac.PARTY_SITE_ID=ps.PARTY_SITE_ID
366: AND loc.LOCATION_ID = ps.LOCATION_ID
367: AND ac.ROWID = rid)