APPS.IGS_AD_VAL_AAL SQL Statements

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

Line: 20

  		SELECT 'X'
  		FROM	IGS_CO_S_LTR	slet
  		WHERE	slet.s_letter_reference_type	= 'ADM'			AND
  			slet.correspondence_type	= p_correspondence_type;

Line: 25

  		SELECT 'X'
  		FROM	IGS_AD_PRCS_CAT_LTR	apcl
  		WHERE	apcl.admission_cat		= p_admission_cat	AND
  			apcl.s_admission_process_type	= p_s_admission_process_type;

Line: 30

  		SELECT 'X'
  		FROM	IGS_AD_PRCS_CAT_LTR	apcl
  		WHERE	apcl.admission_cat		= p_admission_cat		AND
  			apcl.s_admission_process_type	= p_s_admission_process_type	AND
  			apcl.correspondence_type	= p_correspondence_type;

Line: 37

  		SELECT 'X'
  		FROM	IGS_AD_PRCS_CAT_STEP	apcs
  		WHERE	apcs.admission_cat		= p_admission_cat		AND
  			apcs.s_admission_process_type	= p_s_admission_process_type	AND
  			apcs.s_admission_step_type	= cp_step_type AND
  			apcs.step_group_type <> 'TRACK'; --2402377

Line: 115

  		SELECT	sequence_number
  		FROM	IGS_AD_APPL_LTR
  		WHERE	person_id 		= p_person_id AND
  			admission_appl_number 	= p_admission_appl_number AND
  			correspondence_type 	= p_correspondence_type;

Line: 155

  		SELECT	cort.closed_ind
  		FROM	IGS_CO_TYPE cort
  		WHERE	cort.correspondence_type = cp_correspondence_type;