APPS.IGS_PR_VAL_SCPC SQL Statements

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

Line: 24

  	SELECT	'X'
  	FROM	IGS_PR_S_CRV_PRG_CAL
  	WHERE	course_cd = p_course_cd
  	AND	version_number = p_version_number
  	AND	appeal_length IS NOT NULL;

Line: 72

  	SELECT	'X'
  	FROM	IGS_PR_S_CRV_PRG_CAL
  	WHERE	course_cd = p_course_cd
  	AND	version_number = p_version_number
  	AND	show_cause_length IS NOT NULL;

Line: 185

  		SELECT	da.closed_ind
  		FROM	IGS_CA_DA	da
  		WHERE	da.dt_alias	= p_dt_alias;