APPS.IEU_MSG_CON_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

PROCEDURE IEU_MSG_DEL_MESSAGES(ERRBUF OUT NOCOPY VARCHAR2, RETCODE OUT NOCOPY VARCHAR2, p_last_update_date in date) IS

l_message VARCHAR2(4000);

Line: 11

  delete from ieu_msg_messages
  where status_id = 5
  and ( to_date(trunc(last_update_date), 'dd-mm-rrrr') <= to_date(trunc(p_last_update_date), 'dd-mm-rrrr') );