APPS.IGS_PR_VAL_SOPC SQL Statements

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

Line: 24

  	SELECT	'X'
  	FROM	IGS_PR_S_OU_PRG_CAL
  	WHERE	org_unit_cd = p_org_unit_cd
  	AND	ou_start_dt = p_ou_start_dt
  	AND	appeal_length IS NOT NULL;

Line: 72

  	SELECT	'X'
  	FROM	IGS_PR_S_OU_PRG_CAL
  	WHERE	org_unit_cd = p_org_unit_cd
  	AND	ou_start_dt = p_ou_start_dt
  	AND	show_cause_length IS NOT NULL;

Line: 118

  		SELECT	sprgc.appeal_ind
  		FROM	IGS_PR_S_PRG_CONF 		sprgc
  		WHERE	sprgc.s_control_num 	= 1;

Line: 164

  		SELECT	sprgc.show_cause_ind
  		FROM	IGS_PR_S_PRG_CONF 		sprgc
  		WHERE	sprgc.s_control_num 	= 1;

Line: 212

  		SELECT	os.s_org_status
  		FROM	IGS_OR_UNIT			 ou,
  			IGS_OR_STATUS		 os
  		WHERE	ou.org_unit_cd		= p_org_unit_cd AND
  			ou.start_dt 		= p_start_dt AND
  			os.org_status		= ou.org_status;