[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_rlse_stmt := 'select /*+ index ( HZ_CONTACT_PREFERENCES, HZ_CONTACT_PREFERENCES_N1 ) */ /*+ index ( AMS_LIST_ENTRIES, AMS_LIST_ENTRIES_N6 ) */ b.contact_level_table '
|| ' from ams_list_entries a, hz_contact_preferences b, iec_g_return_entries c '
|| ' where c.returns_id = :returnId '
|| ' and c.list_entry_id = a.list_entry_id '
|| ' and c.list_header_id = a.list_header_id '
|| ' and nvl( b.preference_code, ''DO'') = ''DO_NOT'' '
|| ' and ( '
|| ' ( b.contact_level_table_id = nvl(a.party_id, -1 ) and b.contact_level_table = ''HZ_PARTIES'' ) '
|| ' or '
|| ' ( b.contact_level_table_id = c.CONTACT_POINT_ID and b.contact_level_table = ''HZ_CONTACT_POINTS'' ) '
|| ' ) '
|| ' and ( nvl( b.contact_type, ''CALL'' ) = ''CALL'' '
|| ' OR b.contact_type = ''ALL'' )'
|| ' and ( '
|| ' ( nvl(b.preference_start_date, sysdate - 1) < sysdate '
|| ' and nvl( b.preference_end_date, sysdate + 1 ) > sysdate ) '
|| ' ) ';
iec_returns_util_pvt.update_entry( P_RETURNS_ID
, -1
, to_char(null)
, to_char(null)
, to_char(null)
, 31
, 0
, 0
, 'N');