APPS.PAY_RUN_RESULT_PKG SQL Statements

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

Line: 28

    select result_value
      into l_result_value
      from pay_run_result_values
     where run_result_id = p_run_result_id
       and input_value_id = p_input_value_id;

Line: 47

         select legislation_code
           into l_legislation_code
           from per_business_groups
          where business_group_id = p_business_group_id;

Line: 93

   select peev.input_value_id,
          piv.uom,
          peev.screen_entry_value value,
          peev.element_entry_value_id
   from   pay_input_values_f piv,
          pay_element_entry_values_f peev
   where  peev.element_entry_id = p_element_entry_id
   and    piv.input_value_id = peev.input_value_id
   and    p_session_date between peev.effective_start_date
                             and peev.effective_end_date
   and    p_session_date between piv.effective_start_date
                             and piv.effective_end_date;

Line: 133

     select ee.assignment_id,
            et.element_type_id,
            ee.entry_type,
            ee.original_entry_id,
            et.input_currency_code,
            et.output_currency_code,
            pay_run_results_s.nextval,
            hr_dynsql.get_local_unit(ee.assignment_id,
                                     p_session_date),
            et.time_definition_type,
            et.time_definition_id
     into   l_assignment_id,
            l_element_type_id,
            l_entry_type,
            l_original_entry_id,
            l_input_currency_code,
            l_output_currency_code,
            l_run_result_id,
            l_local_unit_id,
            l_time_definition_type,
            l_s_time_definition_id
     from   pay_element_entries_f ee,
            pay_element_types_f et
     where  ee.element_entry_id = p_element_entry_id
       and  et.element_type_id  = ee.element_type_id
       and  p_session_date between ee.effective_start_date
                               and ee.effective_end_date
       and  p_session_date between et.effective_start_date
                               and et.effective_end_date;

Line: 180

     select eev.screen_entry_value,
            eev.element_entry_value_id
       into l_jurisdiction_code,
            l_jurisdiction_eev_id
       from pay_element_entry_values_f eev,
            pay_input_values_f         piv,
            pay_element_entries_f      pee
       where pee.element_entry_id = p_element_entry_id
       and   eev.element_entry_id = pee.element_entry_id
       and   eev.input_value_id   = piv.input_value_id
       and   piv.name             = p_jc_name
       and   p_session_date between pee.effective_start_date
                                and pee.effective_end_date
       and   p_session_date between eev.effective_start_date
                                and eev.effective_end_date
       and   p_session_date between piv.effective_start_date
                                and piv.effective_end_date;

Line: 249

     insert into pay_run_results
     (run_result_id,
      element_type_id,
      assignment_action_id,
      entry_type,
      source_id,
      source_type,
      status,
      jurisdiction_code,
      element_entry_id,
      local_unit_id,
      time_definition_id,
      start_date,
      end_date)
     values
     (l_run_result_id,
      l_element_type_id,
      p_asg_action_id,
      l_entry_type,
      l_rr_source_id,
      'E',
      l_rr_status,
      l_jurisdiction_code,
      p_element_entry_id,
      l_local_unit_id,
      l_time_definition_id,
      l_time_def_start_date,
      l_time_def_end_date);

Line: 354

          insert into pay_run_result_values
          (input_value_id,
           run_result_id,
           result_value,
           formula_result_flag)
          values
          (peev.input_value_id,
           l_run_result_id,
           l_amount,
           'N');

Line: 404

select piv.input_value_id,
       piv.name
  from pay_input_values_f piv
 where piv.element_type_id = p_et_id
   and p_effdate between piv.effective_start_date
                     and piv.effective_end_date;

Line: 424

     select prr.entry_type,
            prr.source_id,
            pay_run_results_s.nextval,
            local_unit_id,
            time_definition_id,
            start_date,
            end_date
       into l_entry_type,
            l_entry_id,
            l_run_result_id,
            l_local_unit_id,
            l_time_definition_id,
            l_start_date,
            l_end_date
       from pay_run_results prr
      where prr.run_result_id = p_run_result_id;

Line: 461

     insert into pay_run_results
     (run_result_id,
      element_type_id,
      assignment_action_id,
      entry_type,
      source_id,
      source_type,
      status,
      jurisdiction_code,
      element_entry_id,
      local_unit_id,
      time_definition_id,
      start_date,
      end_date)
     values
     (l_run_result_id,
      p_element_type_id,
      p_asg_action_id,
      l_entry_type,
      l_entry_id,
      'I',
      l_rr_status,
      null,
      null,
      l_local_unit_id,
      l_time_definition_id,
      l_start_date,
      l_end_date);

Line: 509

        insert into pay_run_result_values
        (input_value_id,
         run_result_id,
         result_value,
         formula_result_flag)
        values
        (ivrec.input_value_id,
         l_run_result_id,
         null,
         'N');

Line: 551

   select name
     into l_iv_name
     from pay_input_values_f
    where input_value_id = p_input_value_id
      and p_session_date between effective_start_date
                             and effective_end_date;

Line: 561

     update pay_run_results
        set jurisdiction_code = p_value
      where run_result_id = p_run_result_id;

Line: 589

      select 1
        into l_dummy
        from pay_run_result_values
       where run_result_id = p_run_result_id
         and input_value_id = p_input_value_id;

Line: 595

      update pay_run_result_values
         set result_value = p_value,
             formula_result_flag = p_formula_result_flag
       where run_result_id = p_run_result_id
         and input_value_id = p_input_value_id;

Line: 604

         insert into pay_run_result_values
         (input_value_id,
          run_result_id,
          result_value,
          formula_result_flag)
        values
         (p_input_value_id,
          p_run_result_id,
          p_value,
          p_formula_result_flag);

Line: 639

     select pay_run_results_s.nextval
       into l_run_result_id
       from dual;

Line: 643

     insert into pay_run_results
     (run_result_id,
      element_type_id,
      assignment_action_id,
      entry_type,
      source_id,
      source_type,
      status,
      jurisdiction_code,
      element_entry_id,
      local_unit_id,
      time_definition_id,
      start_date,
      end_date)
     values
     (l_run_result_id,
      p_element_type_id,
      p_assignment_action_id,
      p_entry_type,
      p_source_id,
      p_source_type,
      p_status,
      null,
      p_element_entry_id,
      null,
      p_time_def_id,
      p_start_date,
      p_end_date);