APPS.IGS_ST_VAL_ESSC SQL Statements

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

Line: 6

  FUNCTION stap_val_essc_delete(
  p_snapshot_dt_time IN DATE ,
  p_delete_snapshot_ind IN VARCHAR2 DEFAULT 'N',
  p_message_name OUT NOCOPY VARCHAR2)
  RETURN BOOLEAN AS
  	gv_other_detail		VARCHAR2(255);

Line: 16

  		SELECT	gsc.submission_yr
  		FROM	IGS_ST_GVT_SPSHT_CTL gsc
  		WHERE	gsc.ess_snapshot_dt_time = cp_snapshot_dt_time;

Line: 21

  	-- IGS_EN_ST_SPSHT_CTL.delete_snapshot_ind.
  	--  If the enrolment statistics snapshot is used by a government snapshot then
  	--  it cannot be marked for delete.
  	p_message_name := null;

Line: 27

  		p_delete_snapshot_ind <> 'Y') THEN
  		RETURN TRUE;

Line: 41

		FND_MESSAGE.SET_TOKEN('NAME','IGS_ST_VAL_ESSC.stap_val_essc_deleten');

Line: 45

  END stap_val_essc_delete;