APPS.GHR_CPDF_CHECK2 SQL Statements

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

Line: 1449

This has to be deleted according to the update 6 manual for april release
--  120.10.3
  if   substr(p_duty_station_lookup,1,2) = 'US'
    and
       p_agency_sub_element <> 'DJ02'
   then
       hr_utility.set_message(8301, 'GHR_37154_ALL_PROCEDURE_FAIL');

Line: 1508

commented by skutteti on 7-apr-98. As per the new changes this edit has to be deleted.
-- 140.02.2
  if  (
	 p_First_NOAC_Lookup_Code = '117' or
       p_First_NOAC_Lookup_Code = '517'
	 )
    and
    not (
           to_char(p_Effective_Date,'MMDD')>=  '0513'
         and
           to_char(p_Effective_Date,'MMDD')<= '0930'
	   )
    then
       hr_utility.set_message(8301, 'GHR_37157_ALL_PROCEDURE_FAIL');