APPS.IEU_TASKS_ENUMS_PVT SQL Statements

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

Line: 39

   SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
   FROM JTF_TASK_TYPES_TL TYPES
   WHERE EXISTS (
      SELECT 1
        FROM   JTF_TASKS_B TASKS
        WHERE  OPEN_FLAG = 'Y'
          AND TASKS.OWNER_ID = p_resource_id
          AND TASKS.OWNER_TYPE_CODE NOT IN ( 'RS_GROUP','RS_TEAM'  )
          AND TASKS.entity = 'TASK'
          AND NVL(TASKS.DELETED_FLAG,'N') = 'N'
          AND TASKS.TASK_TYPE_ID =TYPES.TASK_TYPE_ID
   )
   and types.language = userenv('lang')
   ORDER BY 2;

Line: 76

  SELECT  /*+ first_rows */
        TYPES.TASK_TYPE_ID TASK_TYPE_ID,
        TYPES.NAME TASK_TYPE
  FROM    JTF_TASK_TYPES_TL TYPES
  WHERE   EXISTS
        ( SELECT    1
                FROM    JTF_RS_GROUP_MEMBERS M,
			    JTF_TASKS_B			   TASKS
          WHERE         M.RESOURCE_ID    = p_resource_id
              AND          TYPES.TASK_TYPE_ID=TASKS.TASK_TYPE_ID
              AND    NVL(M.DELETE_FLAG,'N') <> 'Y'
              AND    TASKS.OWNER_ID              =M.GROUP_ID
              AND    TASKS.OPEN_FLAG            = 'Y'
              AND    TASKS.OWNER_TYPE_CODE= 'RS_GROUP'
              AND    TASKS.ENTITY                = 'TASK'
              AND     NVL(TASKS.DELETED_FLAG,'N') = 'N')
AND TYPES.LANGUAGE = USERENV('lang')
ORDER BY 2;

Line: 116

SELECT  /*+ first_rows */
        TYPES.TASK_TYPE_ID TASK_TYPE_ID,
        TYPES.NAME TASK_TYPE
FROM    JTF_TASK_TYPES_TL TYPES
WHERE   EXISTS
        ( SELECT    1
                FROM    JTF_RS_TEAM_MEMBERS M,
			    JTF_TASKS_B			   TASKS
          WHERE         M.TEAM_RESOURCE_ID    = p_resource_id
              and          TYPES.TASK_TYPE_ID=TASKS.TASK_TYPE_ID
              AND    NVL(M.DELETE_FLAG,'N') <> 'Y'
              AND    TASKS.OWNER_ID              =M.TEAM_ID
              AND    TASKS.OPEN_FLAG            = 'Y'
              AND    TASKS.OWNER_TYPE_CODE= 'RS_TEAM'
              AND    TASKS.ENTITY                = 'TASK'
              AND     NVL(TASKS.DELETED_FLAG,'N') = 'N')
AND TYPES.LANGUAGE = USERENV('lang')
ORDER BY 2;

Line: 139

  SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
  FROM JTF_TASK_TYPES_TL TYPES
  WHERE TYPES.TASK_TYPE_ID IN
       (SELECT /*+ use_nl(tasks asg) */  TASKS.TASK_TYPE_ID
               FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
			,JTF_TASK_STATUSES_B STB  --Added the following code by rgandhi for Bug9920514
       WHERE exists
            (SELECT null
               FROM JTF_OBJECT_USAGES
              WHERE OBJECT_USER_CODE = 'RESOURCES'
              and object_code = ASG.RESOURCE_TYPE_CODE
              AND OBJECT_CODE NOT IN ( 'RS_GROUP','RS_TEAM'  ))
         AND TASKS.TASK_ID = ASG.TASK_ID
	    AND STB.TASK_STATUS_ID = ASG.ASSIGNMENT_STATUS_ID --Added the following code by rgandhi for Bug9920514
	    AND  NVL(STB.CANCELLED_FLAG, 'N') = 'N' --Added the following code by rgandhi for Bug9920514
         AND TASKS.OPEN_FLAG = 'Y'
         AND TASKS.entity = 'TASK'
         and ASG.RESOURCE_ID = p_resource_id
         AND NVL(TASKS.DELETED_FLAG,'N') = 'N' )
  and types.language = userenv('lang')
  ORDER BY 2;

Line: 165

  SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
  FROM
  JTF_TASK_TYPES_TL TYPES
  ,JTF_TASK_STATUSES_B STB  --Added the following code by rgandhi for Bug9920514
   WHERE TYPES.TASK_TYPE_ID IN (SELECT /*+ use_nl(tasks asg) */  TASKS.TASK_TYPE_ID
                   FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
                  WHERE exists
                  (SELECT null
                     FROM JTF_RS_GROUP_MEMBERS
                    WHERE RESOURCE_ID = p_resource_id
                      and group_id=asg.resource_id
                      AND NVL(DELETE_FLAG,'N') <> 'Y' )
                  AND TASKS.TASK_ID = ASG.TASK_ID
                  AND STB.TASK_STATUS_ID = ASG.ASSIGNMENT_STATUS_ID --Added the following code by rgandhi for Bug9920514
                  AND NVL(STB.CANCELLED_FLAG, 'N') = 'N' --Added the following code by rgandhi for Bug9920514
                  AND TASKS.OPEN_FLAG = 'Y'
                  AND TASKS.entity = 'TASK'
                  and asg.resource_type_code='RS_GROUP'
                  AND NVL(TASKS.DELETED_FLAG,'N') = 'N' )
 and types.language = userenv('lang')
 ORDER BY 2;

Line: 190

  SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
  FROM
  JTF_TASK_TYPES_TL TYPES
  ,JTF_TASK_STATUSES_B STB  --Added the following code by rgandhi for Bug9920514
   WHERE TYPES.TASK_TYPE_ID IN (SELECT /*+ use_nl(tasks asg) */  TASKS.TASK_TYPE_ID
                   FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
                  WHERE exists
                  (SELECT null
                     FROM JTF_RS_TEAM_MEMBERS
                    WHERE TEAM_RESOURCE_ID = p_resource_id
                      and team_id=asg.resource_id
                      AND NVL(DELETE_FLAG,'N') <> 'Y' )
                  AND TASKS.TASK_ID = ASG.TASK_ID
                  AND STB.TASK_STATUS_ID = ASG.ASSIGNMENT_STATUS_ID --Added the following code by rgandhi for Bug9920514
                  AND NVL(STB.CANCELLED_FLAG, 'N') = 'N' --Added the following code by rgandhi for Bug9920514
                  AND TASKS.OPEN_FLAG = 'Y'
                  AND TASKS.entity = 'TASK'
                  and asg.resource_type_code='RS_TEAM'
                  AND NVL(TASKS.DELETED_FLAG,'N') = 'N' )
 and types.language = userenv('lang')
 ORDER BY 2;

Line: 214

    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: 232

   l_sql_stmt := 'Select meaning from fnd_lookup_values_vl where lookup_type = :1 and view_application_id = :2 and lookup_code = :3';

Line: 240

/*   Select meaning into l_node_label
   from fnd_lookup_values_vl
   where lookup_type = 'IEU_NODE_LABELS'
   and view_application_id = 696
   and lookup_code = 'IEU_NEW_TASKS_LBL';

Line: 282

/*    Select meaning into l_node_label
    from fnd_lookup_values_vl
    where lookup_type = 'IEU_NODE_LABELS'
    and view_application_id = 696
    and lookup_code = 'IEU_MY_OWN_LBL'; */

Line: 381

   /* Select meaning into l_node_label
    from fnd_lookup_values_vl
    where lookup_type = 'IEU_NODE_LABELS'
    and view_application_id = 696
    and lookup_code = 'IEU_MY_ASSIGN_LBL'; */

Line: 485

/*    Select meaning into l_node_label
    from fnd_lookup_values_vl
    where lookup_type = 'IEU_NODE_LABELS'
    and view_application_id = 696
    and lookup_code = 'IEU_GRP_OWN_LBL'; */

Line: 495

    l_grp_own_tk_bind_list(2).bind_var_name  := ':delete_flag';

Line: 506

    /* l_tk_list(l_node_counter).WHERE_CLAUSE :=  ' exists ( select m.resource_id
                                                from jtf_rs_group_members m
                                                where m.group_id = owner_id
                                                and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                                ' and m.resource_id = :resource_id)'; */

Line: 511

    l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select /*+ index(m JTF_RS_GROUP_MEMBERS_N1) */
                                                m.resource_id
						from jtf_rs_group_members m
                                                where   m.group_id = owner_id
                                                and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
						' and m.resource_id = :resource_id) ';

Line: 539

      l_grp_own_tk_bind_list(3).bind_var_name  := ':delete_flag';

Line: 548

      l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
                                                from jtf_rs_group_members m
                                                where m.group_id = owner_id
                                                and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                                ' and m.resource_id = :resource_id) and
                                                TASK_TYPE_ID = :task_type_id';

Line: 579

       l_grp_own_tk_bind_list(3).bind_var_name  := ':delete_flag';

Line: 588

       l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
                                                from jtf_rs_group_members m
                                                where m.group_id = owner_id
                                                and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                                ' and m.resource_id = :resource_id) and
                                                TASK_TYPE_ID = :task_type_id';

Line: 616

  /*  Select meaning into l_node_label
    from fnd_lookup_values_vl
    where lookup_type = 'IEU_NODE_LABELS'
    and view_application_id = 696
    and lookup_code = 'IEU_GRP_ASSIGN_LBL'; */

Line: 625

    l_grp_asg_tk_bind_list(2).bind_var_name  := ':delete_flag';

Line: 634

    l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
                                                from jtf_rs_group_members m
                                                where   m.group_id = owner_id
                                                and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                               ' and m.resource_id = :resource_id) ';

Line: 659

      l_grp_asg_tk_bind_list(3).bind_var_name  := ':delete_flag';

Line: 668

      l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
                                                from jtf_rs_group_members m
                                                where   m.group_id = owner_id
                                                and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                               ' and m.resource_id = :resource_id)  and
                                                TASK_TYPE_ID = :task_type_id';

Line: 698

       l_grp_asg_tk_bind_list(3).bind_var_name  := ':delete_flag';

Line: 707

       l_tk_list(l_node_counter).WHERE_CLAUSE := ' exists ( select m.resource_id
                                                from jtf_rs_group_members m
                                                where   m.group_id = owner_id
                                                and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                               ' and m.resource_id = :resource_id) and
                                                  TASK_TYPE_ID = :task_type_id';

Line: 744

  /*  Select meaning into l_node_label
    from fnd_lookup_values_vl
    where lookup_type = 'IEU_NODE_LABELS'
    and view_application_id = 696
    and lookup_code = 'IEU_TEAM_OWN_LBL'; */

Line: 753

    l_team_own_tk_bind_list(2).bind_var_name  := ':delete_flag';

Line: 762

    l_tk_list(l_node_counter).WHERE_CLAUSE :=  ' exists ( select m.team_resource_id
                                                from jtf_rs_team_members m
                                                where m.team_id = owner_id
                                                and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                                ' and m.team_resource_id = :resource_id)';

Line: 788

      l_team_own_tk_bind_list(3).bind_var_name  := ':delete_flag';

Line: 797

      l_tk_list(l_node_counter).WHERE_CLAUSE :=  ' exists ( select m.team_resource_id
                                                   from jtf_rs_team_members m
                                                   where m.team_id = owner_id
                                                   and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                                 ' and m.team_resource_id = :resource_id) and
                                                   TASK_TYPE_ID = :task_type_id';

Line: 828

       l_team_own_tk_bind_list(3).bind_var_name  := ':delete_flag';

Line: 837

      l_tk_list(l_node_counter).WHERE_CLAUSE :=  ' exists ( select m.team_resource_id
                                                   from jtf_rs_team_members m
                                                   where m.team_id = owner_id
                                                   and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                                 ' and m.team_resource_id = :resource_id) and
                                                   TASK_TYPE_ID = :task_type_id';

Line: 867

/*    Select meaning into l_node_label
    from fnd_lookup_values_vl
    where lookup_type = 'IEU_NODE_LABELS'
    and view_application_id = 696
    and lookup_code = 'IEU_TEAM_ASSIGN_LBL'; */

Line: 876

    l_team_asg_tk_bind_list(2).bind_var_name  := ':delete_flag';

Line: 885

    l_tk_list(l_node_counter).WHERE_CLAUSE :=  ' exists ( select m.team_resource_id
                                                from jtf_rs_team_members m
                                                where m.team_id = owner_id
                                                and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                              ' and m.team_resource_id = :resource_id)';

Line: 910

      l_team_asg_tk_bind_list(3).bind_var_name  := ':delete_flag';

Line: 919

      l_tk_list(l_node_counter).WHERE_CLAUSE :=  ' exists ( select m.team_resource_id
                                                   from jtf_rs_team_members m
                                                   where m.team_id = owner_id
                                                   and nvl(delete_flag,'||''''||'N'||''''||') = '||':delete_flag'||
                                                 ' and m.team_resource_id = :resource_id) and
                                                   TASK_TYPE_ID = :task_type_id';

Line: 949

       l_team_asg_tk_bind_list(3).bind_var_name  := ':delete_flag';

Line: 958

       l_tk_list(l_node_counter).WHERE_CLAUSE :=  ' exists ( select m.team_resource_id
                                                   from jtf_rs_team_members m
                                                   where m.team_id = owner_id
                                                   and nvl(delete_flag,'||''''||'N'||''''||') = '|| ':delete_flag'||
                                                 ' and m.team_resource_id = :resource_id) and
                                                   TASK_TYPE_ID = :task_type_id';