APPS.IGS_AD_VAL_SAFT SQL Statements

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

Line: 22

  		SELECT	fs.closed_ind
  		FROM	IGS_FI_FUND_SRC	fs
  		WHERE	fs.funding_source = p_funding_source;

Line: 68

  		SELECT	ou.institution_cd
  		FROM	IGS_OR_UNIT			ou,
  			IGS_OR_STATUS			os
  		WHERE	ou.org_unit_cd			= p_org_unit_cd AND
  			ou.start_dt			= p_ou_start_dt AND
  			os.org_status			= ou.org_status AND
  			os.s_org_status			<> cst_inactive;

Line: 76

  		SELECT	'X'
  		FROM	IGS_OR_INSTITUTION			ins,
  			IGS_OR_INST_STAT		ist
  		WHERE	ins.institution_cd		= cp_institution_cd AND
  			ins.local_institution_ind 	= 'Y' AND
  			ins.institution_status		= ist.institution_status AND
  			ist.s_institution_status 	= cst_active;

Line: 132

  		SELECT 	ctg.closed_ind
  		FROM	IGS_PS_TYPE_GRP		ctg
  		WHERE	ctg.course_type_group_cd	= p_course_type_group_cd;

Line: 175

  		SELECT 	uicl.closed_ind
  		FROM	IGS_PS_UNIT_INT_LVL		uicl
  		WHERE	uicl.unit_int_course_level_cd	= p_unit_int_course_level_cd;