APPS.CS_AUTOGEN_TASK_PVT SQL Statements

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

Line: 60

  	 SELECT RULE
	   FROM jtf_task_types_vl
	  WHERE task_type_id = p_task_type_id ;

Line: 67

     	  SELECT template_group_name
	    FROM jtf_task_temp_groups_vl
	   WHERE task_template_group_id =  l_task_template_group_info.task_template_group_id;

Line: 290

		  l_task_template_tbl(i).p_date_selected := 'D';

Line: 465

  Select *
  From cs_sr_tsk_tmpl_seq_rules
  Where active_flag = 'Y'
  Order by search_sequence;

Line: 484

  Select task_template_group_id
  From cs_sr_tsk_tmpl_gp_map
  Where decode(p_incident_type_id, p_null_num, p_num, incident_type_id)  =  nvl(p_incident_type_id, p_num)
  And decode(p_organization_id, p_null_num, p_num, organization_id)      =  nvl(p_organization_id, p_num)
  And decode(p_inventory_item_id, p_null_num, p_num, inventory_item_id)  =  nvl(p_inventory_item_id, p_num)
  And decode(p_category_id, p_null_num, p_num, category_id)              =  nvl(p_category_id, p_num)
  And decode(p_problem_code, p_null_char, p_char, problem_code)          =  nvl(p_problem_code, p_char);

Line: 503

  Select gp.task_template_group_id
    From cs_sr_tsk_tmpl_gp_map gp,
         jtf_task_temp_groups_vl jtf
   Where nvl(gp.incident_type_id, p_num)    =  nvl(p_incident_type_id, p_num)
     And nvl(gp.organization_id, p_num)     =  nvl(p_organization_id, p_num)
     And nvl(gp.inventory_item_id, p_num)   =  nvl(p_inventory_item_id, p_num)
     And nvl(gp.category_id, p_num)         =  nvl(p_category_id, p_num)
     And nvl(gp.problem_code, p_char)       =  nvl(p_problem_code, p_char)
     AND TRUNC(sysdate) BETWEEN TRUNC(NVL(gp.start_date,sysdate)) AND TRUNC(NVL(gp.end_date,sysdate))
     AND jtf.task_template_group_id         =  gp.task_template_group_id
     AND TRUNC(sysdate) BETWEEN TRUNC(NVL(jtf.start_date_active,sysdate)) AND TRUNC(NVL(jtf.end_date_active,sysdate));

Line: 518

  SELECT category_id
  FROM mtl_item_categories
  WHERE organization_id = p_task_template_search_rec.organization_id
  AND inventory_item_id = p_task_template_search_rec.inventory_item_id
  AND category_set_id = p_category_set_id;

Line: 834

  Select *
  From Jtf_Task_Templates_vl
  Where Task_Group_Id = p_task_template_group_id
  And nvl(deleted_flag,'N') = 'N'; -- Bug 6429514

Line: 841

  Select *
  From Jtf_Task_Temp_Groups_vl
  Where Task_Template_Group_Id = p_task_template_group_id;

Line: 1189

       SELECT meaning
         INTO l_status
         FROM cs_lookups
        WHERE lookup_type = 'CS_SR_TSK_TMPL_STATUS_DISP'
          AND lookup_code = 'ACTIVE' ;

Line: 1197

       SELECT meaning
         INTO l_status
         FROM cs_lookups
        WHERE lookup_type = 'CS_SR_TSK_TMPL_STATUS_DISP'
          AND lookup_code = 'INACTIVE' ;