The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT max(budget_version_id)
FROM pa_budget_versions
WHERE project_id = p_project_id
AND budget_type_code = 'AR'
AND budget_status_code = 'W'
AND version_number = 1;
SELECT task_id, sum(nvl(projfunc_allocated_amount,0)) fund_amt
FROM pa_project_fundings
WHERE project_id = p_project_id
AND ( (budget_type_code IN ('DRAFT', 'BASELINE') AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (
( (budget_type_code ='BASELINE') OR
(budget_type_code ='DRAFT' AND funding_category=
'REVALUATION') ))))
AND ((x_funding_level = 'T' and task_id is not null)
or (x_funding_level = 'P' and task_id is null))
group by task_id;/*Bug 8718600*/
select start_date, completion_date
into l_start_date, l_end_date
from pa_tasks
where task_id = f1_rec.task_id
and project_id = p_project_id;
SELECT R1.resource_list_id resource_list_id,
M.resource_list_member_id resource_list_member_id
FROM pa_resource_lists R1, pa_implementations I,
pa_resource_list_members M
WHERE R1.uncategorized_flag = 'Y'
AND R1.business_group_id = I.business_group_id
AND R1.resource_list_id = M.resource_list_id;
SELECT R1.resource_list_id resource_list_id,
M.resource_list_member_id resource_list_member_id
FROM pa_resource_lists R1, pa_implementations I,
pa_resource_list_members M
WHERE R1.uncategorized_flag = 'Y'
AND R1.business_group_id = I.business_group_id
AND R1.resource_list_id = M.resource_list_id
and m.resource_class_code = 'FINANCIAL_ELEMENTS';
SELECT start_date, completion_date
FROM pa_projects_all
WHERE project_id = p_project_id;
SELECT task_id, sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,
sum(nvl(project_allocated_amount,0)) proj_fund_amt
FROM pa_project_fundings
WHERE project_id = p_project_id
AND ((budget_type_code IN ('DRAFT', 'BASELINE')
AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y'
AND (((budget_type_code ='BASELINE')
OR (budget_type_code ='DRAFT'
AND funding_category= 'REVALUATION')))))
AND ((x_funding_level = 'T' and task_id is not null)
or (x_funding_level = 'P' and task_id is null))
AND nvl(PA_Funding_Core.G_FUND_BASELINE_FLAG,'N') ='N'
-- FP_M changes: Added UNION clause for Change Management enhancements
-- This cursor is modified to fetch only from the selected
-- funding lines that needs to be baselined ONLY when
-- a global value PA_Funding_Core.G_FUND_BASELINE_FLAG is enabled
group by task_id
UNION
SELECT task_id,
sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,
sum(nvl(project_allocated_amount,0)) proj_fund_amt
FROM pa_project_fundings
WHERE project_id = p_project_id
AND PA_Funding_Core.G_FUND_BASELINE_FLAG = 'Y'
AND (NVL(Submit_Baseline_Flag,'N') = 'Y' OR
budget_type_code = 'BASELINE' )
AND ((x_funding_level = 'T' and task_id is not null)
or ( x_funding_level = 'P' and task_id is null))
group by task_id;/*Bug 8718600*/
SELECT project_id
INTO l_project_id
FROM pa_projects_all
WHERE project_id = p_project_id
FOR UPDATE NOWAIT;
select start_date, completion_date
into l_start_date, l_end_date
from pa_tasks
where task_id = fp_rec.task_id
and project_id = p_project_id;
select nvl(max(version_number), 0)
into l_max_version
from pa_budget_versions
where project_id = p_project_id
and budget_type_code = 'AR'
and budget_status_code = 'B';
Update PA_Project_Fundings
SET Submit_Baseline_Flag = 'Y'
Where Project_ID = P_Project_ID
AND Agreement_ID = P_Agreement_ID
AND CI_ID is null
AND Budget_Type_Code = 'DRAFT'
AND NVL(Submit_Baseline_Flag,'N') <> 'Y';
Update PA_Project_Fundings
SET Submit_Baseline_Flag = 'Y'
Where Project_ID = P_Project_ID
AND CI_ID = P_CI_ID_Tab(ci_rec)
AND Budget_Type_Code = 'DRAFT'
AND NVL(Submit_Baseline_Flag,'N') <> 'Y';