APPS.IGS_EN_VAL_SCSR SQL Statements

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

Line: 32

  		SELECT	'X'
  		FROM	IGS_PS_STDNT_SPL_REQ scsr1
  		WHERE	scsr1.person_id 		= p_person_id AND
  			scsr1.course_cd 		= p_course_cd AND
  			scsr1.special_requirement_cd 	= p_special_requirement_cd AND
  			scsr1.completed_dt 		<> p_completed_dt AND
  			scsr1.expiry_dt IS NULL;

Line: 40

  		SELECT	scsr2.completed_dt,
  			scsr2.expiry_dt
  		FROM	IGS_PS_STDNT_SPL_REQ scsr2
  		WHERE	scsr2.person_id 		= p_person_id AND
  			scsr2.course_cd 		= p_course_cd AND
  			scsr2.special_requirement_cd 	= p_special_requirement_cd AND
  			scsr2.completed_dt 		<> p_completed_dt;

Line: 141

  		SELECT	'x'
  		FROM	dual
  		WHERE	SYSDATE < p_completed_dt;

Line: 221

  	-- DELETED, LAPSED or UNCONFIRM) before inserting, updating
  	-- or deleting IGS_PS_STDNT_SPL_REQ records.
  DECLARE
  	CURSOR	c_sca IS
  		SELECT	course_attempt_status
  		FROM	IGS_EN_STDNT_PS_ATT
  		WHERE	person_id	= p_person_id AND
  			course_cd	= p_course_cd;

Line: 243

  						'DELETED',
  						'LAPSED',
  						'UNCONFIRM') THEN
  			CLOSE c_sca;

Line: 277

  		SELECT	'x'
  		FROM	IGS_GE_SPL_REQ	srq
  		WHERE	srq.special_requirement_cd	= p_special_requirement_cd AND
  			srq.closed_ind			= 'Y';