APPS.IGS_PS_VAL_CAL SQL Statements

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

Line: 19

  		SELECT	MAX(effective_start_dt)
  		FROM	IGS_PS_ANL_LOAD
  		WHERE	course_cd 			= p_course_cd		AND
  			version_number			= p_version_number	AND
  			yr_num 			= p_yr_num		AND
  			effective_start_dt 		< p_effective_start_dt;

Line: 26

  		SELECT	'x'
  		FROM	IGS_PS_ANL_LOAD_U_LN
  		WHERE	course_cd 			= p_course_cd		AND
  			crv_version_number		= p_version_number	AND
  			yr_num 			= p_yr_num		AND
  			effective_start_dt 		= gv_effective_start_dt;

Line: 73

  		SELECT	'x'
  		FROM	IGS_PS_ANL_LOAD
  		WHERE	course_cd		= p_course_cd		AND
  			version_number		= p_version_number	AND
  			yr_num			= p_yr_num		AND
  			effective_start_dt    	 <> p_effective_start_dt	AND
  			effective_end_dt		IS NULL;