APPS.IEU_WORKLIST_ENUMS_PVT SQL Statements

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

Line: 34

   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_WORKLIST_LBL';

Line: 66

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

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

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

        ( select group_id from jtf_rs_group_members where resource_id= :owner_id ) and (status_id <> 3 or status_id <> 4) ';

Line: 143

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

        ( select group_id from jtf_rs_group_members where resource_id= :assignee_id ) and (status_id <> 3 or status_id <> 4) ';

Line: 195

 select node_type
 into   l_node_type
 from   ieu_uwq_sel_rt_nodes
 where  resource_id=P_RESOURCE_ID
 and    node_id=P_NODE_ID;

Line: 216

     select count(*)
     into  x_count
     from ieu_uwqm_items where
      (((owner_id in (select group_id from jtf_rs_group_members where
                 resource_id=p_resource_id ) and owner_type=l_owner_type_grp)
     OR (owner_id=p_resource_id AND owner_type = l_owner_type_ind))
     OR
      ((assignee_id in (select group_id from jtf_rs_group_members where
        resource_id=p_resource_id ) and assignee_type=l_owner_type_grp)
     OR (assignee_id=p_resource_id AND assignee_type = l_owner_type_ind)))
     and status_id not in (3,4);

Line: 266

   select count(*)
   into   x_ind_own_count
--   from   IEU_UWQ_WORKLIST_V
   from   ieu_uwqm_items
   where  owner_type = 'RS_INDIVIDUAL'
   and    owner_id = p_resource_id
   and    (status_id <> 3 or status_id <> 4);

Line: 282

   select count(*)
   into   x_grp_own_count
   from   ieu_uwqm_items
   where  owner_type ='RS_GROUP'
   and    owner_id in
          (
           select group_id from jtf_rs_group_members
           where resource_id= p_resource_id
          )
   and    (status_id <> 3 or status_id <> 4);

Line: 300

   select count(*)
   into   x_ind_asg_count
   from   ieu_uwqm_items
   where  assignee_type ='RS_INDIVIDUAL'
   and    assignee_id = p_resource_id
   and    (status_id <> 3 or status_id <> 4);

Line: 314

   select count(*)
   into   x_grp_asg_count
   from   ieu_uwqm_items
   where
   assignee_type = 'RS_GROUP'
   and assignee_id in
       (
          select group_id from jtf_rs_group_members
          where resource_id= p_resource_id
       )
   and  (status_id <> 3 or status_id <> 4);