[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(*)
FROM igs_en_su_attempt
WHERE uoo_id = p_uoo_id
AND unit_attempt_status = 'DISCONTIN' ;
SELECT COUNT(*)
FROM igs_en_su_attempt
WHERE uoo_id = p_uoo_id
AND unit_attempt_status = 'DROPPED' ;
SELECT rsv_usec_pri_id ,
rsv_usec_prf_id,
percentage_reserved
FROM igs_ps_rsv_usec_prf
WHERE rsv_usec_pri_id = cp_usec_priority_id ;
SELECT rsv_usec_pri_id
FROM igs_ps_rsv_usec_pri
WHERE uoo_id = p_uoo_id ;
SELECT NVL( NVL(usec.enrollment_maximum,uv.enrollment_maximum),0)
FROM igs_ps_usec_lim_wlst usec,
igs_ps_unit_ver uv,
igs_ps_unit_ofr_opt uoo
WHERE uoo.unit_cd = uv.unit_cd
AND uoo.version_number = uv.version_number
AND uoo.uoo_id = usec.uoo_id
AND uoo.uoo_id = p_uoo_id ;
SELECT DECODE (p_column_name,
cst_us_group_number, TO_CHAR(gach.us_group_number),
cst_order_in_presentation, TO_CHAR(gach.order_in_presentation),
cst_graduand_seat_number, gach.graduand_seat_number,
cst_name_pronunciation, gach.name_pronunciation,
cst_name_announced, gach.name_announced,
cst_academic_dress_rqrd_ind, gach.academic_dress_rqrd_ind,
cst_academic_gown_size, gach.academic_gown_size,
cst_academic_hat_size, gach.academic_hat_size,
cst_guest_tickets_requested, TO_CHAR(gach.guest_tickets_requested),
cst_guest_tickets_allocated, TO_CHAR(gach.guest_tickets_allocated),
cst_guest_seats, gach.guest_seats,
cst_fees_paid_ind, gach.fees_paid_ind,
cst_special_requirements, gach.special_requirements,
cst_comments, gach.comments)
FROM IGS_GR_AWD_CRMN_HIST gach
WHERE gach.person_id = p_person_id AND
gach.create_dt = p_create_dt AND
gach.grd_cal_type = p_grd_cal_type AND
gach.grd_ci_sequence_number = p_grd_ci_sequence_number AND
gach.ceremony_number = p_ceremony_number AND
gach.award_course_cd = p_award_course_cd AND
gach.award_crs_version_number = p_award_crs_version_number AND
gach.award_cd = p_award_cd AND
gach.hist_end_dt >= p_hist_date AND
DECODE (p_column_name,
cst_us_group_number, TO_CHAR(gach.us_group_number),
cst_order_in_presentation, TO_CHAR(gach.order_in_presentation),
cst_graduand_seat_number, gach.graduand_seat_number,
cst_name_pronunciation, gach.name_pronunciation,
cst_name_announced, gach.name_announced,
cst_academic_dress_rqrd_ind, gach.academic_dress_rqrd_ind,
cst_academic_gown_size, gach.academic_gown_size,
cst_academic_hat_size, gach.academic_hat_size,
cst_guest_tickets_requested, TO_CHAR(gach.guest_tickets_requested),
cst_guest_tickets_allocated, TO_CHAR(gach.guest_tickets_allocated),
cst_guest_seats, gach.guest_seats,
cst_fees_paid_ind, gach.fees_paid_ind,
cst_special_requirements, gach.special_requirements,
cst_comments, gach.comments) IS NOT NULL
ORDER BY
gach.hist_end_dt;
SELECT DECODE (p_column_name,
cst_course_cd, grh.course_cd,
cst_award_course_cd, grh.award_course_cd,
cst_award_crs_version_number, TO_CHAR(grh.award_crs_version_number),
cst_award_cd, grh.award_cd,
-- cst_honours_level, grh.HONOURS_LEVEL,
-- cst_conferral_dt, IGS_GE_DATE.igscharDT(grh.conferral_dt),
cst_graduand_status, grh.GRADUAND_STATUS,
cst_graduand_appr_status, grh.GRADUAND_APPR_STATUS,
cst_s_graduand_type, grh.s_graduand_type,
cst_proxy_award_ind, grh.proxy_award_ind,
cst_proxy_award_person_id, TO_CHAR(grh.proxy_award_person_id),
cst_previous_qualifications, grh.previous_qualifications,
cst_convocation_membership_ind, grh.convocation_membership_ind,
cst_sur_for_course_cd, grh.sur_for_course_cd,
cst_sur_for_crs_version_number, TO_CHAR(grh.sur_for_crs_version_number),
cst_sur_for_award_cd, grh.sur_for_award_cd,
cst_comments, grh.comments)
FROM IGS_GR_GRADUAND_HIST grh
WHERE grh.person_id = p_person_id AND
grh.create_dt = p_create_dt AND
grh.hist_start_dt >= p_hist_dt AND
DECODE (p_column_name,
cst_course_cd, grh.course_cd,
cst_award_course_cd, grh.award_course_cd,
cst_award_crs_version_number, TO_CHAR(grh.award_crs_version_number),
cst_award_cd, grh.award_cd,
-- cst_honours_level, grh.HONOURS_LEVEL,
-- cst_conferral_dt, IGS_GE_DATE.igscharDT(grh.conferral_dt),
cst_graduand_status, grh.GRADUAND_STATUS,
cst_graduand_appr_status, grh.GRADUAND_APPR_STATUS,
cst_s_graduand_type, grh.s_graduand_type,
cst_proxy_award_ind, grh.proxy_award_ind,
cst_proxy_award_person_id, TO_CHAR(grh.proxy_award_person_id),
cst_previous_qualifications, grh.previous_qualifications,
cst_convocation_membership_ind, grh.convocation_membership_ind,
cst_sur_for_course_cd, grh.sur_for_course_cd,
cst_sur_for_crs_version_number, TO_CHAR(grh.sur_for_crs_version_number),
cst_sur_for_award_cd, grh.sur_for_award_cd,
cst_comments, grh.comments)IS NOT NULL
ORDER BY grh.hist_start_dt;
SELECT
DECODE (
p_column_name,
cst_name, ih.name,
cst_inst_phone_country_code, ih.inst_phone_country_code ,
cst_inst_phone_area_code, ih.inst_phone_area_code,
cst_inst_phone_number, ih.inst_phone_number ,
cst_inst_priority_cd, ih.inst_priority_cd ,
cst_eps_code, ih.eps_code,
cst_institution_status, ih.INSTITUTION_STATUS,
cst_local_institution_ind, ih.local_institution_ind,
cst_os_ind, ih.os_ind,
cst_govt_institution_cd, ih.GOVT_INSTITUTION_CD,
cst_institution_type, ih.INSTITUTION_TYPE,
cst_description, ih.description,
cst_inst_control_type, ih.INST_CONTROL_TYPE )
FROM IGS_OR_INST_HIST_ALL ih
WHERE ih.institution_cd = p_institution_cd AND
ih.hist_start_dt >= p_hist_end_dt AND
DECODE (
p_column_name,
cst_name, ih.name,
cst_inst_phone_country_code, ih.inst_phone_country_code ,
cst_inst_phone_area_code, ih.inst_phone_area_code,
cst_inst_phone_number, ih.inst_phone_number ,
cst_inst_priority_cd, ih.inst_priority_cd,
cst_eps_code, ih.eps_code,
cst_institution_status, ih.INSTITUTION_STATUS,
cst_local_institution_ind, ih.local_institution_ind,
cst_os_ind, ih.os_ind,
cst_govt_institution_cd, ih.GOVT_INSTITUTION_CD,
cst_institution_type, ih.INSTITUTION_TYPE,
cst_description, ih.description,
cst_inst_control_type, ih.INST_CONTROL_TYPE ) IS NOT NULL
ORDER BY
ih.hist_start_dt;
SELECT
DECODE (
p_column_name,
cst_ou_end_dt, IGS_GE_DATE.igscharDT(ouh.ou_end_dt),
cst_description, ouh.description,
cst_org_status, ouh.ORG_STATUS,
cst_org_type, ouh.ORG_TYPE,
cst_member_type, ouh.MEMBER_TYPE,
cst_INSTITUTION_CD, ouh.institution_cd,
cst_name, ouh.NAME)
FROM IGS_OR_UNIT_HIST ouh
WHERE ouh.org_unit_cd = p_org_unit_cd AND
ouh.ou_start_dt = p_ou_start_dt AND
ouh.hist_start_dt >= p_hist_end_dt AND
DECODE (
p_column_name,
cst_ou_end_dt, IGS_GE_DATE.igscharDT(ouh.ou_end_dt),
cst_description, ouh.description,
cst_org_status, ouh.ORG_STATUS,
cst_org_type, ouh.ORG_TYPE,
cst_member_type, ouh.MEMBER_TYPE,
cst_INSTITUTION_CD, ouh.institution_cd,
cst_name, ouh.NAME) IS NOT NULL
ORDER BY ouh.hist_start_dt;
SELECT DECODE (p_column_name,
cst_version_number, TO_CHAR(scah.version_number),
cst_cal_type, scah.CAL_TYPE,
cst_location_cd, scah.location_cd,
cst_attendance_mode, scah.ATTENDANCE_MODE,
cst_attendance_type, scah.ATTENDANCE_TYPE,
cst_student_confirmed_ind, scah.student_confirmed_ind,
cst_commencement_dt, IGS_GE_DATE.igscharDT(scah.commencement_dt),
cst_course_attempt_status, scah.course_attempt_status,
cst_progression_status, scah.progression_status,
cst_derived_att_type, scah.derived_att_type,
cst_derived_att_mode, scah.derived_att_mode,
cst_provisional_ind, scah.provisional_ind,
cst_discontinued_dt, IGS_GE_DATE.igscharDT(scah.discontinued_dt),
cst_discontinuation_reason_cd, scah.DISCONTINUATION_REASON_CD,
cst_funding_source, scah.FUNDING_SOURCE,
cst_fs_description, scah.fs_description,
cst_exam_location_cd, scah.exam_location_cd,
cst_elo_description, scah.elo_description,
cst_derived_completion_yr, TO_CHAR(scah.derived_completion_yr),
cst_derived_completion_perd, scah.derived_completion_perd,
cst_nominated_completion_yr, TO_CHAR(scah.nominated_completion_yr),
cst_nominated_completion_perd, scah.nominated_completion_perd,
cst_rule_check_ind, scah.rule_check_ind,
cst_waive_option_check_ind, scah.waive_option_check_ind,
cst_last_rule_check_dt, IGS_GE_DATE.igscharDT(scah.last_rule_check_dt),
cst_publish_outcomes_ind, scah.publish_outcomes_ind,
cst_course_rqrmnt_complete_ind, scah.course_rqrmnt_complete_ind,
cst_course_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(scah.course_rqrmnts_complete_dt),
cst_s_completed_source_type, scah.s_completed_source_type,
cst_override_time_limitation, TO_CHAR(scah.override_time_limitation),
cst_advanced_standing_ind, scah.advanced_standing_ind,
cst_fee_cat, scah.FEE_CAT,
cst_fc_description, scah.fc_description,
cst_correspondence_cat, scah.CORRESPONDENCE_CAT,
cst_cc_description, scah.cc_description,
cst_self_help_group_ind, scah.self_help_group_ind,
cst_lapsed_dt, IGS_GE_DATE.igscharDT(scah.lapsed_dt),
cst_adm_admission_appl_number, TO_CHAR(scah.adm_admission_appl_number),
cst_adm_nominated_course_cd, scah.adm_nominated_course_cd,
cst_adm_sequence_number, TO_CHAR(scah.adm_sequence_number),
cst_last_date_of_attendance, IGS_GE_DATE.igscharDT(scah.last_date_of_attendance),
cst_dropped_by, scah.dropped_by,
cst_key_program, scah.key_program,
cst_primary_program_type, scah.primary_program_type,
cst_primary_prog_type_source, scah.primary_prog_type_source,
cst_catalog_cal_type, scah.catalog_cal_type,
cst_catalog_seq_num, TO_CHAR(scah.catalog_seq_num),
cst_manual_ovr_cmpl_dt_ind, scah.manual_ovr_cmpl_dt_ind ,
cst_override_cmpl_dt, IGS_GE_DATE.igscharDT(scah.override_cmpl_dt),
cst_coo_id, TO_CHAR(scah.coo_id),
cst_IGS_PR_CLASS_STD_ID, TO_CHAR(scah.IGS_PR_CLASS_STD_ID)
)
FROM IGS_AS_SC_ATTEMPT_H scah
WHERE scah.person_id = p_person_id AND
scah.course_cd = p_course_cd AND
scah.hist_start_dt >= p_hist_end_dt AND
DECODE (p_column_name,
cst_version_number, TO_CHAR(scah.version_number),
cst_cal_type, scah.CAL_TYPE,
cst_location_cd, scah.location_cd,
cst_attendance_mode, scah.ATTENDANCE_MODE,
cst_attendance_type, scah.ATTENDANCE_TYPE,
cst_student_confirmed_ind, scah.student_confirmed_ind,
cst_commencement_dt, IGS_GE_DATE.igscharDT(scah.commencement_dt),
cst_course_attempt_status, scah.course_attempt_status,
cst_progression_status, scah.progression_status,
cst_derived_att_type, scah.derived_att_type,
cst_derived_att_mode, scah.derived_att_mode,
cst_provisional_ind, scah.provisional_ind,
cst_discontinued_dt, IGS_GE_DATE.igscharDT(scah.discontinued_dt),
cst_discontinuation_reason_cd, scah.DISCONTINUATION_REASON_CD,
cst_funding_source, scah.FUNDING_SOURCE,
cst_fs_description, scah.fs_description,
cst_exam_location_cd, scah.exam_location_cd,
cst_elo_description, scah.elo_description,
cst_derived_completion_yr, TO_CHAR(scah.derived_completion_yr),
cst_derived_completion_perd, scah.derived_completion_perd,
cst_nominated_completion_yr, TO_CHAR(scah.nominated_completion_yr),
cst_nominated_completion_perd, scah.nominated_completion_perd,
cst_rule_check_ind, scah.rule_check_ind,
cst_waive_option_check_ind, scah.waive_option_check_ind,
cst_last_rule_check_dt, IGS_GE_DATE.igscharDT(scah.last_rule_check_dt),
cst_publish_outcomes_ind, scah.publish_outcomes_ind,
cst_course_rqrmnt_complete_ind, scah.course_rqrmnt_complete_ind,
cst_course_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(scah.course_rqrmnts_complete_dt),
cst_s_completed_source_type, scah.s_completed_source_type,
cst_override_time_limitation, TO_CHAR(scah.override_time_limitation),
cst_advanced_standing_ind, scah.advanced_standing_ind,
cst_fee_cat, scah.FEE_CAT,
cst_fc_description, scah.fc_description,
cst_correspondence_cat, scah.CORRESPONDENCE_CAT,
cst_cc_description, scah.cc_description,
cst_self_help_group_ind, scah.self_help_group_ind,
cst_lapsed_dt, IGS_GE_DATE.igscharDT(scah.lapsed_dt),
cst_adm_admission_appl_number, TO_CHAR(scah.adm_admission_appl_number),
cst_adm_nominated_course_cd, scah.adm_nominated_course_cd,
cst_adm_sequence_number, TO_CHAR(scah.adm_sequence_number),
cst_last_date_of_attendance, IGS_GE_DATE.igscharDT(scah.last_date_of_attendance),
cst_dropped_by, scah.dropped_by ,
cst_key_program , scah.key_program,
cst_primary_program_type, scah.primary_program_type,
cst_primary_prog_type_source, scah.primary_prog_type_source,
cst_catalog_cal_type, scah.catalog_cal_type,
cst_catalog_seq_num, TO_CHAR(scah.catalog_seq_num),
cst_manual_ovr_cmpl_dt_ind, scah.manual_ovr_cmpl_dt_ind,
cst_override_cmpl_dt, IGS_GE_DATE.igscharDT(scah.override_cmpl_dt),
cst_coo_id, TO_CHAR(scah.coo_id),
cst_IGS_PR_CLASS_STD_ID, TO_CHAR(scah.IGS_PR_CLASS_STD_ID)
) IS NOT NULL
ORDER BY scah.hist_start_dt;
SELECT
DECODE (
p_column_name,
cst_date_submission, IGS_GE_DATE.igscharDT(sph.date_submission),
cst_reason_for_request, sph.reason_for_request,
cst_instructor_more_info, sph.instructor_more_info,
cst_instructor_deny_info, sph.instructor_deny_info,
cst_student_more_info, sph.student_more_info,
cst_approval_status, sph.approval_status,
cst_audit_the_course, sph.audit_the_course,
cst_transaction_type, sph.transaction_type
)
FROM IGS_EN_SPL_PERM_H sph
WHERE sph.spl_perm_request_h_id = p_spl_perm_request_h_id AND
sph.hist_start_dt >= p_hist_end_dt AND
DECODE (
p_column_name,
cst_date_submission, IGS_GE_DATE.igscharDT(sph.date_submission),
cst_reason_for_request, sph.reason_for_request,
cst_instructor_more_info, sph.instructor_more_info,
cst_instructor_deny_info, sph.instructor_deny_info,
cst_student_more_info, sph.student_more_info,
cst_approval_status, sph.approval_status,
cst_audit_the_course, sph.audit_the_course,
cst_transaction_type, sph.transaction_type
) IS NOT NULL
ORDER BY sph.hist_start_dt;
SELECT DECODE (p_column_name,
cst_version_number, TO_CHAR(suah.version_number),
cst_location_cd, suah.location_cd,
cst_unit_class, suah.UNIT_CLASS,
cst_enrolled_dt, IGS_GE_DATE.igscharDT(suah.enrolled_dt),
cst_unit_attempt_status, suah.unit_attempt_status,
cst_administrative_unit_status, suah.ADMINISTRATIVE_UNIT_STATUS,
cst_aus_description, suah.aus_description,
cst_discontinued_dt, IGS_GE_DATE.igscharDT(suah.discontinued_dt),
cst_rule_waived_dt, IGS_GE_DATE.igscharDT(suah.rule_waived_dt),
cst_rule_waived_person_id, TO_CHAR(suah.rule_waived_person_id),
cst_no_assessment_ind, suah.no_assessment_ind,
cst_exam_location_cd, suah.exam_location_cd,
cst_elo_description, suah.elo_description,
cst_sup_unit_cd, suah.sup_unit_cd,
cst_sup_version_number, TO_CHAR(suah.sup_version_number),
cst_alternative_title, suah.alternative_title,
cst_override_enrolled_cp, TO_CHAR(suah.override_enrolled_cp),
cst_override_eftsu, TO_CHAR(suah.override_eftsu),
cst_override_achievable_cp, TO_CHAR(suah.override_achievable_cp),
cst_override_outcome_due_dt, IGS_GE_DATE.igscharDT(suah.override_outcome_due_dt),
cst_override_credit_reason, suah.override_credit_reason,
cst_grading_schema_code, suah.grading_schema_code,
cst_enr_method_type, suah.enr_method_type,
--added by rvangala 01-OCT-2003. Enh Bug# 3052432
cst_core_indicator, suah.core_indicator_code)
FROM IGS_EN_SU_ATTEMPT_H suah
WHERE suah.person_id = p_person_id AND
suah.course_cd = p_course_cd AND
suah.uoo_id = p_uoo_id AND
suah.hist_start_dt >= p_hist_end_dt AND
DECODE (p_column_name,
cst_version_number, TO_CHAR(suah.version_number),
cst_location_cd, suah.location_cd,
cst_unit_class, suah.UNIT_CLASS,
cst_enrolled_dt, TO_CHAR(suah.enrolled_dt),
cst_unit_attempt_status, suah.unit_attempt_status,
cst_administrative_unit_status, suah.ADMINISTRATIVE_UNIT_STATUS,
cst_aus_description, suah.aus_description,
cst_discontinued_dt, TO_CHAR(suah.discontinued_dt),
cst_rule_waived_dt, TO_CHAR(suah.rule_waived_dt),
cst_rule_waived_person_id, TO_CHAR(suah.rule_waived_person_id),
cst_no_assessment_ind, suah.no_assessment_ind,
cst_exam_location_cd, suah.exam_location_cd,
cst_elo_description, suah.elo_description,
cst_sup_unit_cd, suah.sup_unit_cd,
cst_sup_version_number, TO_CHAR(suah.sup_version_number),
cst_alternative_title, suah.alternative_title,
cst_override_enrolled_cp, TO_CHAR(suah.override_enrolled_cp),
cst_override_eftsu, TO_CHAR(suah.override_eftsu),
cst_override_achievable_cp, TO_CHAR(suah.override_achievable_cp),
cst_override_outcome_due_dt, TO_CHAR(suah.override_outcome_due_dt),
cst_override_credit_reason, suah.override_credit_reason,
cst_grading_schema_code, suah.grading_schema_code,
cst_enr_method_type, suah.enr_method_type,
--added by rvangala 01-OCT-2003. Enh Bug# 3052432
cst_core_indicator, suah.core_indicator_code) IS NOT NULL
ORDER BY
suah.hist_start_dt ;
SELECT
DECODE (
p_column_name,
cst_grading_schema_cd, suaoh.grading_schema_cd,
cst_version_number, TO_CHAR(suaoh.version_number),
cst_grade, suaoh.grade,
cst_s_grade_creatn_method_type, suaoh.s_grade_creation_method_type,
cst_finalised_outcome_ind, suaoh.finalised_outcome_ind,
cst_mark, TO_CHAR(suaoh.mark),
cst_number_times_keyed, TO_CHAR(suaoh.number_times_keyed),
cst_trnslted_grading_schema_cd, suaoh.translated_grading_schema_cd,
cst_translated_version_no, TO_CHAR(suaoh.translated_version_number),
cst_translated_grade, suaoh.translated_grade,
cst_translated_dt, TO_CHAR(suaoh.translated_dt))
FROM IGS_AS_SU_ATMPTOUT_H suaoh
WHERE suaoh.person_id = p_person_id AND
suaoh.course_cd = p_course_cd AND
suaoh.uoo_id = p_uoo_id AND
suaoh.outcome_dt = p_outcome_dt AND
suaoh.hist_start_dt >= p_hist_end_dt AND
DECODE (
p_column_name,
cst_grading_schema_cd, suaoh.grading_schema_cd,
cst_version_number, TO_CHAR(suaoh.version_number),
cst_grade, suaoh.grade,
cst_s_grade_creatn_method_type, suaoh.s_grade_creation_method_type,
cst_finalised_outcome_ind, suaoh.finalised_outcome_ind,
cst_mark, TO_CHAR(suaoh.mark),
cst_number_times_keyed, TO_CHAR(suaoh.number_times_keyed),
cst_trnslted_grading_schema_cd, suaoh.translated_grading_schema_cd,
cst_translated_version_no, TO_CHAR(suaoh.translated_version_number),
cst_translated_grade, suaoh.translated_grade,
cst_translated_dt, TO_CHAR(suaoh.translated_dt)) IS NOT NULL
ORDER BY suaoh.hist_start_dt;
cst_selection_dt VARCHAR2(12) := 'SELECTION_DT';
SELECT
DECODE (
p_column_name,
cst_us_version_number, TO_CHAR(susah.us_version_number),
cst_selection_dt, IGS_GE_DATE.igscharDT(susah.selection_dt),
cst_student_confirmed_ind, susah.student_confirmed_ind,
cst_end_dt, IGS_GE_DATE.igscharDT(susah.end_dt),
cst_parent_unit_set_cd, susah.parent_unit_set_cd,
cst_parent_sequence_number, TO_CHAR(susah.parent_sequence_number),
cst_primary_set_ind, susah.primary_set_ind,
cst_voluntary_end_ind, susah.voluntary_end_ind,
cst_authorised_person_id, TO_CHAR(susah.authorised_person_id),
cst_authorised_on, TO_CHAR(susah.authorised_on),
cst_override_title, susah.override_title,
cst_rqrmnts_complete_ind, susah.rqrmnts_complete_ind,
cst_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(susah.rqrmnts_complete_dt),
cst_s_completed_source_type, susah.s_completed_source_type,
cst_catalog_cal_type, susah.catalog_cal_type ,
cst_catalog_seq_num, TO_CHAR(susah.catalog_seq_num) )
FROM IGS_AS_SU_SETATMPT_H susah
WHERE susah.person_id = p_person_id AND
susah.course_cd = p_course_cd AND
susah.unit_set_cd = p_unit_set_cd AND
susah.sequence_number = p_sequence_number AND
susah.hist_start_dt >= p_hist_end_dt AND
DECODE (
p_column_name,
cst_us_version_number, TO_CHAR(susah.us_version_number),
cst_selection_dt, IGS_GE_DATE.igscharDT(susah.selection_dt),
cst_student_confirmed_ind, susah.student_confirmed_ind,
cst_end_dt, IGS_GE_DATE.igscharDT(susah.end_dt),
cst_parent_unit_set_cd, susah.parent_unit_set_cd,
cst_parent_sequence_number, TO_CHAR(susah.parent_sequence_number),
cst_primary_set_ind, susah.primary_set_ind,
cst_voluntary_end_ind, susah.voluntary_end_ind,
cst_authorised_person_id, TO_CHAR(susah.authorised_person_id),
cst_authorised_on, IGS_GE_DATE.igscharDT(susah.authorised_on),
cst_override_title, susah.override_title,
cst_rqrmnts_complete_ind, susah.rqrmnts_complete_ind,
cst_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(susah.rqrmnts_complete_dt),
cst_s_completed_source_type, susah.s_completed_source_type,
cst_catalog_cal_type, susah.catalog_cal_type ,
cst_catalog_seq_num, TO_CHAR(susah.catalog_seq_num) ) IS NOT NULL
ORDER BY susah.hist_start_dt;
SELECT rule_waived_person_id
FROM IGS_EN_SU_ATTEMPT
WHERE person_id=p_person_id AND
course_cd = p_course_cd AND
uoo_id = p_uoo_id;