[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
unit_attempt_status,
enrolled_dt,
DECODE (cp_column_name,
'VERSION_NUMBER', TO_CHAR(version_number),
'LOCATION_CD', location_cd,
'UNIT_CLASS', unit_class,
'ENROLLED_DT', IGS_GE_DATE.IGSCHARDT(enrolled_dt),
'UNIT_ATTEMPT_STATUS', unit_attempt_status,
'ADMINISTRATIVE_UNIT_STATUS', administrative_unit_status,
'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
'RULE_WAIVED_DT', IGS_GE_DATE.IGSCHARDT(rule_waived_dt),
'RULE_WAIVED_PERSON_ID', TO_CHAR(rule_waived_person_id),
'NO_ASSESSMENT_IND', no_assessment_ind,
'EXAM_LOCATION_CD', exam_location_cd,
'SUP_VERSION_NUMBER', TO_CHAR(sup_version_number),
'ALTERNATIVE_TITLE', alternative_title,
'OVERRIDE_ENROLLED_CP', TO_CHAR(override_enrolled_cp),
'OVERRIDE_EFTSU', TO_CHAR(override_eftsu),
'OVERRIDE_ACHIEVABLE_CP', TO_CHAR(override_achievable_cp),
'OVERRIDE_OUTCOME_DUE_DT', IGS_GE_DATE.IGSCHARDT(override_outcome_due_dt),
'OVERRIDE_CREDIT_REASON', override_credit_reason)
FROM IGS_EN_SU_ATTEMPT
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd AND
uoo_id = cp_uoo_id;
SELECT /*+ FIRST_ROWS */
hist_start_dt,
hist_end_dt,
DECODE (cp_column_name,
'VERSION_NUMBER', TO_CHAR(version_number),
'LOCATION_CD', location_cd,
'UNIT_CLASS', unit_class,
'ENROLLED_DT', IGS_GE_DATE.IGSCHARDT(enrolled_dt),
'UNIT_ATTEMPT_STATUS', unit_attempt_status,
'ADMINISTRATIVE_UNIT_STATUS', administrative_unit_status,
'DISCONTINUED_DT', IGS_GE_DATE.IGSCHARDT(discontinued_dt),
'RULE_WAIVED_DT', IGS_GE_DATE.IGSCHARDT(rule_waived_dt),
'RULE_WAIVED_PERSON_ID', TO_CHAR(rule_waived_person_id),
'NO_ASSESSMENT_IND', no_assessment_ind,
'EXAM_LOCATION_CD', exam_location_cd,
'SUP_VERSION_NUMBER', TO_CHAR(sup_version_number),
'ALTERNATIVE_TITLE', alternative_title,
'OVERRIDE_ENROLLED_CP', TO_CHAR(override_enrolled_cp),
'OVERRIDE_EFTSU', TO_CHAR(override_eftsu),
'OVERRIDE_ACHIEVABLE_CP', TO_CHAR(override_achievable_cp),
'OVERRIDE_OUTCOME_DUE_DT', IGS_GE_DATE.IGSCHARDT(override_outcome_due_dt),
'OVERRIDE_CREDIT_REASON', override_credit_reason)
FROM IGS_EN_SU_ATTEMPT_H
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd AND
uoo_id = cp_uoo_id AND
unit_attempt_status = 'ENROLLED'
ORDER BY hist_start_dt DESC;
SELECT /*+ ROWID(IGS_EN_SU_ATTEMPT) */
unit_attempt_status,
enrolled_dt,
discontinued_dt
FROM IGS_EN_SU_ATTEMPT
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd AND
uoo_id = cp_uoo_id;
SELECT MAX(SUAH1.hist_end_dt)
FROM IGS_EN_SU_ATTEMPT_H suah1, IGS_EN_SU_ATTEMPT sua1
WHERE SUA1.person_id = SUAH1.person_id AND SUA1.course_cd = SUAH1.course_cd AND SUA1.uoo_id = SUAH1.uoo_id
AND SUAH1.person_id = cp_person_id AND SUAH1.course_cd = cp_course_cd AND SUAH1.uoo_id = cp_uoo_id
AND SUBSTR(NVL(SUAH1.unit_attempt_status, NVL(Igs_Au_Gen_003.audp_get_suah_col('UNIT_ATTEMPT_STATUS', SUAH1.person_id, SUAH1.course_cd, SUAH1.hist_end_dt, SUAH1.uoo_id ), SUA1.unit_attempt_status)),1,10)='ENROLLED' ;
SELECT unit_attempt_status,
enrolled_dt,
discontinued_dt
FROM IGS_EN_SU_ATTEMPT
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd AND
uoo_id = cp_uoo_id;
SELECT MAX(hist_start_dt)
FROM IGS_EN_SU_ATTEMPT_H
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd AND
uoo_id = cp_uoo_id AND
unit_attempt_status = 'ENROLLED';