The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT parent_resource_id
FROM jtf_rs_rep_managers mgr, jtf_rs_group_usages u
WHERE u.usage = 'SALES'
AND u.GROUP_ID = mgr.GROUP_ID
AND resource_id = parent_resource_id
AND par_role_relate_id = child_role_relate_id
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
)
AND mgr.GROUP_ID = c_group_id
AND hierarchy_type IN ('MGR_TO_MGR');
SELECT mgr.parent_resource_id
FROM jtf_rs_rep_managers mgr,
jtf_rs_group_usages u,
jtf_rs_role_relations rel,
jtf_rs_roles_b rol
WHERE u.usage = 'SALES'
AND u.GROUP_ID = mgr.GROUP_ID
AND mgr.resource_id = mgr.parent_resource_id
AND par_role_relate_id = child_role_relate_id
AND SYSDATE BETWEEN mgr.start_date_active
AND NVL (
mgr.end_date_active,
SYSDATE
)
AND mgr.GROUP_ID = c_group_id
AND hierarchy_type IN ('MGR_TO_MGR')
AND rol.role_id = rel.role_id
AND rol.role_code = c_role_code
AND rel.role_resource_type = 'RS_INDIVIDUAL'
AND rel.role_resource_id = mgr.parent_resource_id
AND SYSDATE BETWEEN rel.start_date_active
AND NVL (
rel.end_date_active,
SYSDATE
)
AND delete_flag <> 'Y';
SELECT resource_id
FROM jtf_rs_resource_extns
WHERE user_id = c_user_id
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT user_id
FROM jtf_rs_resource_extns
WHERE resource_id = c_manager_resource_id
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT source_id
FROM jtf_rs_resource_extns
WHERE resource_id = c_manager_resource_id
AND CATEGORY = 'EMPLOYEE'
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT resource_name
FROM jtf_rs_resource_extns_vl
WHERE resource_id = c_resource_id
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT group_name
FROM jtf_rs_groups_tl
WHERE GROUP_ID = c_group_id
AND LANGUAGE = USERENV (
'LANG'
);
SELECT user_name
FROM fnd_user
WHERE user_id = c_user_id
AND SYSDATE BETWEEN start_date AND NVL (
end_date,
SYSDATE
);
SELECT grp.parent_group_id
FROM jtf_rs_groups_denorm grp, jtf_rs_group_usages u
WHERE u.usage = 'SALES'
AND u.GROUP_ID = grp.GROUP_ID
AND grp.GROUP_ID = c_group_id
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
)
AND grp.immediate_parent_flag = 'Y';
approver.api_insertion := ame_util.oamgenerated;
SELECT resource_id
FROM jtf_rs_resource_extns
WHERE user_id = c_user_id
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT resource_id
FROM jtf_rs_resource_extns
WHERE source_id = c_person_id
AND CATEGORY = 'EMPLOYEE'
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT user_id
FROM jtf_rs_resource_extns
WHERE resource_id = c_manager_resource_id
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT source_id
FROM jtf_rs_resource_extns
WHERE resource_id = c_manager_resource_id
AND CATEGORY = 'EMPLOYEE'
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT grp.parent_group_id
FROM jtf_rs_groups_denorm grp, jtf_rs_group_usages u
WHERE u.usage = 'SALES'
AND u.GROUP_ID = grp.GROUP_ID
AND grp.GROUP_ID = c_group_id
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
)
AND grp.immediate_parent_flag = 'Y';
SELECT resource_name
FROM jtf_rs_resource_extns_vl
WHERE resource_id = c_resource_id
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT group_name
FROM jtf_rs_groups_tl
WHERE GROUP_ID = c_group_id
AND LANGUAGE = USERENV (
'LANG'
);
SELECT user_name
FROM fnd_user
WHERE user_id = c_user_id
AND SYSDATE BETWEEN start_date AND NVL (
end_date,
SYSDATE
);
nextapprover.api_insertion := ame_util.oamgenerated;
surrogate.api_insertion := ame_util.oamgenerated;
SELECT resource_id
FROM jtf_rs_resource_extns
WHERE user_id = c_user_id
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT resource_id
FROM jtf_rs_resource_extns
WHERE source_id = c_person_id
AND CATEGORY = 'EMPLOYEE'
AND SYSDATE BETWEEN start_date_active
AND NVL (
end_date_active,
SYSDATE
);
SELECT COUNT (
*
)
FROM jtf_rs_role_relations rel, jtf_rs_roles_b rol
WHERE rol.role_id = rel.role_id
AND rol.role_code = c_role_code
AND rel.role_resource_type = 'RS_INDIVIDUAL'
AND rel.role_resource_id = c_resource_id
AND SYSDATE BETWEEN rel.start_date_active
AND NVL (
rel.end_date_active,
SYSDATE
)
AND delete_flag <> 'Y';
--SELECT /*+ ordered */ COUNT (*)
/*
FROM jtf_rs_rep_managers mgr,
jtf_rs_group_usages u,
jtf_rs_role_relations rel,
jtf_rs_roles_b rol
WHERE u.usage = 'SALES'
AND u.GROUP_ID = mgr.GROUP_ID
AND SYSDATE BETWEEN rel.start_date_active
AND NVL ( rel.end_date_active, SYSDATE)
AND delete_flag <> 'Y'
AND rol.role_id = rel.role_id
AND rol.role_code = c_role_code
AND rel.role_resource_type = 'RS_INDIVIDUAL'
AND rel.role_resource_id = mgr.resource_id
AND SYSDATE BETWEEN mgr.start_date_active
AND NVL ( mgr.end_date_active, SYSDATE)
AND mgr.parent_resource_id = c_resource_id
AND mgr.hierarchy_type = 'MGR_TO_MGR';
SELECT user_name
FROM fnd_user
WHERE user_id = c_user_id
AND SYSDATE BETWEEN start_date AND NVL (
end_date,
SYSDATE
);