1401: AND hp.party_id = hp.party_id),
1402: (SELECT
1403: COUNT(1)
1404: FROM
1405: hz_party_usages_vl pu,
1406: hz_party_usg_assignments ua,
1407: hz_parties hp1
1408: WHERE
1409: pu.party_usage_code = ua.party_usage_code