APPS.PQH_FR_SYNC_SAL_RATES SQL Statements

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

Line: 56

  SELECT  increased_index
  FROM    pqh_fr_global_indices_f
  WHERE   p_effective_date BETWEEN effective_start_date AND effective_end_date
  AND     gross_index = p_ib;

Line: 213

  SELECT gross_index,increased_index
  FROM   pqh_fr_global_indices_f
  WHERE  p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 244

    SELECT pps.parent_spine_id,pps.name,psp.spinal_point_id
    FROM   per_spinal_points psp,
           per_parent_spines pps
    WHERE  psp.information_category = 'FR_PQH'
    AND    psp.information1 = p_ib
    AND    psp.parent_spine_id = pps.parent_spine_id;

Line: 251

/* Update rates that have the name same as the Pay scale name */
 CURSOR csr_hrrate_for_point(p_point_id IN NUMBER, p_scale_name varchar2) IS
    SELECT pgr.grade_rule_id,pgr.currency_code,pgr.value,pgr.object_version_number
    FROM   pay_grade_rules_f pgr,
           pay_rates pr
    WHERE  pgr.rate_type = 'SP'
    AND    pgr.grade_or_spinal_point_id = p_point_id
    AND    p_effective_date BETWEEN pgr.effective_start_date AND pgr.effective_end_date
    AND    pgr.rate_id =pr.rate_id
    AND    pr.name = p_scale_name;

Line: 295

       l_dt_upd_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'PAY_GRADE_RULES_F'
                                                            ,p_key_column_name => 'GRADE_RULE_ID'
                                                            ,p_key_column_value => l_rate_rec.grade_rule_id
                                                            ,p_effective_date => p_effective_date);

Line: 299

       hr_rate_values_api.update_rate_value
       (p_effective_date           => p_effective_date
       ,p_value                    => nvl(l_new_value,0)
       ,p_grade_rule_id            => l_rate_rec.grade_rule_id
       ,p_datetrack_mode           => l_dt_upd_mode
       ,p_object_version_number    => l_rate_rec.object_version_number
       ,p_effective_start_date     => l_effective_start_date
       ,p_effective_end_date       => l_effective_end_date);

Line: 331

     SELECT basic_salary_rate,currency_code
     FROM   pqh_fr_global_indices_f
     WHERE  p_effective_date BETWEEN effective_start_date AND effective_end_date
     AND    type_of_record = 'INM';

Line: 356

  SELECT  cer.copy_entity_result_id,cer.copy_entity_txn_id
  FROM    ben_copy_entity_results cer,
          pqh_copy_entity_txns cet
  WHERE   cer.table_alias = 'OPT'
  AND     cer.dml_operation = 'INSERT'
  AND     NVL(cer.information101,'XXX') = 'FR_PQH'
  AND     NVL(cer.information173,-9999) = p_ib
  AND     cer.copy_entity_txn_id = cet.copy_entity_txn_id
  AND     cet.status <> 'COMPLETED'
  ORDER BY cer.copy_entity_txn_id;

Line: 368

      SELECT information50
      FROM   ben_copy_entity_results
      WHERE  copy_entity_txn_id = p_cet_id
      AND    table_alias = 'PGM';

Line: 375

  SELECT  copy_entity_result_id,information297
  FROM    ben_copy_entity_results
  WHERE   copy_entity_txn_id = p_cet_id
  AND     table_alias = 'HRRATE'
  AND     dml_operation  = 'INSERT'
  AND     information278 = p_sp_cer_id
  AND     information1 IS NULL;

Line: 417

          UPDATE  ben_copy_entity_results
          SET     information297 = NVL(l_new_value,0)
          WHERE   copy_entity_result_id = l_hrrate_rec.copy_entity_result_id;