APPS.PA_MAINT_PROJECT_COMMITMENTS SQL Statements

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

Line: 22

SELECT Distinct
       Resource_list_id
FROM
  PA_RESOURCE_LIST_ASSIGNMENTS
Where Project_id = X_project_id;

Line: 37

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 = x_Res_accum_txn_accum_id and
        Para.Resource_list_id = x_Res_accum_Res_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: 61

SELECT DISTINCT
  PTA.TXN_ACCUM_ID,
  PTA.TASK_ID,
  PTA.PA_PERIOD,
  PTA.GL_PERIOD,
  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,
  PTA.UNIT_OF_MEASURE,
  PAP.PERIOD_YEAR
FROM
  PA_TXN_ACCUM PTA,
  PA_PERIODS_V PAP
WHERE PTA.Project_Id = x_project_id
AND PTA.CMT_Rollup_flag = 'Y'
AND PTA.PA_PERIOD = PAP.PERIOD_NAME
AND PAP.PA_END_DATE <= x_current_end_date;

Line: 353

      Update PA_TXN_ACCUM   Set
        last_updated_by              = pa_proj_accum_main.x_last_updated_by,
        last_update_date             = SYSDATE,
        request_id                   = pa_proj_accum_main.x_request_id,
        program_application_id       = pa_proj_accum_main.x_program_application_id,
        program_id                   = pa_proj_accum_main.x_program_id,
        program_update_date          = SYSDATE,
        CMT_ROLLUP_FLAG   = 'N' Where
        TXN_ACCUM_ID    = x_txn_accum_rec.Txn_Accum_Id;