367: party.party_id,
368: sub_party.party_id
369: from
370: HZ_CUST_SITE_USES_ALL site_use,
371: HZ_CUST_ACCOUNT_ROLES acct_role,
372: HZ_ROLE_RESPONSIBILITY role_resp,
373: HZ_RELATIONSHIPS rel,
374: hz_parties party,
375: hz_parties sub_party
686: party.party_id,
687: sub_party.party_id,
688: rel.object_id
689: from
690: HZ_CUST_ACCOUNT_ROLES acct_role,
691: HZ_ROLE_RESPONSIBILITY role_resp,
692: HZ_RELATIONSHIPS rel,
693: hz_parties party,
694: hz_parties sub_party