APPS.IEU_UWQ_MY_TASKS_ENUMS_PVT SQL Statements

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

Line: 22

  l_deleted_flag	VARCHAR2(1);

Line: 33

  SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
  FROM JTF_TASK_TYPES_TL TYPES
  WHERE  TYPES.LANGUAGE = USERENV('LANG')
  AND EXISTS (
    SELECT 1
    FROM JTF_TASKS_B TASKS
    WHERE tasks.open_flag = l_open_flag
    AND TASKS.OWNER_ID = P_RESOURCE_ID
    AND TASKS.OWNER_TYPE_CODE NOT IN ( l_owner_type_code1, l_owner_type_code2 )
    AND TASKS.ENTITY = l_entity
    AND NVL(TASKS.DELETED_FLAG,'N') = l_deleted_flag
    AND TASKS.TASK_TYPE_ID =TYPES.TASK_TYPE_ID )
  ORDER BY 2;

Line: 49

    SELECT
      task_type_id, name task_type
    FROM
      jtf_task_types_vl
    WHERE
      trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
	                and     trunc(nvl(end_date_active,   sysdate))
    ORDER BY 2;

Line: 64

  l_deleted_flag	:= 'N';

Line: 75

   Select meaning into l_node_label
    from fnd_lookup_values_vl
    where lookup_type = l_lookup_type
    and view_application_id = l_application_id
    and lookup_code = l_lookup_code;

Line: 162

select where_clause
into   l_where_clause
from   ieu_uwq_sel_rt_nodes
where  resource_id=P_RESOURCE_ID
and    node_id=P_NODE_ID;

Line: 176

		'begin select /*+ index(tasks jtf_tasks_b_n2) */ count(*)  into :l_count from jtf_tasks_b tasks '||
		'where '||
		'( tasks.owner_id = :resource_id
       and tasks.owner_type_code not in ('||''''||'RS_GROUP'||''''||','||''''||'RS_TEAM'||''''||') ) '||
    'and exists
       ( select task_status_id
             from  jtf_task_statuses_vl tsv
             where tasks.open_flag = '||''''||'Y'||''''||
           ' and   tsv.task_status_id = tasks.task_status_id )
             and tasks.entity = ' ||''''|| 'TASK' ||''''|| '
             and nvl(tasks.deleted_flag,'||''''||'N'||''''||') = '||''''||'N'||''''||l_where_clause ||' ; end; ';