The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
group_resource_type_id
FROM
pa_resource_lists
WHERE resource_list_id = p_resource_list_id;
SELECT
resource_type_code
FROM
pa_resource_types
WHERE resource_type_id = l_resource_type_id;
SELECT
resource_list_member_id,
track_as_labor_flag
FROM
pa_resource_list_members
WHERE resource_list_id = p_resource_list_id
AND parent_member_id IS NULL
AND resource_id = l_resource_id;
SELECT
revenue_category_m
FROM
pa_revenue_categories_v
WHERE
revenue_category_code = p_resource_group;
SELECT
organization_name
FROM
pa_organizations_res_v
WHERE
organization_id = l_org_id ;
p_err_stage := ' Select group_resource_type_id from pa_resource_lists';
p_err_stage := 'Select resource_type_code from pa_resource_types ';
' Select revenue_category_m from pa_revenue_categories_v';
' Select organization_name from pa_organizations_res_v';
'Select resource_list_member_id from pa_resource_list_members';
SELECT
resource_list_member_id,
track_as_labor_flag
FROM
pa_resource_list_members
WHERE resource_list_id = p_resource_list_id
AND parent_member_id IS NULL
AND resource_id = l_resource_id;
SELECT
resource_list_member_id,
track_as_labor_flag
FROM
pa_resource_list_members
WHERE resource_list_id = p_resource_list_id
AND parent_member_id = p_parent_member_id
AND resource_id = l_resource_id;
'Select resource_list_member_id from pa_resource_list_members';
SELECT
resource_type_id
FROM
pa_resource_types
WHERE resource_type_code = p_resource_type_code;
SELECT a.resource_id
FROM pa_resources a, pa_resource_txn_attributes b
WHERE a.resource_type_id = l_resource_type_id
AND a.resource_id = b.resource_id
AND b.person_id = p_person_id;
SELECT a.resource_id
FROM pa_resources a, pa_resource_txn_attributes b
WHERE a.resource_type_id = l_resource_type_id
AND a.resource_id = b.resource_id
AND b.job_id = p_job_id ;
SELECT a.resource_id
FROM pa_resources a, pa_resource_txn_attributes b
WHERE a.resource_type_id = l_resource_type_id
AND a.resource_id = b.resource_id
AND b.organization_id = p_proj_organization_id;
SELECT a.resource_id
FROM pa_resources a, pa_resource_txn_attributes b
WHERE a.resource_type_id = l_resource_type_id
AND a.resource_id = b.resource_id
AND b.vendor_id = p_vendor_id;
SELECT a.resource_id
FROM pa_resources a, pa_resource_txn_attributes b
WHERE a.resource_type_id = l_resource_type_id
AND a.resource_id = b.resource_id
AND b.expenditure_type = p_expenditure_type;
SELECT a.resource_id
FROM pa_resources a, pa_resource_txn_attributes b
WHERE a.resource_type_id = l_resource_type_id
AND a.resource_id = b.resource_id
AND b.event_type = p_event_type;
SELECT a.resource_id
FROM pa_resources a, pa_resource_txn_attributes b
WHERE a.resource_type_id = l_resource_type_id
AND a.resource_id = b.resource_id
AND b.expenditure_category = p_expenditure_category;
SELECT a.resource_id
FROM pa_resources a, pa_resource_txn_attributes b
WHERE a.resource_type_id = l_resource_type_id
AND a.resource_id = b.resource_id
AND b.revenue_category = p_revenue_category_code;
SELECT a.resource_id
FROM pa_resources a, pa_resource_txn_attributes b
WHERE a.resource_type_id = l_resource_type_id
AND a.resource_id = b.resource_id
AND b.project_role_id = p_project_role_id ;
p_err_stage := 'Select resource_type_id from pa_resource_types ';
p_err_stage := 'Select resource_id from pa_resource_txn_attributes ';
l_statement := 'Select unit_of_measure,rollup_quantity_flag ,'||
' track_as_labor_flag from ';
p_err_stage := 'Select unit_of_measure...from ... ';
SELECT
rl.resource_list_id,
rlm.resource_list_member_id,
rlm.resource_id,
rlm.track_as_labor_flag
FROM
pa_resource_lists rl,
pa_resource_list_members rlm
WHERE rl.uncategorized_flag = 'Y'
AND rlm.resource_class_code = 'FINANCIAL_ELEMENTS' -- shelly
AND rlm.resource_class_flag = 'Y' --shelly
AND rl.resource_list_id = rlm.resource_list_id
AND rl.business_group_id = pa_utils.business_group_id; /* Added for Bug 2373165 */
SELECT
resource_list_member_id,
track_as_labor_flag
FROM
pa_resource_list_members
WHERE resource_list_id = p_resource_list_id
AND parent_member_id IS NULL
AND resource_id = p_unclassified_resource_id;
SELECT
resource_list_member_id,
track_as_labor_flag
FROM
pa_resource_list_members
WHERE resource_list_id = p_resource_list_id
AND parent_member_id = p_parent_member_id
AND resource_id = p_unclassified_resource_id;
SELECT par.resource_id,
par.name,
par.track_as_labor_flag,
par.unit_of_measure,
par.rollup_quantity_flag
FROM pa_resources par,
pa_resource_types part
WHERE part.resource_type_code = 'UNCLASSIFIED'
AND part.resource_type_id = par.resource_type_id;
select 1
into temp
from sys.dual where
exists ( select 1 from pa_resource_list_members p,pa_project_accum_headers h
where p.resource_list_member_id = h.resource_list_member_id
and p.parent_member_id = p_resource_id
and h.project_id = p_project_id
and h.task_id = p_task_id );
Procedure delete_resource_list_ok(l_resource_list_id NUMBER,
p_is_plan_res_list IN VARCHAR2 default 'N',
x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
x_err_stage IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
l_dummy VARCHAR2(1);
SELECT 'x'
FROM dual
WHERE exists
(select 'x'
from pa_resource_list_members rlm
, pa_resources r
, pa_resource_types rt
where
rlm.resource_list_id = l_resource_list_id
and rlm.resource_id = r.resource_id
and r.resource_type_id = rt.resource_type_id
and rt.resource_type_code <> 'UNCLASSIFIED');
SELECT 'x'
FROM dual
WHERE exists
(select 'x'
from pa_resource_list_assignments rla
where rla.resource_list_id = l_resource_list_id);
Select 'X'
From dual
Where exists
(Select null
From pa_project_types_all pa
Where pa.DEFAULT_RESOURCE_LIST_ID = l_resource_list_id
Or pa.COST_BUDGET_RESOURCE_LIST_ID = l_resource_list_id
Or pa.REV_BUDGET_RESOURCE_LIST_ID = l_resource_list_id);
Select 'X'
From dual
Where exists
(Select null
From pa_budget_versions
Where resource_list_id = l_resource_list_id);
Select 'X'
From pa_proj_fp_options
Where all_resource_list_id = l_resource_list_id
OR cost_resource_list_id = l_resource_list_id
OR revenue_resource_list_id = l_resource_list_id;
END delete_resource_list_ok;
Procedure delete_resource_list_member_ok(l_resource_list_id NUMBER,l_resource_list_member_id NUMBER,x_err_code IN OUT NOCOPY NUMBER,x_err_stage IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
l_dummy VARCHAR2(1);
SELECT 'x'
FROM dual
WHERE exists
(select 'x'
from pa_resource_list_assignments rla, pa_project_accum_headers pah
where rla.resource_list_id = l_resource_list_id
and rla.project_id = pah.project_id
and rla.resource_list_id = pah.resource_list_id
and pah.resource_list_member_id = l_resource_list_member_id);
SELECT 'x'
FROM dual
WHERE exists
(select 'x'
from pa_resource_list_assignments rla
, pa_budget_versions bv
, pa_resource_assignments ra
where rla.resource_list_id = l_resource_list_id
and rla.project_id = bv.project_id
and rla.resource_list_id = bv.resource_list_id
and bv.budget_version_id = ra.budget_version_id
and bv.project_id = ra.project_id
and ra.resource_list_member_id = l_resource_list_member_id);*/
SELECT 'x'
FROM dual
WHERE exists
(select 'x'
from pa_resource_assignments ra
where ra.resource_list_member_id = l_resource_list_member_id);
END delete_resource_list_member_ok;