APPS.WSH_ITM_PARTY_SYNC dependencies on HZ_CONTACT_POINTS

Line 103: 'hz_contact_points hcp,' ||

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

Line 1040: hz_contact_points where contact_point_type ='EMAIL'

1036: EXCEPTION
1037: WHEN NO_DATA_FOUND THEN
1038: BEGIN
1039: SELECT email_address into l_varchar_ctEmail_tab(j) FROM
1040: hz_contact_points where contact_point_type ='EMAIL'
1041: and owner_table_id = l_num_partyrel_tab(j)
1042: --added for bug 6391747
1043: and owner_table_name = 'HZ_PARTIES'
1044: and primary_flag ='Y';

Line 1052: hz_contact_points where contact_point_type ='PHONE'

1048: END ;
1049:
1050: BEGIN
1051: SELECT phone_number into l_varchar_ctPhone_tab(j) FROM
1052: hz_contact_points where contact_point_type ='PHONE'
1053: AND owner_table_id = l_num_partyrel_tab(j)
1054: --added for bug 6391747
1055: AND owner_table_name = 'HZ_PARTIES'
1056: AND phone_line_type= 'GEN'

Line 1064: hz_contact_points where contact_point_type ='PHONE'

1060: l_varchar_ctPhone_tab(j) :=null;
1061: END ;
1062: BEGIN
1063: SELECT phone_number into l_varchar_ctFax_tab(j) FROM
1064: hz_contact_points where contact_point_type ='PHONE'
1065: AND owner_table_id = l_num_partyrel_tab(j)
1066: --added for bug 6391747
1067: AND owner_table_name = 'HZ_PARTIES'
1068: and phone_line_type= 'FAX'