2152: HZ_PARTY_SITES PARTY_SITE,
2153: HZ_LOCATIONS LOC,
2154: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2155: HZ_PARTIES PARTY,
2156: HZ_CUST_ACCOUNTS CUST_ACCT
2157: WHERE SU.SITE_USE_ID = p_key
2158: AND SU.CUST_ACCT_SITE_ID = acct_site.cust_acct_site_id
2159: and acct_site.cust_account_id = cust_acct.cust_account_id
2160: and cust_acct.party_id = party.party_id