APPS.HRI_OPL_ACTLS SQL Statements

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

Line: 158

     SELECT assignment_action_id
             BULK COLLECT INTO l_assignment_actions
        FROM pay_assignment_actions paa,
             pay_payroll_actions    ppa
       WHERE paa.payroll_action_id = ppa.payroll_action_id
         AND ppa.action_type IN ('C', 'S')
         AND ppa.effective_date BETWEEN g_refresh_start_date AND g_refresh_end_date
         AND paa.assignment_id  BETWEEN p_start_object_id and p_end_object_id;

Line: 172

   INSERT INTO HRI_MB_ACTLS_CT (
     hri_mb_actls_ct_id
    ,effective_date
    ,date_earned
    ,assignment_id
    ,organization_id
    ,job_id
    ,position_id
    ,grade_id
    ,element_type_id
    ,input_value_id
    ,cost_allocation_keyflex_id
    -- ,debit_or_credit
    ,actual_value
    ,currency_code
    --
    -- WHO Columns
    --
    ,last_update_date
    ,last_update_login
    ,last_updated_by
    ,created_by
    ,creation_date)
   SELECT
       hri_mb_actls_ct_s.nextval
      ,ppa2.effective_date
      ,ppa2.date_earned
      ,paaf.assignment_id
      ,paaf.organization_id
      ,paaf.job_id
      ,paaf.position_id
      ,paaf.grade_id
      ,pivf.element_type_id
      ,pc.input_value_id
      ,pc.cost_allocation_keyflex_id
       -- ,pc.debit_or_credit
      ,pc.costed_value
      ,petf.output_currency_code
      ,l_current_time
      ,l_user_id
      ,l_user_id
      ,l_user_id
      ,l_current_time
     FROM  per_all_assignments_f paaf,
           pay_assignment_actions paa2,
           pay_payroll_actions ppa2,
           pay_run_results     ppr,
           pay_costs pc,
           pay_input_values_f pivf,
           pay_element_types_f petf
    WHERE paaf.assignment_id        = paa2.assignment_id
      AND paa2.payroll_action_id    = ppa2.payroll_action_id
      AND paa2.assignment_action_id = ppr.assignment_action_id
      AND ppr.run_result_id         = pc.run_result_id
      --AND nvl(pc.distributed_input_value_id, pc.input_value_id) = pivf.input_value_id
      AND pc.input_value_id         = pivf.input_value_id
      AND pivf.element_type_id      = petf.element_type_id
      AND ppr.element_type_id       = petf.element_type_id
      AND pc.balance_or_cost        = 'C'
      AND pc.assignment_action_id   = l_assignment_actions(i)
      AND ppa2.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
      AND ppa2.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
      AND ppa2.effective_date BETWEEN petf.effective_start_date AND petf.effective_end_date
      AND ppa2.effective_date BETWEEN g_refresh_start_date AND g_refresh_end_date;

Line: 237

  dbg(SQL%ROWCOUNT||' records inserted into HRI_MB_ACTLS_CT');

Line: 309

          'SELECT  /*+ PARALLEL(asgn, DEFAULT, DEFAULT) */
                   DISTINCT
                   asgn.assignment_id object_id
          FROM     per_all_assignments_f   asgn
          WHERE    asgn.assignment_type in (''E'',''C'')
          AND      asgn.effective_end_date >= to_date(''' ||
                       to_char(g_refresh_start_date, 'DD-MM-YYYY') ||
                       ''',''DD-MM-YYYY'') - 1
          ORDER BY asgn.assignment_id';

Line: 426

      dbg('Full Refresh selected - Creating indexes');

Line: 437

        dbg('Full Refresh selected - gathering stats');

Line: 478

  SELECT mthd_range_id,
         min(object_id) start_object_id,
         max(object_id) end_object_id
  FROM   (SELECT  hri_opl_multi_thread.get_next_mthd_range_id(rownum,200) mthd_range_id
                  ,object_id
          FROM    (SELECT DISTINCT asgn.assignment_id object_id
                     FROM per_all_assignments_f   asgn
                    WHERE asgn.assignment_type in ('E','C')
                      AND asgn.effective_end_date >= g_refresh_start_date - 1
                    ORDER BY asgn.assignment_id)
          )
  GROUP BY mthd_range_id;