APPS.JTF_ESCWFACTIVITY_PVT SQL Statements

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

Line: 66

g_jtf_object_name  JTF_OBJECTS_VL.SELECT_NAME%TYPE;

Line: 150

  IS SELECT workflow_item_type
     ,      workflow_process_name
     FROM jtf_brm_processes
     WHERE rule_id = b_rule_id;

Line: 235

  IS  SELECT source_id
      FROM   JTF_RS_RESOURCE_EXTNS
      WHERE resource_id = b_resource_id;

Line: 378

  IS  SELECT resource_id
      FROM  JTF_RS_RESOURCE_EXTNS
      WHERE source_id = b_source_id;

Line: 462

  IS  SELECT resource_id
      FROM JTF_RS_EMP_DTLS_VL
      WHERE source_id = b_source_id;

Line: 673

  IS  SELECT manager_person_id
      FROM JTF_RS_EMP_DTLS_VL
      WHERE resource_id = b_owner_id;

Line: 681

  IS  SELECT resource_id
      FROM JTF_RS_EMP_DTLS_VL
      WHERE source_id = b_source_id;

Line: 690

  IS  SELECT role.resource_id
        FROM JTF_RS_GROUP_MBR_ROLE_VL     role,
             JTF_RS_GROUP_MEMBERS_VL      mem
       WHERE role.group_id                = b_group_id
         AND mem.group_id                 = b_group_id
         AND role.group_member_id         = mem.group_member_id
         AND role.manager_flag            = 'Y'
         AND mem.category                 = 'EMPLOYEE'
         AND start_date_active           <= b_now
         AND nvl(end_date_active, b_now) >= b_now;

Line: 993

  IS  SELECT description
      FROM AK_OBJECTS_VL
      WHERE DATABASE_OBJECT_NAME = b_object_type;

Line: 1001

  IS  SELECT rule_name
      ,      rule_description
      ,      rule_owner
      FROM JTF_BRM_RULES_VL
      WHERE rule_id = b_rule_id;

Line: 1011

  IS  SELECT select_id
      ,      select_name
      ,      from_table
      FROM JTF_OBJECTS_VL
      WHERE object_code = b_obj_code;

Line: 1032

  l_select_id    JTF_OBJECTS_VL.SELECT_ID%TYPE;

Line: 1033

  l_select_name  JTF_OBJECTS_VL.SELECT_NAME%TYPE;

Line: 1072

    l_query := 'SELECT phase_owner_id,' ||
               '       territory_id,' ||
               '       phase_owner_resource_type' ||
               '  FROM CSS_DEF_DEFECTS_B' ||
               ' WHERE defect_id = :b_object_id';

Line: 1103

    l_query := 'SELECT incident_owner_id,'  ||
               '       territory_id,'       ||
               '       resource_type,'      ||
               '       owner_group_id,'     ||
               '       group_type, '         ||
	       --Added by MPADHIAR for Bug#5068840
               '       CUSTOMER_ID,'        ||
               '       ACCOUNT_ID, '        ||
               '       install_site_id '    ||
	       --Added by MPADHIAR for Bug#5068840 Ends here
               '  FROM CS_INCIDENTS_ALL_VL' ||
               ' WHERE incident_id = :b_object_id';

Line: 1231

  FETCH c_obj_details INTO l_select_id
                      ,    l_select_name
                      ,    l_from_table;

Line: 1245

  l_query := 'SELECT ' || l_select_name ||
             '  FROM ' || l_from_table  ||
             ' WHERE ' || l_select_id   ||
             '     = :b_input_id';

Line: 1388

   select TASK_TEMPLATE_GROUP_ID
     from JTF_TASK_TEMP_GROUPS_TL
    where TEMPLATE_GROUP_NAME = p_template_name ;

Line: 1537

              JTF_TASKS_PUB.Update_Task( p_api_version           => 1.0
                                       , p_init_msg_list         => FND_API.G_True
                                       , p_object_version_number => l_obj_version
                                       , p_task_id               => l_notif_task_id
                                       , p_task_name             => g_rule_name
                                       , p_description           => g_rule_desc
                                       , x_return_status         => l_return_status
                                       , x_msg_count             => l_msg_count
                                       , x_msg_data              => l_msg_data
                                       );

Line: 1667

		debug(fnd_log.level_statement, l_api_name,'Update Task failed');