APPS.PER_FR_WORK_ACC_UPG_PKG SQL Statements

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

Line: 6

   SELECT pei.PERSON_ID,
          per1.full_name,
          per1.employee_number,
          per1.effective_start_date,
          pei.PEI_INFORMATION1,
          pei.PEI_INFORMATION2,
          pei.PEI_INFORMATION3,
          pei.PEI_INFORMATION4,
          pei.PEI_INFORMATION5,
          pei.PEI_INFORMATION6,
          pei.PEI_INFORMATION7,
          pei.PEI_INFORMATION8,
          pei.PEI_INFORMATION9,
          pei.PERSON_EXTRA_INFO_ID
   FROM   per_people_extra_info pei
      ,   per_all_people_f per1
   WHERE  pei.PEI_INFORMATION_CATEGORY = 'FR_WORK_ACCI'
    AND    pei.person_id = per1.person_id
    AND    per1.business_group_id = p_business_group_id
    AND    per1.effective_start_date = (select min(per2.effective_start_date)
                                         from per_all_people_f per2
                                        where per2.person_id = per1.person_id
                                          and per2.business_group_id = p_business_group_id)
    AND   pei.PEI_INFORMATION30 IS NULL
    order by per1.full_name;

Line: 143

	BEGIN -- Insert newwork inccidents section

          SAVEPOINT start_insert;

Line: 163

             update per_people_extra_info
                set PEI_INFORMATION30 = to_char(l_incident_id)
              where person_id = l_work_acci.person_id
                and PEI_INFORMATION_CATEGORY = 'FR_WORK_ACCI'
                and PERSON_EXTRA_INFO_ID = l_work_Acci.PERSON_EXTRA_INFO_ID;

Line: 170

             rollback to start_insert;

Line: 177

          END;  -- end of section inserting new work inccident