13350: HZ_PARTIES P,
13351: --NPALEPU
13352: --29-JUN-2005
13353: --TCA Project
13354: --Replaced hz_party_relationships table with hz_relationships table
13355: /* HZ_PARTY_RELATIONSHIPS PR, */
13356: HZ_RELATIONSHIPS PR,
13357: --END NPALEPU
13358: HZ_ORG_CONTACTS OC
13352: --29-JUN-2005
13353: --TCA Project
13354: --Replaced hz_party_relationships table with hz_relationships table
13355: /* HZ_PARTY_RELATIONSHIPS PR, */
13356: HZ_RELATIONSHIPS PR,
13357: --END NPALEPU
13358: HZ_ORG_CONTACTS OC
13359: WHERE CAR.ROLE_TYPE = 'CONTACT'
13360: AND PR.PARTY_ID = CAR.PARTY_ID