APPS.IGS_RE_VAL_MIL SQL Statements

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

Line: 22

  	SELECT	count('x') duplicate_cnt
  	FROM	IGS_PR_MILESTONE	mil
  	WHERE	mil.person_id		= p_person_id and
  		mil.ca_sequence_number	= p_ca_sequence_number
  	GROUP BY
  		mil.milestone_type,
  		mil.due_dt;

Line: 69

  	-- * Cannot delete IGS_PR_MILESTONE if status <> 'PLANNED'
  	-- * Cannot delete IGS_PR_MILESTONE which has had a status other than planned
  DECLARE
  	cst_planned	CONSTANT	IGS_PR_MILESTONE.milestone_status%TYPE := 'PLANNED';

Line: 78

  		SELECT	mst.s_milestone_status
  		FROM	IGS_PR_MS_STAT	mst
  		WHERE	mst.milestone_status	= p_milestone_status;

Line: 82

  		SELECT	'x'
  		FROM	IGS_PR_MILESTONE_HST	milh,
  			IGS_PR_MS_STAT	mst
  		WHERE	milh.person_id		= p_person_id AND
  			milh.ca_sequence_number	= p_ca_sequence_number AND
  			milh.sequence_number	= p_sequence_number AND
  			milh.milestone_status	IS NOT NULL AND
  			mst.milestone_status	= milh.milestone_status AND
  			mst.s_milestone_status	IN (
  						cst_planned,
  						cst_replanned,
  						cst_achieved);

Line: 97

  	-- Select detail from IGS_PR_MILESTONE status
  	OPEN c_mst;

Line: 151

  		SELECT	mst.s_milestone_status
  		FROM	IGS_PR_MS_STAT	mst
  		WHERE	mst.milestone_status	= p_milestone_status;

Line: 230

  		SELECT	mst.s_milestone_status
  		FROM	IGS_PR_MS_STAT	mst
  		WHERE	mst.milestone_status	= p_milestone_status;

Line: 236

  		SELECT	mty.ntfctn_re_reminder_days,
  			mty.ntfctn_reminder_days
  		FROM	IGS_PR_MILESTONE_TYP		mty
  		WHERE	mty.milestone_type	= p_milestone_type;

Line: 317

  		SELECT	mil.due_dt
  		FROM	IGS_PR_MILESTONE mil
  		WHERE	mil.person_id	= p_person_id	AND
  			mil.ca_sequence_number	= p_ca_sequence_number	AND
  			NVL(mil.preced_sequence_number,0)	= p_sequence_number;

Line: 367

  		SELECT	s_milestone_status,
  			closed_ind
  		FROM	IGS_PR_MS_STAT	mst
  		WHERE	mst.milestone_status	= cp_milestone_status;

Line: 372

  		SELECT	mst.s_milestone_status
  		FROM	IGS_PR_MILESTONE mil,
  			IGS_PR_MS_STAT mst
  		WHERE	mil.person_id	= p_person_id	AND
  			mil.ca_sequence_number	= p_ca_sequence_number	AND
  			mil.sequence_number	= p_preced_sequence_number AND
  			mst.milestone_status	= mil.milestone_status;

Line: 464

  		SELECT 'x'
  		FROM	IGS_PR_MILESTONE_TYP	mty
  		WHERE	mty.milestone_type	= p_milestone_type AND
  			mty.closed_ind		= 'Y';

Line: 513

  		SELECT	mil.due_dt
  		FROM	IGS_PR_MILESTONE	mil
  		WHERE	mil.person_id		= p_person_id AND
  			mil.ca_sequence_number	= p_ca_sequence_number AND
  			mil.sequence_number	= p_preced_sequence_number;