APPS.IGS_EN_GET_SCAEH_DTL SQL Statements

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

Line: 22

  		SELECT	/*+ ROWID(IGS_EN_STDNT_PS_ATT) */
  			course_attempt_status,
  			commencement_dt,
  			DECODE(cp_column_name,	'VERSION_NUMBER', TO_CHAR(version_number),
  						'CAL_TYPE', cal_type,
  						'LOCATION_CD', location_cd,
  						'ATTENDANCE_MODE', attendance_mode,
  						'ATTENDANCE_TYPE', attendance_type,
  						'STUDENT_CONFIRMED_IND', student_confirmed_ind,
  						'COMMENCEMENT_DT', IGS_GE_DATE.IGSCHARDT(commencement_dt),
  						'COURSE_ATTEMPT_STATUS', course_attempt_status,
  						'DERIVED_ATT_TYPE', derived_att_type,
  						'DERIVED_ATT_MODE', derived_att_mode,
  						'PROVISIONAL_IND', provisional_ind,
  						'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
  						'DISCONTINUATION_REASON_CD', discontinuation_reason_cd,
  						'FUNDING_SOURCE', funding_source,
  						'EXAM_LOCATION_CD', exam_location_cd,
  						'DERIVED_COMPLETION_YR', TO_CHAR(derived_completion_yr),
  						'DERIVED_COMPLETION_PERD', derived_completion_perd,
  						'NOMINATED_COMPLETION_YR', TO_CHAR(nominated_completion_yr),
  						'NOMINATED_COMPLETION_PERD', nominated_completion_perd,
  						'RULE_CHECK_IND', rule_check_ind,
  						'WAIVE_OPTION_CHECK_IND', waive_option_check_ind,
  						'LAST_RULE_CHECK_DT', IGS_GE_DATE.IGSCHARDT(last_rule_check_dt),
  						'PUBLISH_OUTCOMES_IND', publish_outcomes_ind,
  						'COURSE_RQRMNT_COMPLETE_IND', course_rqrmnt_complete_ind,
  						'OVERRIDE_TIME_LIMITATION', TO_CHAR(override_time_limitation),
  						'ADVANCED_STANDING_IND', advanced_standing_ind,
  						'FEE_CAT', fee_cat,
  						'CORRESPONDENCE_CAT', correspondence_cat,
  						'SELF_HELP_GROUP_IND', self_help_group_ind,
  						'PRIMARY_PROGRAM_TYPE', primary_program_type,  --Bug 2162747 by vvutukur
  						'KEY_PROGRAM', key_program)                    --Bug 2162747 by vvutukur
  		FROM	IGS_EN_STDNT_PS_ATT
  		WHERE	person_id = cp_person_id AND
  			course_cd = cp_course_cd;

Line: 64

  		SELECT	/*+ FIRST_ROWS */
  			hist_start_dt,
  			hist_end_dt,
  			DECODE(cp_column_name,	'VERSION_NUMBER', TO_CHAR(version_number),
  						'CAL_TYPE', cal_type,
  						'LOCATION_CD', location_cd,
  						'ATTENDANCE_MODE', attendance_mode,
  						'ATTENDANCE_TYPE', attendance_type,
  						'STUDENT_CONFIRMED_IND', student_confirmed_ind,
  						'COMMENCEMENT_DT', IGS_GE_DATE.IGSCHARDT(commencement_dt),
  						'COURSE_ATTEMPT_STATUS', course_attempt_status,
  						'DERIVED_ATT_TYPE', derived_att_type,
  						'DERIVED_ATT_MODE', derived_att_mode,
  						'PROVISIONAL_IND', provisional_ind,
  						'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
  						'DISCONTINUATION_REASON_CD', discontinuation_reason_cd,
  						'FUNDING_SOURCE', funding_source,
  						'EXAM_LOCATION_CD', exam_location_cd,
  						'DERIVED_COMPLETION_YR', TO_CHAR(derived_completion_yr),
  						'DERIVED_COMPLETION_PERD', derived_completion_perd,
  						'NOMINATED_COMPLETION_YR', TO_CHAR(nominated_completion_yr),
  						'NOMINATED_COMPLETION_PERD', nominated_completion_perd,
  						'RULE_CHECK_IND', rule_check_ind,
  						'WAIVE_OPTION_CHECK_IND', waive_option_check_ind,
  						'LAST_RULE_CHECK_DT', IGS_GE_DATE.IGSCHARDT(last_rule_check_dt),
  						'PUBLISH_OUTCOMES_IND', publish_outcomes_ind,
  						'COURSE_RQRMNT_COMPLETE_IND', course_rqrmnt_complete_ind,
  						'OVERRIDE_TIME_LIMITATION', TO_CHAR(override_time_limitation),
  						'ADVANCED_STANDING_IND', advanced_standing_ind,
  						'FEE_CAT', fee_cat,
  						'CORRESPONDENCE_CAT', correspondence_cat,
  						'SELF_HELP_GROUP_IND', self_help_group_ind,
  						'PRIMARY_PROGRAM_TYPE', primary_program_type,
  						'KEY_PROGRAM', key_program)
  		FROM	IGS_AS_SC_ATTEMPT_H
  		WHERE	person_id = cp_person_id AND
  			course_cd = cp_course_cd AND
  			course_attempt_status = 'ENROLLED'
  		ORDER BY hist_start_dt DESC;

Line: 239

  		SELECT	/*+ ROWID(IGS_EN_STDNT_PS_ATT) */
  			course_attempt_status,
  			commencement_dt,
  			discontinued_dt
  		FROM	IGS_EN_STDNT_PS_ATT
  		WHERE	person_id = cp_person_id AND
  			course_cd = cp_course_cd;

Line: 250

  		SELECT	MAX(hist_end_dt)
  		FROM	IGS_AS_SC_ATTEMPT_H
  		WHERE	person_id = cp_person_id AND
  			course_cd = cp_course_cd AND
  			course_attempt_status = 'ENROLLED';

Line: 352

  		SELECT	/*+ ROWID(IGS_EN_STDNT_PS_ATT) */
  			course_attempt_status,
  			commencement_dt,
  			discontinued_dt
  		FROM	IGS_EN_STDNT_PS_ATT
  		WHERE	person_id = cp_person_id AND
  			course_cd = cp_course_cd;

Line: 362

  		SELECT	MAX(hist_start_dt)
  		FROM	IGS_AS_SC_ATTEMPT_H
  		WHERE	person_id = cp_person_id AND
  			course_cd = cp_course_cd AND
  			course_attempt_status = 'ENROLLED';