APPS.GHR_UPD_HR_VALIDATION SQL Statements

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

Line: 147

      SELECT distinct
             UPPER(pdf.record_structure_name)     record_structure_name
            ,UPPER(pdf.record_structure_col_name) record_structure_col_name
            ,pdf.name                             prompt
            ,pdf.form_block_name
            ,pdf.form_field_name
      FROM   ghr_pa_data_fields       pdf
            ,ghr_noa_fam_proc_methods fpm
            ,ghr_families             fam
            ,ghr_noa_families         naf
      WHERE (naf.nature_of_action_id = p_first_noa_id
          OR naf.nature_of_action_id = p_second_noa_id)
      AND    fam.noa_family_code = naf.noa_family_code
      AND    fam.required_flag = 'Y'
      AND    fam.noa_family_code = fpm.noa_family_code
      AND    fpm.required_flag = 'Y'
      AND    fpm.pa_data_field_id = pdf.pa_data_field_id
      -- Bug#3941541 Added the date condition to get the family.
      AND    p_pa_requests_type.effective_date BETWEEN NVL(naf.start_date_active,p_pa_requests_type.effective_date)
                                                   and NVL(naf.end_date_active,p_pa_requests_type.effective_date);

Line: 169

      select ppf.effective_start_date effective_start_date
      from   per_people_f      ppf,
             per_person_types  ppt
      where ppf.person_id          = p_pa_requests_type.person_id
      and   ppf.person_type_id     = ppt.person_type_id
      and   ppt.SYSTEM_PERSON_TYPE = 'EX_EMP'
      and   ppf.effective_start_date > p_pa_requests_type.effective_date;

Line: 300

  PROCEDURE check_insertion_values(p_pa_requests_type IN ghr_pa_requests%ROWTYPE) IS
  --
  l_proc varchar2(72) := g_package||'check_insertion_values';

Line: 315

        hr_utility.set_message(8301,'GHR_38238_1ST_NOA_INSERT_REQD');

Line: 322

        hr_utility.set_message(8301,'GHR_38239_1ST_LA1_INSERT_REQD');

Line: 329

        hr_utility.set_message(8301,'GHR_38240_1ST_LA2_INSERT_REQD');

Line: 336

        hr_utility.set_message(8301,'GHR_38241_2ND_NOA_INSERT_REQD');

Line: 343

        hr_utility.set_message(8301,'GHR_38242_2ND_LA1_INSERT_REQD');

Line: 350

        hr_utility.set_message(8301,'GHR_38243_2ND_LA2_INSERT_REQD');

Line: 357

  END check_insertion_values;

Line: 711

    check_insertion_values(p_pa_requests_type);

Line: 720

  select fnd_date.canonical_to_date(rei_information11)  rei_information11
  from ghr_pa_request_extra_info
  where pa_request_id = p_pa_request_id
  and information_type = 'GHR_US_PAR_AWARDS_BONUS';

Line: 742

 select effective_date, person_id, to_position_id
 from ghr_pa_requests
 where pa_request_id = p_pa_request_id;

Line: 748

 select effective_end_date
 from per_assignments_f
 where person_id = l_person_id
 and p_rpa_eff_date
 between effective_start_date and effective_end_date;

Line: 758

select ppf.effective_end_date effective_end_date,
       ppt.system_person_type system_person_type
from   per_people_f      ppf,
       per_person_types  ppt
where ppf.person_id           = l_person_id
and   ppf.person_type_id      = ppt.person_type_id
and   ppf.effective_end_date >= p_rpa_eff_date
and   ppt.SYSTEM_PERSON_TYPE > 'APL'
order by ppf.effective_start_date;

Line: 795

 select pst.shared_type_name, apf.effective_start_date
 from   HR_ALL_POSITIONS_F apf, PER_SHARED_TYPES pst
 where  apf.position_id = p_position_id
 and    apf.availability_status_id <> 1
 and    apf.effective_end_date >= p_effective_date
 and    pst.lookup_type = 'POSITION_AVAILABILITY_STATUS'
 and    pst.shared_type_id = apf.availability_status_id;

Line: 804

select shared_type_name, shared_type_id
from per_shared_types
where lookup_type = 'POSITION_AVAILABILITY_STATUS'
*/

BEGIN

 FOR c_posn_rec IN c_posn LOOP
   p_hiring_status := c_posn_rec.shared_type_name;