APPS.JTF_TASK_INST_TEMPLATES_PUB SQL Statements

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

Line: 34

      SELECT task_id,
             dependent_on_task_id,
             dependency_type_code,
             adjustment_time,
             adjustment_time_uom,
             template_flag
        FROM jtf_task_depends d
       WHERE d.task_id = p_task_template_id
         AND template_flag = jtf_task_utl.g_yes;

Line: 69

         SELECT source_object_type_code
           INTO l_source_object_type_code
           FROM jtf_task_temp_groups_vl
          WHERE task_template_group_id = p_task_template_group_info.task_template_group_id;

Line: 213

            SELECT recurrence_rule_id
              INTO l_recurrence_rule_id
              FROM jtf_task_templates_vl
             WHERE task_template_id = x_task_details_tbl (i).task_template_id;