APPS.PSB_VALIDATE_DATA_EXTRACT_PVT SQL Statements

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

Line: 89

  Select count(*)
    into l_positions
    from psb_positions_i
   where data_extract_id   = p_data_extract_id
     and hr_employee_id is not null;

Line: 99

   Select count(*)
     into l_vacant_positions
     from psb_positions_i pp
    where pp.data_extract_id      = p_data_extract_id
     and hr_employee_id is null;

Line: 108

   Select count(*)
     into l_employee_cnt
     from psb_employees_i
    where data_extract_id = p_data_extract_id;

Line: 116

   Select count(*)
     into l_salary_cnt
     from psb_salary_i
    where data_extract_id = p_data_extract_id;

Line: 124

   Select count(*)
     into l_cost_cnt
     from psb_cost_distributions_i
    where data_extract_id = p_data_extract_id;

Line: 132

   Select count(*)
     into l_attr_cnt
     from psb_attribute_values_i
    where data_extract_id = p_data_extract_id;

Line: 140

   Select count(*)
     into l_emp_assign_cnt
     from psb_employee_assignments_i
    where data_extract_id = p_data_extract_id;

Line: 148

   /* delete from PSB_ERROR_MESSAGES
    where process_id = p_data_extract_id;

Line: 162

      PSB_MESSAGE_S.INSERT_ERROR
      (p_source_process   => 'DATA_EXTRACT_VALIDATION',
       p_process_id       =>  p_data_extract_id,
       p_msg_count        =>  l_msg_count,
       p_msg_data         =>  l_msg_data);

Line: 269

    Select 'x'
      from Psb_employee_assignments_i
     where hr_position_id  = l_position_id
       and attribute_name  = l_attribute_name
       and data_extract_id + 0 = p_data_extract_id;

Line: 280

  SELECT description
  FROM psb_error_messages
  WHERE concurrent_request_id = -4712;

Line: 310

    Select pei.hr_position_id, pp.hr_position_name,
           pei.hr_employee_id, pei.first_name||' '||pei.last_name name,
           pei.assignment_id,
           pei.employee_number,pei.pay_basis,
           pei.salary_type,pei.rate_or_payscale_id,
           pei.grade_id,pei.grade_step,
           pei.sequence_number,pei.element_value,
           pei.proposed_salary
      from psb_employees_i pei,
           psb_positions_i pp
     where pei.data_extract_id = p_data_extract_id
       and pp.data_extract_id  = p_data_extract_id
       and pei.hr_position_id  = pp.hr_position_id
       and pei.hr_employee_id  = pp.hr_employee_id
     order by pei.last_name
  )
  Loop

    --l_position_id   := C_grade_val_rec.hr_position_id;

Line: 353

    ( Select attribute_id,name
      from   psb_attributes_VL
      where  business_group_id = p_business_group_id
      and    required_for_import_flag = 'Y'
    )
    Loop
      --
      l_attribute_name := C_Attr_Rec.name;

Line: 384

  DELETE FROM PSB_ERROR_MESSAGES
  WHERE concurrent_request_id = -4712;