APPS.IGS_AS_VAL_SUAAP SQL Statements

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

Line: 69

  		SELECT	sua.unit_attempt_status,
  			sua.uoo_id
  		FROM	IGS_EN_SU_ATTEMPT sua
  		WHERE	sua.person_id 		= p_person_id 	AND
  			sua.course_cd 		= p_course_cd 	AND
                -- anilk, 22-Apr-2003, Bug# 2829262
  			sua.uoo_id 	        = p_uoo_id;

Line: 78

  		SELECT 	'x'
  		FROM	IGS_PS_UNIT_OFR_OPT_ASS_PAT_V uooap_v
  		WHERE	uooap_v.unit_cd 		= p_unit_cd AND
  			uooap_v.cal_type 		= p_cal_type AND
  			uooap_v.ci_sequence_number 	= p_ci_sequence_number AND
  			uooap_v.ass_pattern_id 		= p_ass_pattern_id AND
  			uooap_v.uoo_id			= cp_uoo_id AND
  			uooap_v.uap_logical_delete_dt IS NULL;

Line: 157

  		SELECT	'x'
  		FROM	IGS_AS_SU_ATMPT_PAT	suaap
  		WHERE	suaap.person_id			= p_person_id AND
  			suaap.course_cd			= p_course_cd AND
                -- anilk, 22-Apr-2003, Bug# 2829262
		        suaap.uoo_id	                = p_uoo_id AND
  			suaap.ass_pattern_id		= p_ass_pattern_id AND
  			suaap.creation_dt		<> p_creation_dt AND
  			suaap.logical_delete_dt		IS NULL;

Line: 207

  		SELECT	'x'
  		FROM	IGS_GE_S_DSB_TAB_TRG
  		WHERE	table_name = p_table_name AND
  			session_id = (
  				SELECT	userenv('SESSIONID')
  				FROM	dual );