APPS.AMS_THRESHOLD_NOTIFY SQL Statements

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

Line: 35

SELECT employee_id source_id
FROM ams_jtf_rs_emp_v
WHERE resource_id = p_user_id ;

Line: 249

      SELECT  log_message_text
      FROM ams_act_logs
      WHERE activity_log_id = p_activity_log_id;