APPS.IGS_PR_VAL_PRGC SQL Statements

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

Line: 16

  		SELECT	'X'
  		FROM	IGS_RU_CALL	src
  		WHERE	src.s_rule_call_cd = p_s_rule_call_cd AND
  			src.s_rule_type_cd = 'PRG';

Line: 59

  	-- Validate the IGS_PR_RU_CAT.s_rule_call_cd can only be updated if
  	-- there are no IGS_PR_RULE or IGS_PR_RU_APPL records linked to
  	-- this IGS_PR_RU_CAT.
  DECLARE
  	v_dummy				VARCHAR2(1);

Line: 65

  		SELECT	'X'
  		FROM	IGS_PR_RULE		prr
  		WHERE	prr.progression_rule_cat	= p_progression_rule_cat;

Line: 69

  		SELECT	'X'
  		FROM	IGS_PR_RU_APPL		pra
  		WHERE	pra.progression_rule_cat = p_progression_rule_cat AND
  			pra.rul_sequence_number 	IS NOT NULL;