The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
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;
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
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 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;
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
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 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;
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
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 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;
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;
l_sql_stmt := 'Select meaning from fnd_lookup_values_vl where lookup_type = :1 and view_application_id = :2 and lookup_code = :3';
/* 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';
/* 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'; */
/* 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'; */
/* 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'; */
l_grp_own_tk_bind_list(2).bind_var_name := ':delete_flag';
/* 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)'; */
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) ';
l_grp_own_tk_bind_list(3).bind_var_name := ':delete_flag';
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';
l_grp_own_tk_bind_list(3).bind_var_name := ':delete_flag';
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';
/* 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'; */
l_grp_asg_tk_bind_list(2).bind_var_name := ':delete_flag';
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) ';
l_grp_asg_tk_bind_list(3).bind_var_name := ':delete_flag';
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';
l_grp_asg_tk_bind_list(3).bind_var_name := ':delete_flag';
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';
/* 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'; */
l_team_own_tk_bind_list(2).bind_var_name := ':delete_flag';
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)';
l_team_own_tk_bind_list(3).bind_var_name := ':delete_flag';
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';
l_team_own_tk_bind_list(3).bind_var_name := ':delete_flag';
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';
/* 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'; */
l_team_asg_tk_bind_list(2).bind_var_name := ':delete_flag';
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)';
l_team_asg_tk_bind_list(3).bind_var_name := ':delete_flag';
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';
l_team_asg_tk_bind_list(3).bind_var_name := ':delete_flag';
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';