APPS.HR_US_OSHA SQL Statements

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

Line: 56

    select null
    from   sys.dual
    where  exists (select null
                   from   per_analysis_criteria pac,
                          fnd_id_flex_structures fif
                   where  pac.id_flex_num = fif.id_flex_num
                   and    fif.id_flex_structure_code = 'OSHA-REPORTABLE_INCIDENT'
                   and    pac.segment1 = v_case_number);

Line: 66

    select max(pac.segment1)+v_case_number
    from   per_analysis_criteria pac,
           fnd_id_flex_structures fif
    where  pac.id_flex_num = fif.id_flex_num
    and    fif.id_flex_structure_code = 'OSHA-REPORTABLE_INCIDENT';

Line: 74

  select per_osha_case_number_s.nextval
  into   v_case_number
  from   sys.dual;