APPS.IGS_EN_VAL_DIT SQL Statements

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

Line: 10

  p_inserting IN BOOLEAN ,
  p_updating IN BOOLEAN ,
  p_deleting IN BOOLEAN ,
  p_message_name OUT NOCOPY VARCHAR2)
  RETURN BOOLEAN AS
  	v_index			BINARY_INTEGER;

Line: 23

  			SELECT	*
  			INTO	r_disability_type
  			FROM	IGS_AD_DISBL_TYPE
  			WHERE	rowid = gt_rowid_table(v_index);

Line: 61

  		SELECT	IGS_AD_DISBL_TYPE.closed_ind
  		FROM	IGS_AD_DISBL_TYPE
  		WHERE	IGS_AD_DISBL_TYPE.disability_type <> cp_disability_type AND
  			IGS_AD_DISBL_TYPE.govt_disability_type = cp_govt_disability_type AND
  			IGS_AD_DISBL_TYPE.closed_ind = 'N';