DBA Data[Home] [Help]

APPS.IGS_PR_VAL_SCAAE SQL Statements

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

Line: 33

  		SELECT	sca.course_attempt_status
  		FROM	IGS_EN_STDNT_PS_ATT	sca
  		WHERE	sca.person_id	= p_person_id And
  			sca.course_cd	= p_course_cd And
  			sca.course_attempt_status IN (
  						cst_discontinued,
  						cst_intermit,
  						cst_lapsed);