APPS.WSH_ITM_PARTY_SYNC dependencies on HZ_RELATIONSHIPS

Line 121: '( SELECT hr.object_id FROM hz_relationships hr,' ||

117: ' AND acct.STATUS = ''A'' '||
118: ' AND party.PARTY_ID = person_profile.PARTY_ID(+) ';
119:
120: l_ContactQuery VARCHAR2(1000) := ' OR party.party_id IN' || --TCA view removal starts
121: '( SELECT hr.object_id FROM hz_relationships hr,' ||
122: ' hz_Parties hp,' ||
123: 'hz_contact_points hcp,' ||
124: ' hz_org_contacts hoc' ||
125: ' WHERE '||

Line 1389: from hz_relationships hr, --TCA view removal Starts

1385: l_ct_postal_code_tab ,
1386: l_ct_state_tab ,
1387: l_ct_province_tab ,
1388: l_ct_county_tab
1389: from hz_relationships hr, --TCA view removal Starts
1390: hz_Parties hp,
1391: hz_org_contacts hoc,
1392: hz_cust_account_roles hcar,
1393: hz_Person_profiles hpp