APPS.IGS_ST_VAL_GDHC SQL Statements

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

Line: 14

  	SELECT	gdhc.start_dt,
  		gdhc.end_dt
  	FROM	IGS_FI_GV_DSP_HEC_CN gdhc
  	WHERE	gdhc.govt_discipline_group_cd = p_govt_discipline_group_cd AND
  		gdhc.start_dt <> p_start_dt;

Line: 84

  	SELECT	gdhc.start_dt
  	FROM	IGS_FI_GV_DSP_HEC_CN gdhc
  	WHERE	gdhc.govt_discipline_group_cd = p_govt_discipline_group_cd AND
  		gdhc.start_dt <> p_start_dt AND
  		gdhc.end_dt IS NULL;

Line: 92

  	-- select all organisational units
  	OPEN  c_gdhc_rec;

Line: 122

  		SELECT	gd.closed_ind
  		FROM	IGS_PS_GOVT_DSCP gd
  		WHERE	gd.govt_discipline_group_cd = p_govt_discipline_group_cd;