APPS.IGS_PS_VAL_CEPRC SQL Statements

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

Line: 36

  		SELECT	'X'
  		FROM	IGS_PS_ENT_PT_REF_CD ceprc
  		WHERE	ceprc.coo_id			= p_coo_id AND
  			NVL(ceprc.unit_set_cd, 'NONE') 	= NVL(p_unit_set_cd, 'NONE') AND
  			NVL(ceprc.us_version_number, 0)	= NVL(p_us_version_number, 0) AND
  			ceprc.reference_cd_type		= p_reference_cd_type AND
  			ceprc.sequence_number		<> p_sequence_number;

Line: 84

	  SELECT 'X'
	    FROM IGS_PS_OFR_UNIT_SET cous,IGS_PS_OFR_OPT coo,igs_en_unit_set_stat uss1,IGS_EN_UNIT_SET_ALL US
	    WHERE coo.coo_id  =  p_coo_id
	    AND us.version_number = p_us_version_number
	    AND us.unit_set_cd = p_unit_set_cd
	    AND us.expiry_dt   IS NULL
	    AND coo.course_cd = cous.course_cd
	    AND coo.version_number = cous.crv_version_number
	    AND coo.CAL_TYPE = cous.CAL_TYPE
	    AND us.unit_set_cd = cous.unit_set_cd
	    AND us.version_number = cous.us_version_number
	    AND us.unit_set_status = uss1.unit_set_status
	    AND uss1.s_unit_set_status =cst_active
	    AND NOT EXISTS (SELECT   1
			    FROM   IGS_PS_OF_OPT_UNT_ST coous
				      WHERE  coous.course_cd = cous.course_cd
				      AND coous.crv_version_number = cous.crv_version_number
				      AND coous.CAL_TYPE = cous.CAL_TYPE
				      AND coous.unit_set_cd = cous.unit_set_cd
				      AND coous.us_version_number = cous.us_version_number
				     );

Line: 106

	SELECT 'X'
	FROM IGS_PS_OF_OPT_UNT_ST coous,IGS_EN_UNIT_SET_ALL US,igs_en_unit_set_stat uss1
	WHERE coous.coo_id  = p_coo_id
	AND us.version_number = p_us_version_number
	AND us.unit_set_cd = p_unit_set_cd
	AND us.expiry_dt   IS NULL
	AND us.unit_set_cd = coous.unit_set_cd
	AND us.version_number = coous.us_version_number
	AND us.unit_set_status = uss1.unit_set_status
	AND uss1.s_unit_set_status = cst_active;