APPS.GHR_CPDF_CHECK6 SQL Statements

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

Line: 184

   /* This is not required according to the update6 summary of the edit manual.
   if substr(p_prior_duty_station, 1, 2) = 'US' and
      p_agency_subelement <> 'DJ02' then
      hr_utility.set_message(8301, 'GHR_37607_ALL_PROCEDURE_FAIL');

Line: 450

  select '1' from ghr_pois
  where personnel_office_id =
    substr(p_employee_National_ID,2,2)||substr(p_employee_National_ID,5,2);

Line: 920

        Default:  Insert asterisks in step or rate. */

   if p_to_pay_plan = 'IJ' and
      p_pay_rate_determinant in ('0','7') and
      p_step_or_rate not in ('01','02','03','04') and
      p_step_or_rate is not null then
      hr_utility.set_message(8301, 'GHR_38552_ALL_PROCEDURE_FAIL');