APPS.WSH_ITM_PARTY_SYNC dependencies on HZ_RELATIONSHIPS

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

97: ' AND acct.STATUS = ''A'' '||
98: ' AND party.PARTY_ID = person_profile.PARTY_ID(+) ';
99:
100: l_ContactQuery VARCHAR2(1000) := ' OR party.party_id IN' || --TCA view removal starts
101: '( SELECT hr.object_id FROM hz_relationships hr,' ||
102: ' hz_Parties hp,' ||
103: 'hz_contact_points hcp,' ||
104: ' hz_org_contacts hoc' ||
105: ' WHERE '||

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

1008: l_varchar_Attrib12_tab,
1009: l_varchar_Attrib13_tab,
1010: l_varchar_Attrib14_tab,
1011: l_varchar_Attrib15_tab
1012: from hz_relationships hr, --TCA view removal Starts
1013: hz_Parties hp,
1014: hz_org_contacts hoc,
1015: hz_cust_account_roles hcar
1016: where hr.subject_table_name = 'HZ_PARTIES'