The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select Distinct Resource_list_id
FROM
PA_RESOURCE_LIST_ASSIGNMENTS
Where Project_id = X_project_id
and resource_list_id = NVL(x_resource_list_id,resource_list_id);
Select
Para.RESOURCE_LIST_ASSIGNMENT_ID,
Para.RESOURCE_LIST_ID,
Para.RESOURCE_LIST_MEMBER_ID,
Para.RESOURCE_ID,
Parl.TRACK_AS_LABOR_FLAG,
Par.ROLLUP_QUANTITY_FLAG,
Par.UNIT_OF_MEASURE
from
PA_RESOURCE_ACCUM_DETAILS Para,
PA_RESOURCES Par,
PA_RESOURCE_LIST_MEMBERS Parl
Where Para.Txn_Accum_id = v_Res_accum_txn_accum_id and
Para.Resource_list_id = v_Resource_list_id and
Para.Resource_list_id = Parl.Resource_list_id and
Para.Resource_list_member_id = Parl.Resource_list_member_id and
nvl(parl.migration_code,'-99') <> 'N' and
Para.Resource_id = Par.Resource_Id ;
SELECT DISTINCT
PTA.TXN_ACCUM_ID,
PTA.TASK_ID,
PTA.PA_PERIOD,
PTA.GL_PERIOD,
NVL(PTA.TOT_REVENUE,0) TOT_REVENUE ,
NVL(PTA.TOT_RAW_COST,0) TOT_RAW_COST ,
NVL(PTA.TOT_BURDENED_COST,0) TOT_BURDENED_COST,
NVL(PTA.TOT_QUANTITY,0) TOT_QUANTITY ,
NVL(PTA.TOT_LABOR_HOURS,0) TOT_LABOR_HOURS,
NVL(PTA.TOT_BILLABLE_RAW_COST,0) TOT_BILLABLE_RAW_COST,
NVL(PTA.TOT_BILLABLE_BURDENED_COST,0) TOT_BILLABLE_BURDENED_COST,
NVL(PTA.TOT_BILLABLE_QUANTITY,0) TOT_BILLABLE_QUANTITY,
NVL(PTA.TOT_BILLABLE_LABOR_HOURS,0) TOT_BILLABLE_LABOR_HOURS,
NVL(PTA.TOT_CMT_RAW_COST,0) TOT_CMT_RAW_COST,
NVL(PTA.TOT_CMT_BURDENED_COST,0) TOT_CMT_BURDENED_COST,
NVL(PTA.TOT_CMT_QUANTITY,0) TOT_CMT_QUANTITY,
PAP.PERIOD_YEAR
FROM
PA_TXN_ACCUM PTA,
PA_PERIODS_V PAP
WHERE PTA.Project_Id = x_project_id
AND PTA.PA_PERIOD = PAP.PERIOD_NAME
AND PAP.PA_END_DATE <= x_current_end_date;
Update PA_RESOURCE_LIST_ASSIGNMENTS
SET
RESOURCE_LIST_ACCUMULATED_FLAG = 'Y'
Where
PROJECT_ID = x_project_id
AND RESOURCE_LIST_ID = NVL(x_resource_list_id, RESOURCE_LIST_ID);