eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_CONTACT_PREFERENCES

Line 1233: FROM HZ_CONTACT_PREFERENCES

1229:
1230: CURSOR dupcheck IS
1231: SELECT
1232: CONTACT_PREFERENCE_ID
1233: FROM HZ_CONTACT_PREFERENCES
1234: WHERE contact_level_table = p_owner_table_name
1235: AND contact_level_table_id = p_to_fk_id
1236: AND (status IS NULL OR status = 'A')
1237: AND --Bug:4390508 - contact_type || preference_code || preference_topic_type ||

Line 1246: FROM HZ_CONTACT_PREFERENCES

1242: contact_type ||
1243: preference_topic_type ||
1244: preference_topic_type_id ||
1245: preference_topic_type_code
1246: FROM HZ_CONTACT_PREFERENCES
1247: WHERE contact_preference_id = p_from_id)
1248: AND NOT (
1249: ( preference_end_date is not null and
1250: preference_end_date <= ( SELECT preference_start_date

Line 1251: FROM HZ_CONTACT_PREFERENCES

1247: WHERE contact_preference_id = p_from_id)
1248: AND NOT (
1249: ( preference_end_date is not null and
1250: preference_end_date <= ( SELECT preference_start_date
1251: FROM HZ_CONTACT_PREFERENCES
1252: WHERE contact_preference_id = p_from_id))
1253: OR
1254: ( exists (SELECT 1
1255: FROM HZ_CONTACT_PREFERENCES

Line 1255: FROM HZ_CONTACT_PREFERENCES

1251: FROM HZ_CONTACT_PREFERENCES
1252: WHERE contact_preference_id = p_from_id))
1253: OR
1254: ( exists (SELECT 1
1255: FROM HZ_CONTACT_PREFERENCES
1256: WHERE contact_preference_id = p_from_id
1257: AND preference_end_date is not null) AND
1258: preference_start_date >= ( SELECT preference_end_date
1259: FROM HZ_CONTACT_PREFERENCES

Line 1259: FROM HZ_CONTACT_PREFERENCES

1255: FROM HZ_CONTACT_PREFERENCES
1256: WHERE contact_preference_id = p_from_id
1257: AND preference_end_date is not null) AND
1258: preference_start_date >= ( SELECT preference_end_date
1259: FROM HZ_CONTACT_PREFERENCES
1260: WHERE contact_preference_id = p_from_id))
1261: )
1262: AND NOT (
1263: (

Line 1268: from HZ_CONTACT_PREFERENCES

1264: (decode(preference_start_time_hr, null, 0, preference_start_time_hr) * 60 +
1265: decode(preference_start_time_mi, null, 0, preference_start_time_mi)) >
1266: ( select (decode(preference_end_time_hr, null, 24, preference_end_time_hr) * 60 +
1267: decode (preference_end_time_mi, null, 60, preference_end_time_mi))
1268: from HZ_CONTACT_PREFERENCES
1269: WHERE contact_preference_id = p_from_id)
1270: ) OR (
1271: (decode(preference_end_time_hr, null, 24, preference_end_time_hr ) * 60 +
1272: decode(preference_end_time_mi, null, 60, preference_end_time_mi)) <

Line 1275: FROM HZ_CONTACT_PREFERENCES

1271: (decode(preference_end_time_hr, null, 24, preference_end_time_hr ) * 60 +
1272: decode(preference_end_time_mi, null, 60, preference_end_time_mi)) <
1273: (select (decode(preference_start_time_hr, null, 0, preference_start_time_hr) * 60 +
1274: decode(preference_start_time_mi, null, 0, preference_start_time_mi ))
1275: FROM HZ_CONTACT_PREFERENCES
1276: WHERE contact_preference_id = p_from_id)
1277: )
1278: );
1279: