APPS.PA_REFRESH_RES_LISTS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

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);

Line: 38

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 ;

Line: 60

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;

Line: 457

     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);