APPS.PQH_RBC_RATE_RETRIEVAL SQL Statements

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

Line: 75

  Select organization_id, payroll_id
    From per_all_assignments_f
   Where assignment_id = p_asg_id
     and p_effective_date between effective_start_date and effective_end_date;

Line: 414

 Select preferential_rate_cd, preferential_rate_rule
   from pqh_criteria_rate_defn
  Where criteria_rate_defn_id = p_crit_rt_defn_id;

Line: 638

  Select organization_id, payroll_id
    From per_all_assignments_f
   Where assignment_id = p_asg_id
     and p_effective_date between effective_start_date and effective_end_date;

Line: 821

 Select parent_criteria_rate_defn_id
   From pqh_criteria_rate_factors
  Where criteria_rate_defn_id = p_crit_rt_defn_id
    and business_group_id = p_business_group_id;

Line: 827

 Select rate_calc_cd, rate_calc_rule,rounding_cd,rounding_rule,uom,currency_code,reference_period_cd
   from pqh_criteria_rate_defn
  Where criteria_rate_defn_id = p_crit_rt_defn_id
    and business_group_id = p_business_group_id;

Line: 944

                select conversion_rate
                into l_curr_conv
                from gl_daily_rates
                where from_currency = l_t_currency_code
                and to_currency = l_currency_code
                and conversion_date = (select max(conversion_date)
                                       from gl_daily_rates
                                       where from_currency = l_t_currency_code
                                       and to_currency = l_currency_code
                                       and conversion_date <= p_effective_date);

Line: 1129

       pqh_popl_criteria_ovrrd.insert_criteria_override(p_crit_ovrrd_val_rec => l_crit_val_rec);

Line: 1149

  Select *
    from ben_eligy_criteria
   Where (time_entry_access_table_name1 is not null or time_entry_access_table_name2 is not null)
     and business_group_id = p_business_group_id;

Line: 1170

select a.input_value_id, a.screen_entry_value, b.display_sequence
 from pay_element_entry_values_f a, pay_input_values_f b
Where a.element_entry_id = p_element_entry_id
  and a.input_value_id = b.input_value_id
order by display_sequence;

Line: 1177

Select *
  From pay_cost_allocation_keyflex
 Where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;

Line: 1335

         pqh_popl_criteria_ovrrd.insert_criteria_override(p_crit_ovrrd_val_rec => l_crit_val_rec);

Line: 1363

Select *
  From pay_element_entries_f
 Where element_entry_id = p_element_entry_id
   and p_effective_date between effective_start_date and effective_end_date;

Line: 1369

Select criteria_rate_defn_id
  from pqh_criteria_rate_elements
 Where element_type_id = p_element_type_id;

Line: 1374

 Select *
   From per_all_people_f
  Where person_id = p_per_id
    and p_effective_date between effective_start_date and effective_end_date;

Line: 1380

select *
  from per_all_assignments_f
 Where assignment_id = p_assignment_id
   and p_effective_date between effective_start_date and effective_end_date;

Line: 1499

Select criteria_rate_defn_id
  from pqh_criteria_rate_elements
 Where element_type_id = p_element_type_id;

Line: 1504

 Select *
   From per_all_people_f
  Where person_id = p_per_id
    and p_effective_date between effective_start_date and effective_end_date;

Line: 1510

select *
  from per_all_assignments_f
 Where person_id = p_person_id
   and primary_flag = 'Y'
   and p_effective_date between effective_start_date and effective_end_date;

Line: 1517

select *
  from per_all_assignments_f
 Where assignment_id = p_assignment_id
   and p_effective_date between effective_start_date and effective_end_date;

Line: 1685

Select criteria_rate_defn_id
  from pqh_criteria_rate_elements
 Where element_type_id = p_element_type_id;