The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT Project_Accum_Id
FROM
PA_PROJECT_ACCUM_HEADERS
WHERE Project_id = X_project_id
AND Task_Id = 0
AND Resource_list_Member_id = X_resource_list_member_id;
Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
CMT_RAW_COST_YTD = CMT_RAW_COST_YTD + X_Raw_Cost,
CMT_RAW_COST_PTD = CMT_RAW_COST_PTD + X_Raw_Cost,
CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
CMT_BURDENED_COST_PTD = CMT_BURDENED_COST_PTD + X_Burdened_Cost,
CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
CMT_QUANTITY_YTD = CMT_QUANTITY_YTD + V_Qty,
CMT_QUANTITY_PTD = CMT_QUANTITY_PTD + V_Qty,
LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
LAST_UPDATE_DATE = Trunc(Sysdate),
LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
Where PAA.Project_Accum_id In
(Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
Where Pah.Project_id = x_project_id and
pah.Resource_list_member_id = x_resource_list_Member_id and
Pah.Task_id in ( select 0 from sys.dual union
Select Pt.Task_Id from PA_TASKS pt
start with pt.task_id = x_task_id
connect by prior pt.parent_task_id = pt.task_id));
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval
into V_Accum_id
From Dual;
PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
(X_project_id,
v_task_array(i),
x_resource_list_id ,
x_resource_list_Member_id ,
x_resource_id ,
x_resource_list_assignment_id ,
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_COMMITMENTS (
PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
CMT_QUANTITY_PTD,
CMT_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,X_Raw_Cost,
X_Burdened_Cost,X_Burdened_Cost,
0,X_Burdened_Cost,
V_Qty,V_Qty,0,V_Qty,
X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
(X_project_id,
0,
x_resource_list_id ,
x_resource_list_Member_id ,
x_resource_id ,
x_resource_list_assignment_id ,
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_COMMITMENTS (
PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
CMT_QUANTITY_PTD,
CMT_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,X_Raw_Cost,
X_Burdened_Cost,X_Burdened_Cost,
0,X_Burdened_Cost,
V_Qty,V_Qty,0,V_Qty,
X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
SELECT Project_Accum_Id
FROM
PA_PROJECT_ACCUM_HEADERS
WHERE Project_id = X_project_id
AND Task_Id = 0
AND Resource_list_Member_id = X_resource_list_member_id;
Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
CMT_RAW_COST_YTD = CMT_RAW_COST_YTD + X_Raw_Cost,
CMT_RAW_COST_PP = CMT_RAW_COST_PP + X_Raw_Cost,
CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PP + X_Burdened_Cost,
CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
CMT_QUANTITY_YTD = CMT_QUANTITY_YTD + V_Qty,
CMT_QUANTITY_PP = CMT_QUANTITY_PP + V_Qty,
LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
LAST_UPDATE_DATE = Trunc(Sysdate),
LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
Where PAA.Project_Accum_id In
(Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
Where Pah.Project_id = x_project_id and
pah.Resource_list_member_id = x_resource_list_Member_id and
Pah.Task_id in (select 0 from sys.dual union
Select Pt.Task_Id from PA_TASKS pt
start with pt.task_id = x_task_id
connect by prior pt.parent_task_id = pt.task_id));
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
(X_project_id,
v_task_array(i),
x_resource_list_id ,
x_resource_list_Member_id ,
x_resource_id ,
x_resource_list_assignment_id ,
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_COMMITMENTS (
PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
CMT_QUANTITY_PTD,
CMT_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,X_Raw_Cost,X_Raw_Cost,X_Raw_Cost,0,
X_Burdened_Cost,X_Burdened_Cost,
X_Burdened_Cost,0,
V_Qty,V_Qty,V_Qty,0,
X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
(X_project_id,
0,
x_resource_list_id ,
x_resource_list_Member_id ,
x_resource_id ,
x_resource_list_assignment_id ,
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_COMMITMENTS (
PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
CMT_QUANTITY_PTD,
CMT_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,X_Raw_Cost,X_Raw_Cost,X_Raw_Cost,0,
X_Burdened_Cost,X_Burdened_Cost,
X_Burdened_Cost,0,
V_Qty,V_Qty,V_Qty,0,
X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
SELECT Project_Accum_Id
FROM
PA_PROJECT_ACCUM_HEADERS
WHERE Project_id = X_project_id
AND Task_Id = 0
AND Resource_list_Member_id = X_resource_list_member_id;
Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
CMT_RAW_COST_PP = CMT_RAW_COST_PP + X_Raw_Cost,
CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PP + X_Burdened_Cost,
CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
CMT_QUANTITY_PP = CMT_QUANTITY_PP + V_Qty,
LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
LAST_UPDATE_DATE = Trunc(Sysdate),
LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
Where PAA.Project_Accum_id In
(Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
Where Pah.Project_id = x_project_id and
pah.Resource_list_member_id = x_resource_list_Member_id and
Pah.Task_id in (select 0 from sys.dual union
Select Pt.Task_Id from PA_TASKS pt
start with pt.task_id = x_task_id
connect by prior pt.parent_task_id = pt.task_id));
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
(X_project_id,
v_task_array(i),
x_resource_list_id ,
x_resource_list_Member_id ,
x_resource_id ,
x_resource_list_assignment_id ,
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_COMMITMENTS (
PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
CMT_QUANTITY_PTD,
CMT_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,X_Raw_Cost,0,X_Raw_Cost,0,
X_Burdened_Cost,0,
X_Burdened_Cost,0,
V_Qty,0,V_Qty,0,
X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
(X_project_id,
0,
x_resource_list_id ,
x_resource_list_Member_id ,
x_resource_id ,
x_resource_list_assignment_id ,
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_COMMITMENTS (
PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
CMT_QUANTITY_PTD,
CMT_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,X_Raw_Cost,0,X_Raw_Cost,0,
X_Burdened_Cost,0,
X_Burdened_Cost,0,
V_Qty,0,V_Qty,0,
X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
SELECT Project_Accum_Id
FROM
PA_PROJECT_ACCUM_HEADERS
WHERE Project_id = X_project_id
AND Task_Id = 0
AND Resource_list_Member_id = X_resource_list_member_id;
Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
CMT_RAW_COST_YTD = CMT_RAW_COST_YTD + X_Raw_Cost,
CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
CMT_BURDENED_COST_YTD = CMT_BURDENED_COST_YTD + X_Burdened_Cost,
CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
CMT_QUANTITY_YTD = CMT_QUANTITY_YTD + V_Qty,
LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
LAST_UPDATE_DATE = Trunc(Sysdate),
LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
Where PAA.Project_Accum_id In
(Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
Where Pah.Project_id = x_project_id and
pah.Resource_list_member_id = x_resource_list_Member_id and
Pah.Task_id in (select 0 from sys.dual union
Select Pt.Task_Id from PA_TASKS pt
start with pt.task_id = x_task_id
connect by prior pt.parent_task_id = pt.task_id));
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
(X_project_id,
v_task_array(i),
x_resource_list_id ,
x_resource_list_Member_id ,
x_resource_id ,
x_resource_list_assignment_id ,
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_COMMITMENTS (
PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
CMT_QUANTITY_PTD,
CMT_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,0,
X_Burdened_Cost,X_Burdened_Cost,
0,0,
V_Qty,V_Qty,0,0,
X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
(X_project_id,
0,
x_resource_list_id ,
x_resource_list_Member_id ,
x_resource_id ,
x_resource_list_assignment_id ,
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_COMMITMENTS (
PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
CMT_QUANTITY_PTD,
CMT_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,X_Raw_Cost,X_Raw_Cost,0,0,
X_Burdened_Cost,X_Burdened_Cost,
0,0,
V_Qty,V_Qty,0,0,
X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
SELECT Project_Accum_Id
FROM
PA_PROJECT_ACCUM_HEADERS
WHERE Project_id = X_project_id
AND Task_Id = 0
AND Resource_list_Member_id = X_resource_list_member_id;
Update PA_PROJECT_ACCUM_COMMITMENTS PAA SET
CMT_RAW_COST_ITD = CMT_RAW_COST_ITD + X_Raw_Cost,
CMT_BURDENED_COST_ITD = CMT_BURDENED_COST_ITD + X_Burdened_Cost,
CMT_QUANTITY_ITD = CMT_QUANTITY_ITD + V_Qty,
LAST_UPDATE_DATE = Trunc(Sysdate),
LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
Where PAA.Project_Accum_id In
(Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
Where Pah.Project_id = x_project_id and
pah.Resource_list_member_id = x_resource_list_Member_id and
Pah.Task_id in (select 0 from sys.dual union
Select Pt.Task_Id from PA_TASKS pt
start with pt.task_id = x_task_id
connect by prior pt.parent_task_id = pt.task_id));
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
(X_project_id,
v_task_array(i),
x_resource_list_id ,
x_resource_list_Member_id ,
x_resource_id ,
x_resource_list_assignment_id ,
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_COMMITMENTS (
PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
CMT_QUANTITY_PTD,
CMT_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,X_Raw_Cost,0,0,0,
X_Burdened_Cost,0,0,0,
V_Qty,0,0,0,
X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
From Dual;
PA_PROCESS_ACCUM_ACTUALS_RES.Insert_Headers_res
(X_project_id,
0,
x_resource_list_id ,
x_resource_list_Member_id ,
x_resource_id ,
x_resource_list_assignment_id ,
x_current_period,
v_accum_id,
x_err_stack,
x_err_stage,
x_err_code);
Insert into PA_PROJECT_ACCUM_COMMITMENTS (
PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
CMT_RAW_COST_PTD,
CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,
CMT_QUANTITY_PTD,
CMT_UNIT_OF_MEASURE,
REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
LAST_UPDATE_LOGIN) Values
(V_Accum_id,X_Raw_Cost,0,0,0,
X_Burdened_Cost,0,0,0,
V_Qty,0,0,0,
X_Unit_Of_Measure,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
SELECT task_id
FROM pa_tasks pt
WHERE project_id = x_project_id
AND NOT EXISTS
(SELECT 'x'
FROM
pa_project_accum_headers pah
WHERE pah.project_id = x_project_id
AND pah.task_id = pt.task_id
AND pah.resource_list_member_id = x_resource_list_member_id)
START WITH task_id = x_task_id
CONNECT BY PRIOR parent_task_id = task_id;