DBA Data[Home] [Help]

APPS.IGR_AD_VAL_ES SQL Statements

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

Line: 14

  		SELECT	ses.closed_ind
  		FROM	IGS_LOOKUPS_VIEW 	ses
  		WHERE	ses.lookup_type = 'IGR_ENQUIRY_STATUS' AND
		        ses.lookup_code	= p_s_enquiry_status AND
  			ses.closed_ind		= 'Y';