APPS.JTF_TASK_CUSTOM_COLORS_PUB SQL Statements

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

Line: 37

        SELECT type_id
             , priority_id
             , assignment_status_id
             , escalated_task
             , background_col_dec
             , background_col_rgb
          FROM jtf_task_custom_colors
         WHERE active_flag = 'Y'
         ORDER BY color_determination_priority;

Line: 68

        SELECT 'Y'
          FROM jtf_tasks_b esc
             , jtf_task_references_b r
             , jtf_task_statuses_b s
         WHERE r.object_id = b_task_id
           AND r.reference_code = 'ESC'
           AND r.object_type_code = 'TASK'
           AND esc.task_id = r.task_id
           AND esc.task_type_id = 22
           AND esc.escalation_level NOT IN ('DE', 'NE')
           AND NVL(esc.deleted_flag, 'N') <> 'Y'
           AND s.task_status_id = esc.task_status_id
           AND NVL(s.closed_flag, 'N') <> 'Y';