APPS.IGS_PS_VAL_US SQL Statements

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

Line: 19

  		SELECT	uss.closed_ind
  		FROM	IGS_EN_UNIT_SET_STAT	uss
  		WHERE	uss.unit_set_status = p_unit_set_status;

Line: 62

  	SELECT  usc.closed_ind
  	FROM    IGS_EN_UNIT_SET_CAT    usc
  	WHERE   usc.unit_set_cat = p_unit_set_cat;

Line: 168

  		SELECT	uss.s_unit_set_status
  		FROM	IGS_EN_UNIT_SET_STAT	uss
  		WHERE	uss.unit_set_status = p_unit_set_status;

Line: 172

  	-- 1. Select the IGS_EN_UNIT_SET_STAT.s_unit_set_status for
  	-- the given p_unit_set_status.
  	OPEN c_uss;

Line: 229

  		SELECT	sca.course_attempt_status
  		FROM	IGS_EN_STDNT_PS_ATT		sca,
  			IGS_AS_SU_SETATMPT	susa
  		WHERE	sca.person_id = susa.person_id AND
  			sca.course_cd = susa.course_cd AND
  			sca.course_attempt_status IN (
  						cst_enrolled,
  						cst_intermit,
  						cst_inactive) AND
  			susa.unit_set_cd		= p_unit_set_cd AND
  			susa.us_version_number		= p_version_number AND
  			susa.student_confirmed_ind	= 'Y';

Line: 284

  		SELECT	uss.s_unit_set_status
  		FROM	IGS_EN_UNIT_SET_STAT	uss
  		WHERE	uss.unit_set_status = cp_unit_set_status;

Line: 342

  		SELECT 'x'
  		FROM	IGS_EN_UNIT_SET_STAT	uss
  		WHERE	uss.unit_set_status	= unit_set_status AND
  			uss.s_unit_set_status	= cst_active;

Line: 347

  		SELECT 	'X'
  		FROM	IGS_EN_UNIT_SET	us,
  			IGS_EN_UNIT_SET_STAT	uss
  		WHERE	us.unit_set_cd		= p_unit_set_cd		AND
  			us.version_number	<> p_version_number	AND
  			us.expiry_dt		IS NULL			AND
  			us.unit_set_status	= uss.unit_set_status	AND
  		 	uss.s_unit_set_status	= cst_active;

Line: 406

  	-- This module validates whether or not inserts and updates can be made to
  	-- IGS_EN_UNIT_SET details
  	-- on the IGS_PS_UNIT set record. It is fired at record level (hence could not be
  	-- incorporated
  	-- in the CRSP_VAL_US_STATUS validation).
  DECLARE
  	v_new_unit_set_status	IGS_EN_UNIT_SET_STAT.s_unit_set_status%TYPE;

Line: 416

  		SELECT	uss.s_unit_set_status
  		FROM 	IGS_EN_UNIT_SET_STAT uss
  		WHERE	uss.unit_set_status = p_new_unit_set_status;

Line: 421

  		SELECT	uss.s_unit_set_status
  		FROM 	IGS_EN_UNIT_SET_STAT uss
  		WHERE	uss.unit_set_status = p_old_unit_set_status;

Line: 479

  		SELECT	uss.s_unit_set_status
  		FROM	IGS_EN_UNIT_SET_STAT	uss
  		WHERE	uss.unit_set_status = p_unit_set_status;