APPS.IGS_PS_VAL_CRFC SQL Statements

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

Line: 11

   		SELECT 	closed_ind
  		FROM	IGS_GE_REF_CD_TYPE
  		WHERE	reference_cd_type = p_reference_cd_type;

Line: 53

  		SELECT	rct.s_reference_cd_type
  		FROM	IGS_GE_REF_CD_TYPE	rct
  		WHERE	rct.reference_cd_type = p_reference_cd_type;

Line: 58

  		SELECT	COUNT(*)
  		FROM	IGS_PS_REF_CD	crfc,
  			IGS_GE_REF_CD_TYPE	rct
  		WHERE	crfc.course_cd		= p_course_cd AND
  			crfc.version_number	= p_version_number AND
  			(crfc.reference_cd_type	<> p_reference_cd_type OR
  			crfc.reference_cd	<> p_reference_cd) AND
  			rct.reference_cd_type	= crfc.reference_cd_type AND
  			rct.s_reference_cd_type	= cp_s_reference_cd_type AND
  			rct.closed_ind		= 'N';