APPS.WSH_ITM_PARTY_SYNC dependencies on HZ_CONTACT_POINTS

Line 123: 'hz_contact_points hcp,' ||

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 '||
126: ' hr.subject_table_name = ''HZ_PARTIES'' ' ||
127: ' AND hr.object_table_name =''HZ_PARTIES'' ' ||

Line 1421: hz_contact_points where contact_point_type ='EMAIL'

1417: EXCEPTION
1418: WHEN NO_DATA_FOUND THEN
1419: BEGIN
1420: SELECT email_address into l_varchar_ctEmail_tab(j) FROM
1421: hz_contact_points where contact_point_type ='EMAIL'
1422: and owner_table_id = l_num_partyrel_tab(j)
1423: --added for bug 6391747
1424: and owner_table_name = 'HZ_PARTIES'
1425: and primary_flag ='Y';

Line 1433: hz_contact_points where contact_point_type ='PHONE'

1429: END ;
1430:
1431: BEGIN
1432: SELECT phone_number into l_varchar_ctPhone_tab(j) FROM
1433: hz_contact_points where contact_point_type ='PHONE'
1434: AND owner_table_id = l_num_partyrel_tab(j)
1435: --added for bug 6391747
1436: AND owner_table_name = 'HZ_PARTIES'
1437: AND phone_line_type= 'GEN'

Line 1445: hz_contact_points where contact_point_type ='PHONE'

1441: l_varchar_ctPhone_tab(j) :=null;
1442: END ;
1443: BEGIN
1444: SELECT phone_number into l_varchar_ctFax_tab(j) FROM
1445: hz_contact_points where contact_point_type ='PHONE'
1446: AND owner_table_id = l_num_partyrel_tab(j)
1447: --added for bug 6391747
1448: AND owner_table_name = 'HZ_PARTIES'
1449: and phone_line_type= 'FAX'