APPS.GHR_PAY_CALC SQL Statements

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

Line: 36

select range_or_match
from   pay_user_tables
where  user_table_id = l_user_table_id;

Line: 291

  SELECT 1
  FROM   hr_all_positions_f pos
  WHERE  p_pay_calc_data.position_id = pos.position_id
  AND    p_pay_calc_data.effective_date BETWEEN pos.effective_start_date
                                        and     pos.effective_end_date;

Line: 494

  SELECT lpa.adjustment_percentage
  FROM   ghr_locality_pay_areas_f lpa
        ,ghr_duty_stations_f      dst
  WHERE  dst.duty_station_id = p_duty_station_id
  AND    NVL(p_effective_date,TRUNC(sysdate))  between dst.effective_start_date and dst.effective_end_date
  AND    dst.locality_pay_area_id = lpa.locality_pay_area_id
  AND    NVL(p_effective_date,TRUNC(sysdate))  between lpa.effective_start_date and lpa.effective_end_date;

Line: 521

  SELECT NVL(lpa.leo_adjustment_percentage, lpa.adjustment_percentage) adj_percentage
  FROM   ghr_locality_pay_areas_f lpa
        ,ghr_duty_stations_f      dst
  WHERE  dst.duty_station_id = p_duty_station_id
  AND    NVL(p_effective_date,TRUNC(sysdate))  between dst.effective_start_date and dst.effective_end_date
  AND    dst.locality_pay_area_id = lpa.locality_pay_area_id
  AND    NVL(p_effective_date,TRUNC(sysdate))  between lpa.effective_start_date and lpa.effective_end_date;

Line: 530

  SELECT lpa.adjustment_percentage adj_percentage
  FROM   ghr_locality_pay_areas_f lpa
        ,ghr_duty_stations_f      dst
  WHERE  dst.duty_station_id = p_duty_station_id
  AND    NVL(p_effective_date,TRUNC(sysdate))  between dst.effective_start_date and dst.effective_end_date
  AND    dst.locality_pay_area_id = lpa.locality_pay_area_id
  AND    NVL(p_effective_date,TRUNC(sysdate))  between lpa.effective_start_date and lpa.effective_end_date;

Line: 540

  SELECT leo_pay_area_code
  FROM   ghr_duty_stations_f
  WHERE  duty_station_id = p_duty_station_id
  AND    NVL(p_effective_date,TRUNC(sysdate))
         between effective_start_date and effective_end_date;

Line: 577

  SELECT uta.user_table_name
  FROM   pay_user_tables uta
  WHERE  uta.user_table_id = p_user_table_id;

Line: 602

SELECT pei_information3 grade,
       pei_information4 step,
       pei_information5 pay_plan,
	   pei_information9 temp_step
FROM per_people_extra_info
where person_id = c_person_id
and   information_type ='GHR_US_RETAINED_GRADE'
and   pei_information_category = 'GHR_US_RETAINED_GRADE'
and   c_effective_date  BETWEEN NVL(fnd_date.canonical_to_date(pei_information1),c_effective_date)
                          AND   NVL(fnd_date.canonical_to_date(pei_information2),c_effective_date);

Line: 614

SELECT pa_notification_id, to_step_or_rate
FROM ghr_pa_requests
WHERE pa_request_id = c_pa_request_id;

Line: 749

  SELECT cin.value basic_pay
        ,cin.effective_start_date
        ,cin.effective_end_date
  FROM   pay_user_column_instances_f cin
        ,pay_user_rows_f             urw
        ,pay_user_columns            col
  WHERE col.user_table_id = p_user_table_id
  AND   col.user_column_name = p_step_or_rate
  AND   urw.user_table_id = p_user_table_id
  -- Bug# 5132113 getting the value of GS when pay plan is GP
  AND   urw.row_low_range_or_name = decode(p_pay_plan,'GP','GS',p_pay_plan)||'-'||p_grade_or_level
  AND   NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date
  AND   cin.user_row_id = urw.user_row_id
  AND   cin.user_column_id = col.user_column_id
  AND   NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN cin.effective_start_date AND cin.effective_end_date;

Line: 822

  SELECT cin.value basic_pay
  FROM   pay_user_column_instances_f cin
        ,pay_user_rows_f             urw
        ,pay_user_columns            col
        ,pay_user_tables             utb
  WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name
  AND   col.user_table_id = utb.user_table_id
  AND   col.user_column_name = p_step_or_rate
  AND   urw.user_table_id = utb.user_table_id
  AND   urw.row_low_range_or_name = p_pay_plan||'-'||p_grade_or_level
  AND   NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date
  AND   cin.user_row_id = urw.user_row_id
  AND   cin.user_column_id = col.user_column_id
  AND   NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN cin.effective_start_date AND cin.effective_end_date;

Line: 932

  SELECT utb.user_table_id
  FROM   pay_user_tables  utb
  WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;

Line: 1027

  SELECT utb.user_table_id
  FROM   pay_user_tables  utb
  WHERE utb.user_table_name = p_user_table_name;

Line: 1033

  select 1 from pay_user_tables
  where substr(user_table_name,1,4) in ('999B','999C','999D','999E','999F')
  and user_table_id = l_user_table_id;

Line: 1040

  select 1 from pay_user_tables
  where substr(user_table_name,1,4) = 'ESSL'
  and user_table_id = l_user_table_id;

Line: 1565

  SELECT ppi.ppi_percentage
  FROM   ghr_premium_pay_indicators ppi
  WHERE  code = p_ppi_code;

Line: 1746

select 1
from  per_person_types pet1,
      per_people_f     per1
where pet1.person_type_id = per1.person_type_id
and   per1.person_id      = p_person_id
and   nvl(p_effective_date,trunc(sysdate))
      between per1.effective_start_date and per1.effective_end_date
and   pet1.system_person_type = 'EX_EMP';

Line: 1761

   select pa_notification_id
   from ghr_pa_requests
   where pa_request_id = l_ghr_pa_request_rec.altered_pa_request_id;

Line: 1787

   SELECT from_pay_basis
   FROM ghr_pa_requests
   WHERE pa_request_id = c_pa_request_id;

Line: 1792

   SELECT altered_pa_request_id
   FROM ghr_pa_requests
   WHERE pa_request_id = c_pa_request_id;

Line: 1797

   SELECT pa_notification_id
   FROM ghr_pa_requests
   WHERE pa_request_id = c_alt_pa_request_id;

Line: 1804

SELECT assignment_id
FROM   per_all_assignments_f
WHERE  person_id = c_person_id
AND    assignment_type = 'E'
AND    c_effective_date between effective_start_date and effective_end_date;

Line: 1813

    select 1
    from   ghr_pay_plans
    where  equivalent_pay_plan = 'ES'
    and    pay_plan            = l_pay_plan;

Line: 1829

    SELECT grd.grade_id  grade_id
    FROM per_grades grd,
         per_grade_definitions gdf
     WHERE  gdf.segment1 = v_pay_plan
    AND gdf.segment2 = v_grade_or_level
    AND grd.grade_definition_id = gdf.grade_definition_id
    AND grd.business_group_id = l_business_group_id;

Line: 3109

  SELECT utb.user_table_id
  FROM   pay_user_tables  utb
  WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;

Line: 3245

  SELECT max(urw.ROW_HIGH_RANGE) ROW_HIGH_RANGE
        ,min(urw.ROW_LOW_RANGE_OR_NAME) ROW_LOW_RANGE_OR_NAME
  FROM   pay_user_column_instances_f cin
        ,pay_user_rows_f             urw
        ,pay_user_columns            col
  WHERE col.user_table_id = p_user_table_id
  AND   col.user_column_name = p_pay_plan||'-'||p_grade_or_level
  AND   urw.user_table_id = p_user_table_id
  AND   cin.user_row_id = urw.user_row_id
  AND   cin.user_column_id = col.user_column_id
  AND   NVL(p_effective_date,TRUNC(SYSDATE))
        BETWEEN urw.effective_start_date AND urw.effective_end_date
  AND   NVL(p_effective_date,TRUNC(SYSDATE))
        BETWEEN cin.effective_start_date AND cin.effective_end_date;

Line: 3303

   SELECT paf.assignment_id, paf.position_id
   FROM per_assignments_f paf
   WHERE paf.person_id = c_person_id
   AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date
   AND paf.primary_flag = 'Y'
   AND paf.assignment_type <> 'B';

Line: 3403

  SELECT utb.user_table_id
  FROM   pay_user_tables  utb
  WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;

Line: 3416

   SELECT paf.assignment_id
   FROM per_assignments_f paf
   WHERE paf.person_id = c_person_id
   AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date
   AND paf.primary_flag = 'Y'
   AND paf.assignment_type <> 'B';

Line: 3580

  SELECT utb.user_table_id
  FROM   pay_user_tables  utb
  WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;

Line: 3593

   SELECT paf.assignment_id
   FROM per_assignments_f paf
   WHERE paf.person_id = c_person_id
   AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date
   AND paf.primary_flag = 'Y'
   AND paf.assignment_type <> 'B';

Line: 3722

   SELECT 1
   FROM   ghr_pay_plans ppl
   WHERE  ppl.pay_plan = p_pay_plan
   AND    ppl.equivalent_pay_plan = 'GS';

Line: 3728

   SELECT 1
   FROM   ghr_pay_plans ppl
   WHERE  ppl.pay_plan = p_pay_plan
   AND    ppl.equivalent_pay_plan = 'FW';

Line: 3820

          SELECT cin.value basic_pay
                ,cin.effective_start_date
                ,cin.effective_end_date
                ,col.user_column_name step
          FROM   pay_user_column_instances_f cin
                ,pay_user_rows_f             urw
                ,pay_user_columns            col
          WHERE col.user_table_id = p_user_table_id
         -- AND   col.user_column_name = p_step_or_rate
          AND   urw.user_table_id = p_user_table_id
           --Bug# 7046241 added decode for pay plan GP
          AND   urw.row_low_range_or_name = decode(p_pay_plan,'GP','GS',p_pay_plan)||'-'||p_grade_or_level
          AND   NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN urw.effective_start_date AND urw.effective_end_date
          AND   cin.user_row_id = urw.user_row_id
          AND   cin.user_column_id = col.user_column_id
          AND   NVL(p_effective_date,TRUNC(SYSDATE)) BETWEEN cin.effective_start_date AND cin.effective_end_date;

Line: 3928

    SELECT utb.user_table_id user_table_id, utb.user_table_name user_table_name
    FROM   pay_user_tables  utb
    WHERE  utb.user_table_name = p_user_table_name;

Line: 3936

    SELECT grd.grade_id  grade_id
    FROM per_grades grd,
         per_grade_definitions gdf
     WHERE  gdf.segment1 = v_pay_plan
    AND gdf.segment2 = v_grade_or_level
    AND grd.grade_definition_id = gdf.grade_definition_id
    AND grd.business_group_id = l_business_group_id;

Line: 4310

	-- GPPA Update46. Added 890 in the NOT IN list.
        IF p_pay_calc_data.noa_code NOT IN ('894','890') then
            p_pay_calc_out_data.open_pay_fields := TRUE;

Line: 4449

		--6814842 modified to update position pay table and pay_table_upd_flag
                l_position_pay_table := l_user_table_name;

Line: 4534

		--6814842 modified to update position pay table and pay_table_upd_flag
                l_position_pay_table := l_default_pay_table;

Line: 5009

SELECT equivalent_pay_plan,maximum_step
		FROM ghr_pay_plans
		WHERE pay_plan = pc_pay_plan;

Line: 5014

  SELECT utb.user_table_id
  FROM   pay_user_tables  utb
  WHERE utb.user_table_name = p_user_table_name;