[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select spread_curve_id, sp_fixed_date
from pa_resource_assignments
where resource_assignment_id = p_resource_assignment_id ;
select txn_currency_code -- ,min(start_date) bug 6407736 - skkoppul
from pa_resource_asgn_curr
where resource_assignment_id = p_resource_assignment_id;
select task_id, wbs_element_version_id, supplier_id, resource_class_code, resource_assignment_id,
project_role_id, organization_id,
fc_res_type_code, named_role,res_type_code, planning_start_date, planning_end_date,
procure_resource_flag, use_task_schedule_flag, rate_based_flag from pa_resource_assignments where
resource_assignment_id = p_resource_assignment_id;
select rate_based_flag , resource_list_member_id, planning_start_date, planning_end_date
from pa_resource_assignments r
where resource_assignment_id = p_resource_assignment_id;
select a.budget_version_id, b.project_currency_code
from pa_budget_versions a, pa_projects_all b
where a.project_structure_version_id = p_structure_version_id
and a.project_id = b.project_id
and a.project_id = p_project_id;
SELECT prog.actual_finish_date, pa_progress_utils.Check_object_has_prog(
p_project_id,
p_task_id,
p_resource_assignment_id,
'PA_ASSIGNMENTS',
'WORKPLAN'
) Progress_Exists
FROM pa_assignment_progress_v prog
WHERE prog.resource_assignment_id = p_resource_assignment_id;
SELECT pe.element_version_id
from pa_proj_element_versions pe
where parent_structure_version_id = p_structure_version_id
and pe.proj_element_id = p_task_id
and pe.project_id = p_project_id;
SELECT pe.element_version_id, pe.proj_element_id
from pa_proj_element_versions pe
where pe.element_version_id = p_task_element_version_id;
SELECT a.as_of_date from pa_assignment_progress_v a
WHERE a.resource_assignment_id = p_resource_assignment_id
and a.project_id = p_pa_project_id
and a.structure_version_id = p_pa_structure_version_id;
select ppr.as_of_date
from pa_progress_rollup ppr,
pa_proj_element_versions ppv,
pa_resource_assignments pra
where ppv.parent_structure_version_id=p_pa_structure_version_id
and ppv.project_id=p_pa_project_id
and pra.resource_assignment_id=p_resource_assignment_id
and pra.project_id=ppv.project_id
and ppv.proj_element_id=pra.task_id
and ppr.object_id=pra.resource_list_member_id
and ppr.object_type='PA_ASSIGNMENTS'
and ppr.object_version_id=ppv.element_version_id
and ppr.project_id=ppv.project_id
and ppr.structure_version_id=ppv.parent_structure_version_id
and ppr.structure_type='WORKPLAN'
and ppr.current_flag='Y';
SELECT alias
from pa_resource_list_members
where resource_list_member_id = c_resource_list_member_id;
SELECT NAME
FROM pa_proj_elements
WHERE proj_element_id = c_task_id;
Select a.alias, b.resource_assignment_id
from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
where a.resource_list_member_id = b.resource_list_member_id
and b.resource_list_member_id = p_resource_list_member_id
and b.ta_display_flag = 'Y'
and b.budget_version_id = bv.budget_version_id
and b.project_id = bv.project_id
and bv.project_structure_version_id = p_structure_version_id
and b.project_id = p_project_id
and b.wbs_element_version_id = p_wbs_version_id;
Select a.alias, b.resource_assignment_id
from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
where a.resource_list_member_id = b.resource_list_member_id
and b.resource_list_member_id = p_resource_list_member_id
and b.ta_display_flag = 'Y'
and b.budget_version_id = bv.budget_version_id
and b.project_id = bv.project_id
and bv.project_structure_version_id = p_structure_version_id
and b.project_id = p_project_id
and b.wbs_element_version_id = p_wbs_version_id
and b.cbs_element_id=p_cbs_element_id;
select TRACK_WORKPLAN_COSTS_FLAG enabled_flag from pa_proj_fp_options
where fin_plan_version_id = p_budget_version_id;
SELECT gsb.period_set_name
,gsb.accounted_period_type
,pia.pa_period_type
,decode(pbv.version_type,
'COST',ppfo.cost_time_phased_code,
'REVENUE',ppfo.revenue_time_phased_code,
ppfo.all_time_phased_code) time_phase_code
,pbv.etc_start_date
FROM gl_sets_of_books gsb
,pa_implementations_all pia
,pa_projects_all ppa
,pa_budget_versions pbv
,pa_proj_fp_options ppfo
WHERE ppa.project_id = pbv.project_id
AND pbv.budget_version_id = ppfo.fin_plan_version_id
AND ppa.org_id = pia.org_id
AND gsb.set_of_books_id = pia.set_of_books_id
AND pbv.budget_version_id = c_budget_version_id;
pa_security.allow_update(x_project_id => l_project_id ) = 'N' THEN
-- The user does not have update privileges on this project
-- Hence , raise error
--dbms_output.put_line('pa_security.allow_query or update not allowed..');
select name into l_project_name from pa_projects_all where project_id = l_project_id;
IF 'Y' = pa_progress_utils.check_prog_exists_and_delete(
p_project_id => l_project_id,
p_task_id => l_d_task_id,
p_object_type => 'PA_ASSIGNMENTS',
p_object_id => p_task_assignment_periods_in(i).resource_list_member_id,
p_cbs_element_id => p_task_assignment_periods_in(i).cbs_element_id,
p_structure_type => 'WORKPLAN',
p_delete_progress_flag => 'N'
) THEN
l_prog_resource_assignment_id := l_resource_assignment_id_tbl(i);
IF 'Y' = pa_progress_utils.check_prog_exists_and_delete(
p_project_id => l_project_id,
p_task_id => l_d_task_id,
p_object_type => 'PA_ASSIGNMENTS',
p_object_id => p_task_assignment_periods_in(i).resource_list_member_id,
p_structure_type => 'WORKPLAN',
p_delete_progress_flag => 'N'
) THEN
l_prog_resource_assignment_id := l_resource_assignment_id_tbl(i);
PA_TASK_ASSIGNMENT_UTILS.VALIDATE_UPDATE_ASSIGNMENT ( p_task_assignment_tbl => P_TASK_ASSIGNMENT_TBL,
x_return_status => X_RETURN_STATUS );
update pa_resource_assignments set sp_fixed_date=null,spread_curve_id =null, record_version_number=(record_version_number+1)
where resource_assignment_id = l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id; */ -- commented for bug#13059417
update pa_resource_assignments set sp_fixed_date=l_sp_fixed_date, spread_curve_id =l_spread_curve_id, record_version_number=(record_version_number+1)
where resource_assignment_id = l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id;
SELECT gsb.period_set_name
,gsb.accounted_period_type
,pia.pa_period_type
,decode(pbv.version_type,
'COST',ppfo.cost_time_phased_code,
'REVENUE',ppfo.revenue_time_phased_code,
ppfo.all_time_phased_code) time_phase_code
,glp.start_date period_start_date,glp.end_date period_end_date
FROM gl_sets_of_books gsb
,pa_implementations_all pia
,pa_projects_all ppa
,pa_budget_versions pbv
,pa_proj_fp_options ppfo
,gl_periods glp
WHERE ppa.project_id = pbv.project_id
AND pbv.budget_version_id = ppfo.fin_plan_version_id
AND nvl(ppa.org_id,-99) = nvl(pia.org_id,-99)
AND gsb.set_of_books_id = pia.set_of_books_id
AND pbv.budget_version_id = p_budget_version_id
AND glp.period_set_name = gsb.period_set_name
-- this condition is not required as
-- period_set_name and period_name are the unique columns on gl_periods
-- and glp.period_type = decode(pbv.version_type
-- ,'COST', decode(ppfo.cost_time_phased_code,'G',gsb.accounted_period_type,'P',pia.pa_period_type)
-- ,'REVENUE',decode(ppfo.revenue_time_phased_code,'G',gsb.accounted_period_type,'P',pia.pa_period_type)
-- ,decode(ppfo.all_time_phased_code,'G',gsb.accounted_period_type,'P',pia.pa_period_type))
--
AND glp.period_name = p_period_name
AND adjustment_period_flag = 'N' ;
select pev_structure_id, record_version_number,name
from PA_proj_elem_ver_structure
where element_version_id = p_structure_version_id
and project_id = p_project_id;
PA_PROJECT_STRUCTURE_PUB1.Update_Structure_Version_Attr
(
p_pev_structure_id => l_structure_id
-- Commented for bug 4240130
--,p_locked_status_code => 'LOCKED'
,p_structure_version_name => l_name
,p_record_version_number => l_record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
SELECT resource_assignment_id,
DECODE(ta_display_flag, 'N', wbs_element_version_id, NULL),
rate_based_flag,
rbs_element_id
FROM pa_resource_assignments
WHERE resource_list_member_id = c_resource_list_member_id
--CBS Change in Derive_Task_Assignments
AND nvl(cbs_element_id,-1) = nvl(c_cbs_element_id, -1) -- Bug 16743324
--End CBS Change in Derive_Task_Assignments
AND wbs_element_version_id = p_task_version_id
AND ta_display_flag IS NOT NULL
AND rownum = 1;
SELECT resource_assignment_id, resource_list_member_id
FROM pa_resource_assignments
WHERE wbs_element_version_id = p_task_version_id
AND ta_display_flag = 'N'
AND rownum = 1;
SELECT resource_assignment_id, resource_list_member_id
FROM pa_resource_assignments
WHERE wbs_element_version_id = p_task_version_id
AND ta_display_flag = 'Y'
AND resource_class_code = 'PEOPLE'
AND rownum = 1;
SELECT bv.budget_version_id
FROM pa_budget_versions bv,
pa_proj_element_versions ev,
pa_proj_elem_ver_structure evs
WHERE bv.project_id = p_project_id
AND bv.wp_version_flag = 'Y'
AND bv.project_structure_version_id = evs.element_version_id
AND ev.project_id = p_project_id
AND ev.element_version_id = p_task_version_id
AND evs.project_id = ev.project_id
AND ev.parent_structure_version_id = evs.element_version_id;
SELECT ev.parent_structure_version_id
FROM pa_proj_element_versions ev
WHERE ev.project_id = p_project_id
AND ev.element_version_id = p_task_version_id;
SELECT txn_currency_code
FROM pa_budget_lines
where resource_assignment_id = c_resource_assignment_id
and txn_currency_code is not null
and rownum = 1;
SELECT project_currency_code
FROM pa_projects_all
where project_id = p_project_id;
SELECT uncategorized_flag
from pa_resource_lists
where resource_list_id = c_resource_list_id;
UPDATE pa_resource_assignments
SET ta_display_flag = 'N'
WHERE resource_assignment_id = l_resource_assignment_id;
SELECT budget_version_id
FROM pa_budget_versions
WHERE project_structure_version_id = structure_version_id
AND wp_version_flag = 'Y';
SELECT
pev.element_version_id,
ra_old.resource_list_member_id,
0,
ra_old.planning_start_date,
ra_old.planning_end_date,
pevs.scheduled_start_date,
pevs.scheduled_finish_date,
0,
'Y',
ra_old.ta_display_flag,
ra_old.cbs_element_id -- Added for 16200605
FROM
pa_resource_assignments ra_old,
pa_proj_element_versions pev,
pa_proj_elem_ver_schedule pevs
WHERE
ra_old.budget_version_id = old_budget_version_id AND
PA_PROGRESS_UTILS.Check_Prog_Exists_And_Delete
(
ra_old.project_id,
ra_old.task_id,
'PA_ASSIGNMENTS',
ra_old.resource_list_member_id,
'WORKPLAN',
'N'
) = 'Y' AND
pev.parent_structure_version_id = new_structure_version_id AND
pev.proj_element_id = ra_old.task_id AND
pevs.element_version_id = pev.element_version_id AND
NOT EXISTS
(
SELECT
ra_new.resource_assignment_id
FROM
pa_resource_assignments ra_new
WHERE
ra_new.resource_list_member_id = ra_old.resource_list_member_id AND
NVL(ra_new.cbs_element_id,-1) = NVL(ra_old.cbs_element_id,-1) AND -- Added for 16200605
ra_new.task_id = ra_old.task_id AND
ra_new.project_id = ra_old.project_id AND
ra_new.budget_version_id = new_budget_version_id
);
UPDATE pa_resource_assignments
SET planning_start_date = l_planning_start_date_tbl(i),
planning_end_date = l_planning_end_date_tbl(i),
ta_display_flag = l_ta_display_flag_tbl(i)
WHERE wbs_element_version_id = l_element_version_id_tbl(i)
AND resource_list_member_id = l_resource_list_member_id_tbl(i);
SELECT start_date,
end_date,
period_name
FROM gl_periods
WHERE period_set_name = p_period_set_name
AND period_type =
decode(p_time_phase_code,'G',p_accounted_period_type,
'P',p_pa_period_type)
AND start_date = p_period_start_date
AND end_date = p_period_end_date
AND adjustment_period_flag = 'N';
SELECT start_date,
end_date,
period_name
FROM gl_periods
WHERE period_set_name = p_period_set_name
AND period_type =
decode(p_time_phase_code,'G',p_accounted_period_type,
'P',p_pa_period_type)
AND period_name = p_period_name
AND adjustment_period_flag = 'N';