APPS.ASP_ALERTS_SUBS SQL Statements

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

Line: 75

         SELECT r.object_id,
                t.escalation_level
           FROM jtf_tasks_vl t,
                jtf_task_references_vl r
          WHERE t.task_id = p_task_id
            and t.task_id = r.task_id
            and r.object_type_code = 'SR'
            and r.reference_code = 'ESC'
            and r.object_id IS NOT NULL;

Line: 113

      SELECT l_incident_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;

Line: 142

    SELECT to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;