APPS.IGS_CO_VAL_CCI SQL Statements

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

Line: 28

  		SELECT	sca.correspondence_cat
  		FROM	IGS_EN_STDNT_PS_ATT sca
  		WHERE	sca.person_id = p_person_id AND
  			sca.course_cd = p_course_cd AND
  			sca.correspondence_cat = p_correspondence_cat;

Line: 34

  		SELECT	cortjo.correspondence_type
  		FROM	IGS_CO_TYPE_JO	cortjo
  		WHERE	cortjo.s_job_name = p_job_name AND
  			cortjo.output_num = p_output_num;

Line: 39

  		SELECT	sca.correspondence_cat
  		FROM	IGS_EN_STDNT_PS_ATT	sca
  		WHERE	sca.person_id = p_person_id AND
  			sca.course_cd = p_course_cd;

Line: 56

  			SELECT	cci.block_when_encumbered_ind
  			FROM	IGS_CO_CAT_ITM	cci
  			WHERE	cci.correspondence_cat = p_correspondence_cat AND
  				cci.correspondence_type = p_correspondence_type AND
  				cci.logical_delete_dt IS NULL;

Line: 62

  			SELECT	cortjo.correspondence_type
  			FROM	IGS_CO_TYPE_JO	cortjo
  			WHERE	cortjo.s_job_name = p_job_name AND
  				cortjo.output_num = p_output_num AND
  				cortjo.correspondence_type IN (
  						SELECT	cci.correspondence_type
  						FROM	IGS_CO_CAT_ITM	cci
  						WHERE 	cci.correspondence_type =
  							cortjo.correspondence_type  AND
  							cci.logical_delete_dt IS NULL);

Line: 232

  		SELECT	cci.correspondence_cat
  		FROM	IGS_CO_CAT_ITM cci
  		WHERE	cci.correspondence_cat = cp_correspondence_cat AND
  			cci.correspondence_type = cp_correspondence_type AND
  			cci.create_dt <> cp_create_dt AND
  			cci.logical_delete_dt IS NULL;

Line: 241

  	--  entry has been logically deleted.
  	--  That is, the same correspondence type may be added multiple times
  	--  for a correspondence category but only one may have the deletion
  	--  date set to null.
  	p_message_name := Null;