APPS.AS_IMPORT_SL_PVT dependencies on HZ_CONTACT_PREFERENCES

Line 1042: from hz_contact_preferences

1038: Begin
1039: l_res_id := NULL;
1040: select contact_preference_id
1041: into l_res_id
1042: from hz_contact_preferences
1043: where contact_level_table_id = pI.party_site_id
1044: and contact_type = 'MAIL'
1045: and contact_level_table = 'HZ_PARTY_SITES';
1046:

Line 1081: from hz_contact_preferences

1077: Begin
1078: l_res_id := NULL;
1079: select contact_preference_id
1080: into l_res_id
1081: from hz_contact_preferences
1082: where contact_level_table_id = pI.rel_party_id
1083: and contact_type = 'MAIL'
1084: and contact_level_table = 'HZ_PARTIES';
1085:

Line 1121: from hz_contact_preferences

1117: Begin
1118: l_res_id := NULL;
1119: select contact_preference_id
1120: into l_res_id
1121: from hz_contact_preferences
1122: where contact_level_table_id = pI.rel_party_id
1123: and contact_type = 'CALL'
1124: and contact_level_table = 'HZ_PARTIES';
1125:

Line 1156: from hz_contact_preferences

1152: Begin
1153: l_res_id := NULL;
1154: select contact_preference_id
1155: into l_res_id
1156: from hz_contact_preferences
1157: where contact_level_table_id = pI.phone_id
1158: and contact_type = 'CALL'
1159: and contact_level_table = 'HZ_CONTACT_POINTS';
1160:

Line 1195: from hz_contact_preferences

1191: Begin
1192: l_res_id := NULL;
1193: select contact_preference_id
1194: into l_res_id
1195: from hz_contact_preferences
1196: where contact_level_table_id = pI.rel_party_id
1197: and contact_type = 'FAX'
1198: and contact_level_table = 'HZ_PARTIES';
1199:

Line 1233: from hz_contact_preferences

1229: Begin
1230: l_res_id := NULL;
1231: select contact_preference_id
1232: into l_res_id
1233: from hz_contact_preferences
1234: where contact_level_table_id = pI.rel_party_id
1235: and contact_type = 'EMAIL'
1236: and contact_level_table = 'HZ_PARTIES';
1237: