APPS.IGS_AS_VAL_SCAP SQL Statements

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

Line: 16

  		SELECT 	closed_ind
  		FROM	IGS_AS_SPCL_CONS_CAT
  		WHERE	spcl_consideration_cat = p_spcl_consideration_cat;

Line: 59

  		SELECT 	closed_ind
  		FROM	IGS_AS_SPCL_CONS_OUT
  		WHERE	spcl_consideration_outcome = p_spcl_consideration_outcome;

Line: 110

  		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: 118

  		SELECT	suv.person_id
  		FROM	IGS_AS_UAI_SUA_V suv
  		WHERE	suv.person_id			= p_person_id 		AND
  			suv.course_cd			= p_course_cd 		AND
                -- anilk, 22-Apr-2003, Bug# 2829262
  			suv.uoo_id      		= p_uoo_id      	AND
  			suv.ass_id			= p_ass_id		AND
  			suv.uai_logical_delete_dt	IS NULL;

Line: 131

                SELECT  'X'
                FROM    igs_ps_unitass_item_v usv
                WHERE   usv.ass_id = p_ass_id AND
                        usv.uoo_id = l_usv_uoo_id AND
                        usv.logical_delete_dt IS NULL;

Line: 202

  	SELECT	suaai.logical_delete_dt
  	FROM	IGS_AS_SU_ATMPT_ITM	suaai
  	WHERE	suaai.person_id		= p_person_id AND
  		suaai.course_cd		= p_course_cd AND
        -- anilk, 22-Apr-2003, Bug# 2829262
  		suaai.uoo_id            = p_uoo_id AND
  		suaai.ass_id		= p_ass_id AND
  		suaai.creation_dt	= p_creation_dt AND
  		suaai.logical_delete_dt IS NOT NULL;

Line: 211

  	v_suaai_logical_delete_dt	DATE;

Line: 217

  	FETCH c_suaai INTO v_suaai_logical_delete_dt;