APPS.PER_QH_POPULATE SQL Statements

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

Line: 20

  /*select location_code
  from hr_locations
  where location_id=p_location_id;*/

Line: 25

  SELECT lot.location_code
  from hr_locations_all hrl, hr_locations_all_tl lot
  where hrl.location_id = lot.location_id
  and lot.language = userenv('LANG')
  and hrl.location_id=p_location_id;

Line: 52

  select hotl.name
  from hr_all_organization_units ho
  ,    hr_all_organization_units_tl hotl
  where ho.organization_id=p_organization_id
  and hotl.organization_id=ho.organization_id
  and hotl.language=userenv('LANG');

Line: 83

  select name
  from per_jobs_vl
  where job_id=p_job_id;

Line: 114

  select name
  from hr_all_positions_f_tl
  where position_id=p_position_id
    and language = userenv('LANG');

Line: 148

  select ppb.name
  ,      ppb.pay_basis
  from   per_pay_bases ppb
  where  ppb.pay_basis_id=p_pay_basis_id;

Line: 174

  select payroll_name
  from pay_all_payrolls_f
  where payroll_id=p_payroll_id
  and p_effective_date between effective_start_date and effective_end_date;

Line: 200

  select full_name
  from per_all_people_f
  where person_id=p_person_id
  and p_effective_date between effective_start_date and effective_end_date;

Line: 227

  select supervisor_assignment_number
  from per_assignments_v
  where supervisor_assignment_id = p_supervisor_assgn_id
  and business_group_id = p_business_group_id;  */

Line: 233

  select assignment_number
  from per_all_assignments_f
  where  assignment_id = p_supervisor_assgn_id;

Line: 260

  select name
  from per_grades_vl
  where grade_id=p_grade_id;

Line: 286

  select name
  from  ben_pgm_f
  where pgm_id = p_grade_ladder_pgm_id
  and   p_effective_date
        between effective_start_date and effective_end_date;

Line: 327

  select org_information1
  ,      org_information2
  ,      org_information3
  ,      org_information4
  from   hr_organization_information
  where  organization_id=p_business_group_id
  and    org_information_context='Work Day Information';

Line: 336

  select org_information1
  from   hr_organization_information
  where  organization_id=p_business_group_id
  and    org_information_context='DEFAULT_GRE_INFO';

Line: 342

  select location_id
  from hr_all_organization_units
  where organization_id=p_business_group_id;

Line: 451

  select organization_id
  ,      job_id
  ,      time_normal_start
  ,      time_normal_finish
  ,      working_hours
  ,      frequency
  ,      location_id
  ,      probation_period
  ,      probation_period_unit_cd
  ,      pay_basis_id
  ,      pay_freq_payroll_id
  ,      supervisor_id
  ,      entry_grade_id
  ,      bargaining_unit_cd
  from   hr_all_positions_f
  where  position_id=p_position_id
  and    p_effective_date between effective_start_date and effective_end_date;

Line: 470

  select position_id
  from per_vacancies
  where vacancy_id=p_vacancy_id
  and p_effective_date between date_from and nvl(date_to,p_effective_date);

Line: 679

  select org_information1
  ,      org_information2
  ,      org_information3
  ,      org_information4
  from   hr_organization_information
  where  organization_id=p_organization_id
  and    org_information_context='Work Day Information';

Line: 688

  select org_information1
  ,      org_information2
  ,      org_information3
  ,      org_information4
  ,      org_information5
  from   hr_organization_information
  where  organization_id=p_organization_id
  and    org_information_context='DEFAULT_HR_INFO';

Line: 698

  select location_id
  from hr_all_organization_units
  where organization_id=p_organization_id;

Line: 704

  select organization_id
  from per_vacancies
  where vacancy_id=p_vacancy_id
  and p_effective_date between date_from and nvl(date_to,p_effective_date);

Line: 711

  select 1
  from hr_positions_f
  where organization_id=ln_organization_id
  and position_id=ln_position_id
  and p_effective_date between effective_start_date
  and effective_end_date;

Line: 910

  select recruiter_id
  ,      grade_id
  ,      position_id
  ,      job_id
  ,      location_id
  ,      organization_id
  ,      people_group_id
  from   per_vacancies
  where vacancy_id=p_vacancy_id;

Line: 921

  select *
  from pay_people_groups
  where people_group_id=pgp_id;

Line: 927

  select 1
  from hr_positions_f
  where job_id=ln_job_id
  and position_id=ln_position_id
  and p_effective_date between effective_start_date
  and effective_end_date;

Line: 936

  select 1
  from hr_positions_f
  where organization_id=ln_organization_id
  and position_id=ln_position_id
  and p_effective_date between effective_start_date
  and effective_end_date;