APPS.IGS_FI_GET_SUAEH SQL Statements

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

Line: 22

  		SELECT	*
  		FROM	IGS_EN_SU_ATTEMPT	sua
  		WHERE	sua.person_id = p_person_id AND
  			(p_course_cd IS NULL OR
  			sua.course_cd = p_course_cd) AND
  			(p_unit_cd IS NULL OR
  			sua.unit_cd = p_unit_cd);

Line: 32

  		SELECT	PERSON_ID                      ,
			COURSE_CD                      ,
			UNIT_CD                        ,
			VERSION_NUMBER                 ,
			CAL_TYPE                       ,
			CI_SEQUENCE_NUMBER             ,
			HIST_START_DT                  ,
			HIST_END_DT                    ,
			HIST_WHO                       ,
			LOCATION_CD                    ,
			UNIT_CLASS                     ,
			ENROLLED_DT                    ,
			UNIT_ATTEMPT_STATUS            ,
			ADMINISTRATIVE_UNIT_STATUS     ,
			AUS_DESCRIPTION                ,
			DISCONTINUED_DT                ,
			RULE_WAIVED_DT                 ,
			RULE_WAIVED_PERSON_ID          ,
			NO_ASSESSMENT_IND              ,
			EXAM_LOCATION_CD               ,
			ELO_DESCRIPTION                ,
			SUP_UNIT_CD                    ,
			SUP_VERSION_NUMBER             ,
			ALTERNATIVE_TITLE              ,
			OVERRIDE_ENROLLED_CP           ,
			OVERRIDE_EFTSU                 ,
			OVERRIDE_ACHIEVABLE_CP         ,
			OVERRIDE_OUTCOME_DUE_DT        ,
			OVERRIDE_CREDIT_REASON         ,
			CREATED_BY                     ,
			CREATION_DATE                  ,
			LAST_UPDATED_BY                ,
			LAST_UPDATE_DATE               ,
			LAST_UPDATE_LOGIN              ,
			DCNT_REASON_CD                 ,
			ORG_ID                         ,
            UOO_ID
  		FROM	IGS_EN_SU_ATTEMPT_H	suah
  		WHERE	suah.person_id = p_person_id AND
  			suah.course_cd = cp_course_cd AND
  			suah.unit_cd = cp_unit_cd AND
  			cp_effective_dt	BETWEEN	suah.hist_start_dt AND
  						suah.hist_end_dt;

Line: 98

  		v_suah_rec.hist_who := p_sua_rec.LAST_UPDATED_BY;

Line: 117

  		v_suah_rec.LAST_UPDATED_BY := p_sua_rec.LAST_UPDATED_BY;

Line: 118

  		v_suah_rec.LAST_UPDATE_DATE := p_sua_rec.LAST_UPDATE_DATE;

Line: 295

  		v_suah_rec.LAST_UPDATED_BY := p_suah_rec.LAST_UPDATED_BY;

Line: 296

  		v_suah_rec.LAST_UPDATE_DATE := p_suah_rec.LAST_UPDATE_DATE;

Line: 365

  		v_suah_rec.LAST_UPDATED_BY := p_suahv_rec.LAST_UPDATED_BY;

Line: 366

  		v_suah_rec.LAST_UPDATE_DATE := p_suahv_rec.LAST_UPDATE_DATE;

Line: 397

  			SELECT	*
  			FROM	IGS_AS_SUA_H_V	suahv
  			WHERE	suahv.person_id = p_person_id AND
  				suahv.course_cd = cp_course_cd AND
  				suahv.unit_cd = cp_unit_cd AND
  				suahv.unit_attempt_status = 'ENROLLED' AND
  				cp_effective_dt	<= suahv.hist_start_dt
  			ORDER BY suahv.hist_start_dt desc;

Line: 433

  			IF TRUNC(gv_effective_dt) >= TRUNC(p_sua_rec.LAST_UPDATE_DATE) THEN
  				-- save the current sua data
  				finpl_ins_sua_rec(
  						p_sua_rec.LAST_UPDATE_DATE,
  						SYSDATE,
  						p_sua_rec);

Line: 444

  						p_sua_rec.LAST_UPDATE_DATE,
  						p_sua_rec);

Line: 556

  						r_sua.LAST_UPDATE_DATE,
  						gv_effective_dt,
  						r_sua);

Line: 733

  					IF TRUNC(gv_effective_dt) >= TRUNC(r_sua.LAST_UPDATE_DATE) THEN
  						-- save the current sua data
  						finpl_ins_sua_rec(
  								r_sua.LAST_UPDATE_DATE,
  								SYSDATE,
  								r_sua);