APPS.IGS_PS_VAL_AW SQL Statements

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

Line: 22

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

  DECLARE
  	CURSOR c_caw IS
  		SELECT 	'x'
  		FROM	IGS_PS_AWARD	caw
  		WHERE	caw.award_cd	= p_award_cd
                AND     caw.closed_ind  = 'N';

Line: 32

  		SELECT	'x'
  		FROM	IGS_GR_GRADUAND	gr
  		WHERE	gr.award_cd	= p_award_cd;

Line: 36

  		SELECT	'x'
  		FROM	IGS_GR_SPECIAL_AWARD	spa
  		WHERE	spa.award_cd	= p_award_cd;

Line: 114

  		SELECT	'x'
  		FROM	IGS_GR_TESTAMUR_TYPE	tt
  		WHERE	testamur_type	= p_testamur_type AND
  			closed_ind 	= 'Y';