APPS.GHR_CPDF_CHECK4A SQL Statements

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

Line: 1051

/* This is commented by skutteti on 8-apr-98 as this has to be deleted as per the
   update 6 of the edit manual for the april release.

   if  p_First_NOAC_Lookup_Code= '517'
     and
       NOT ((p_First_Action_NOA_LA_Code1 in
           ('ABL','ABM','ABR','ABS','BWM','HAM','MXM',
           'M2M','M4M','M6M','M8M','NCM','NEM','NUM',
           'PNR','UAM','UFM','V1P','V8N','V8V','ZLM',
           'ZSK','ZSP','ZVB','ZVM','Z2M') OR
           (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
           LENGTH(p_First_Action_NOA_LA_Code1) =3 AND p_First_Action_NOA_LA_Code1 <>'WWM' ))
           AND
          (p_First_Action_NOA_LA_Code2 in
           ('ABL','ABM','ABR','ABS','BWM','HAM','MXM',
           'M2M','M4M','M6M','M8M','NCM','NEM','NUM',
           'PNR','UAM','UFM','V1P','V8N','V8V','ZLM',
           'ZSK','ZSP','ZVB','ZVM','Z2M') OR
           (SUBSTR(p_First_Action_NOA_LA_Code1,1,1) IN ('W','X','Y') AND
           LENGTH(p_First_Action_NOA_LA_Code1) =3 AND p_First_Action_NOA_LA_Code1 <>'WWM')))
     THEN
	  hr_utility.set_message(8301, 'GHR_37375_ALL_PROCEDURE_FAIL');