APPS.IGS_PS_VAL_CTY SQL Statements

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

Line: 12

  		SELECT closed_ind
  		FROM   IGS_PS_GOVT_TYPE
  		WHERE  govt_course_type = p_govt_course_type;

Line: 46

  		SELECT closed_ind
  		FROM   IGS_PS_TYPE_GRP
  		WHERE  course_type_group_cd = p_course_type_group_cd;

Line: 86

     smvk     03-Jun-2003   Bug # 2858436. Modified the cursor c_sel_course_award to select open program awards only.
   ***************************************************************/

  	v_check			CHAR;

Line: 91

  		SELECT	'x'
  		FROM	IGS_PS_VER	cv,
  			IGS_PS_AWARD	ca
  		WHERE	course_type	= p_course_type		AND
  			cv.course_cd	= ca.course_cd		AND
  			cv.version_number	= ca.version_number AND
                        ca.closed_ind = 'N';