APPS.GHR_CPDF_CHECK6 SQL Statements

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

Line: 194

   /* 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: 505

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

Line: 1028

        Default:  Insert asterisks in step or rate. */
-- UPD 56 (Bug# 8309414) Terminating the edit eff date 13-Aug-2007
if p_effective_date < fnd_date.canonical_to_date('2007/08/14') then
   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');