The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT trh.percentage
FROM IGS_PS_TCH_RESP_HIST trh
WHERE trh.unit_cd = p_unit_cd AND
trh.version_number = p_version_number AND
trh.org_unit_cd = p_org_unit_cd AND
trh.ou_start_dt = p_ou_start_dt AND
trh.hist_start_dt >=p_hist_date AND
trh.percentage IS NOT NULL
ORDER BY trh.hist_start_dt;
SELECT troh.percentage
FROM IGS_PS_TCH_RSOV_HIST troh
WHERE troh.unit_cd = p_unit_cd AND
troh.version_number = p_version_number AND
troh.cal_type = p_cal_type AND
troh.ci_sequence_number = p_ci_sequence_number AND
troh.location_cd = p_location_cd AND
troh.unit_class = p_unit_class AND
troh.org_unit_cd = p_org_unit_cd AND
troh.ou_start_dt = p_ou_start_dt AND
troh.hist_start_dt >= p_hist_date AND
troh.percentage IS NOT NULL
ORDER BY troh.hist_start_dt;
SELECT udh.percentage
FROM igs_ps_unt_dscp_hist udh
WHERE udh.unit_cd = p_unit_cd AND
udh.version_number = p_version_number AND
udh.discipline_group_cd = p_discipline_group_cd AND
udh.hist_start_dt >= p_hist_date AND
udh.percentage IS NOT NULL
ORDER BY udh.percentage;
SELECT DECODE (p_column_name,
cst_description, uiclh.description,
cst_weftsu_factor, TO_CHAR(uiclh.weftsu_factor),
cst_closed_ind, uiclh.closed_ind)
FROM IGS_PS_UNT_INLV_HIST uiclh
WHERE uiclh.unit_int_course_level_cd = p_unit_int_course_level_cd AND
uiclh.hist_start_dt >= p_hist_end_dt AND
DECODE (p_column_name,
cst_description, uiclh.description,
cst_weftsu_factor, TO_CHAR(uiclh.weftsu_factor),
cst_closed_ind, uiclh.closed_ind) IS NOT NULL
ORDER BY
uiclh.hist_start_dt;
SELECT urch.description
FROM IGS_PS_UNIT_REF_HIST urch
WHERE urch.unit_cd = p_unit_cd AND
urch.version_number = p_version_number AND
urch.reference_cd_type = p_reference_cd_type AND
urch.reference_cd = p_reference_cd AND
urch.hist_start_dt >= p_hist_date AND
urch.description IS NOT NULL
ORDER BY urch.hist_start_dt;
SELECT DECODE (p_column_name,
'UNIT_SET_STATUS', ush.UNIT_SET_STATUS,
'UNIT_SET_CAT', ush.UNIT_SET_CAT,
'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),
'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),
'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),
'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),
'TITLE', ush.TITLE,
'SHORT_TITLE', ush.short_title,
'ABBREVIATION', ush.abbreviation,
'RESPONSIBLE_ORG_UNIT_CD', ush.responsible_org_unit_cd,
'RESPONSIBLE_OU_START_DT', IGS_GE_DATE.igscharDT(ush.responsible_ou_start_dt),
'OU_DESCRIPTION', ush.ou_description,
'ADMINISTRATIVE_IND', ush.administrative_ind,
'AUTHORISATION_RQRD_IND', ush.authorisation_rqrd_ind)
FROM IGS_EN_UNIT_SET_HIST ush
WHERE ush.unit_set_cd = p_unit_set_cd AND
ush.version_number = p_version_number AND
ush.hist_start_dt >= p_hist_end_dt AND
DECODE (p_column_name,
'UNIT_SET_STATUS', ush.UNIT_SET_STATUS,
'UNIT_SET_CAT', ush.UNIT_SET_CAT,
'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),
'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),
'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),
'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),
'TITLE', ush.TITLE,
'SHORT_TITLE', ush.short_title,
'ABBREVIATION', ush.abbreviation,
'RESPONSIBLE_ORG_UNIT_CD', ush.responsible_org_unit_cd,
'RESPONSIBLE_OU_START_DT', IGS_GE_DATE.igscharDT(ush.responsible_ou_start_dt),
'OU_DESCRIPTION', ush.ou_description,
'ADMINISTRATIVE_IND', ush.administrative_ind,
'AUTHORISATION_RQRD_IND', ush.authorisation_rqrd_ind) IS NOT NULL
ORDER BY ush.hist_start_dt;
SELECT DECODE (p_column_name,
cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),
cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),
cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),
cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),
cst_unit_status, uvh.UNIT_STATUS,
cst_title, uvh.TITLE,
cst_short_title, uvh.short_title,
cst_title_override_ind, uvh.title_override_ind,
cst_abbreviation, uvh.abbreviation,
cst_unit_level, uvh.UNIT_LEVEL,
cst_ul_description, uvh.ul_description,
cst_credit_point_descriptor, uvh.CREDIT_POINT_DESCRIPTOR,
cst_enrolled_credit_points, TO_CHAR(uvh.enrolled_credit_points),
cst_points_override_ind, uvh.points_override_ind,
cst_supp_exam_permitted_ind, uvh.supp_exam_permitted_ind,
cst_coord_person_id, TO_CHAR(uvh.coord_person_id),
cst_owner_org_unit_cd, uvh.owner_org_unit_cd,
cst_owner_ou_start_dt, IGS_GE_DATE.igscharDT(uvh.owner_ou_start_dt),
cst_ou_description, uvh.ou_description,
cst_award_course_only_ind, uvh.award_course_only_ind,
cst_research_unit_ind, uvh.research_unit_ind,
cst_industrial_ind, uvh.industrial_ind,
cst_practical_ind, uvh.practical_ind,
cst_repeatable_ind, uvh.repeatable_ind,
cst_assessable_ind, uvh.assessable_ind,
cst_achievable_credit_points, TO_CHAR(uvh.achievable_credit_points),
cst_points_increment, TO_CHAR(uvh.points_increment),
cst_points_min, TO_CHAR(uvh.points_min),
cst_points_max, TO_CHAR(uvh.points_max),
cst_unit_int_course_level_cd, uvh.unit_int_course_level_cd,
cst_uicl_description, uvh.uicl_description,
cst_advance_maximum, TO_CHAR(uvh.advance_maximum),
cst_approval_date, IGS_GE_DATE.igscharDT( uvh.approval_date ),
cst_cal_type_enrol_load_cal, uvh.cal_type_enrol_load_cal,
cst_cal_type_offer_load_cal, uvh.cal_type_offer_load_cal,
cst_clock_hours, TO_CHAR(uvh.clock_hours),
cst_contact_hrs_lab, TO_CHAR(uvh.contact_hrs_lab),
cst_contact_hrs_lecture, TO_CHAR(uvh.contact_hrs_lecture),
cst_contact_hrs_other, TO_CHAR(uvh.contact_hrs_other),
cst_continuing_education_units, TO_CHAR(uvh.continuing_education_units),
cst_curriculum_id, uvh.curriculum_id,
cst_enrollment_expected, TO_CHAR(uvh.enrollment_expected),
cst_enrollment_maximum, TO_CHAR(uvh.enrollment_maximum),
cst_enrollment_minimum, TO_CHAR(uvh.enrollment_minimum),
cst_exclude_from_max_cp_limit, uvh.exclude_from_max_cp_limit,
cst_federal_financial_aid, uvh.federal_financial_aid,
c_institutional_financial_aid, uvh.institutional_financial_aid,
cst_lab_credit_points, TO_CHAR(uvh.lab_credit_points),
cst_lecture_credit_points, TO_CHAR(uvh.lecture_credit_points),
cst_level_code, uvh.level_code,
cst_max_repeat_credit_points, TO_CHAR(uvh.max_repeat_credit_points),
cst_max_repeats_for_credit, TO_CHAR(uvh.max_repeats_for_credit),
cst_max_repeats_for_funding, TO_CHAR(uvh.max_repeats_for_funding),
cst_non_schd_required_hrs, TO_CHAR(uvh.non_schd_required_hrs),
cst_other_credit_points, TO_CHAR(uvh.other_credit_points),
cst_override_enrollment_max, TO_CHAR(uvh.override_enrollment_max),
cst_record_exclusion_flag, uvh.record_exclusion_flag,
c_ss_display_ind, uvh.ss_display_ind,
cst_repeat_code, uvh.repeat_code,
cst_rpt_fmly_id, TO_CHAR(uvh.rpt_fmly_id),
cst_same_teach_period_repeats, TO_CHAR(uvh.same_teach_period_repeats),
c_same_teach_period_repeats_cp, TO_CHAR(uvh.same_teach_period_repeats_cp),
cst_same_teaching_period, uvh.same_teaching_period,
c_sequence_num_enrol_load_cal, TO_CHAR(uvh.sequence_num_enrol_load_cal),
c_sequence_num_offer_load_cal, TO_CHAR(uvh.sequence_num_offer_load_cal),
cst_special_permission_ind, uvh.special_permission_ind,
cst_state_financial_aid, uvh.state_financial_aid,
cst_subtitle, uvh.subtitle,
cst_subtitle_id, TO_CHAR(uvh.subtitle_id),
cst_subtitle_modifiable_flag, uvh.subtitle_modifiable_flag,
cst_unit_type_id, TO_CHAR(uvh.unit_type_id),
cst_work_load_cp_lab, TO_CHAR(uvh.work_load_cp_lab),
cst_work_load_cp_lecture, TO_CHAR(uvh.work_load_cp_lecture),
cst_work_load_other, TO_CHAR(uvh.work_load_other) ,
cst_claimable_hours, TO_CHAR(uvh.claimable_hours),
cst_auditable_ind, uvh.auditable_ind,
cst_audit_permission_ind, uvh.audit_permission_ind,
cst_max_auditors_allowed, TO_CHAR(uvh.max_auditors_allowed),
l_c_billing_credit_points, TO_CHAR(uvh.billing_credit_points),
l_c_ovrd_wkld_val_flag, uvh.ovrd_wkld_val_flag,
l_c_workload_val_code, uvh.workload_val_code,
l_c_billing_hrs, TO_CHAR(uvh.billing_hrs)
)
FROM IGS_PS_UNIT_VER_HIST uvh
WHERE uvh.unit_cd = p_unit_cd AND
uvh.version_number = p_version_number AND
uvh.hist_start_dt >= p_hist_date AND
DECODE (p_column_name,
cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),
cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),
cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),
cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),
cst_unit_status, uvh.UNIT_STATUS,
cst_title, uvh.TITLE,
cst_short_title, uvh.short_title,
cst_title_override_ind, uvh.title_override_ind,
cst_abbreviation, uvh.abbreviation,
cst_unit_level, uvh.UNIT_LEVEL,
cst_ul_description, uvh.ul_description,
cst_credit_point_descriptor, uvh.CREDIT_POINT_DESCRIPTOR,
cst_enrolled_credit_points, TO_CHAR(uvh.enrolled_credit_points),
cst_points_override_ind, uvh.points_override_ind,
cst_supp_exam_permitted_ind, uvh.supp_exam_permitted_ind,
cst_coord_person_id, TO_CHAR(uvh.coord_person_id),
cst_owner_org_unit_cd, uvh.owner_org_unit_cd,
cst_owner_ou_start_dt, IGS_GE_DATE.igscharDT(uvh.owner_ou_start_dt),
cst_ou_description, uvh.ou_description,
cst_award_course_only_ind, uvh.award_course_only_ind,
cst_research_unit_ind, uvh.research_unit_ind,
cst_industrial_ind, uvh.industrial_ind,
cst_practical_ind, uvh.practical_ind,
cst_repeatable_ind, uvh.repeatable_ind,
cst_assessable_ind, uvh.assessable_ind,
cst_achievable_credit_points, TO_CHAR(uvh.achievable_credit_points),
cst_points_increment, TO_CHAR(uvh.points_increment),
cst_points_min, TO_CHAR(uvh.points_min),
cst_points_max, TO_CHAR(uvh.points_max),
cst_unit_int_course_level_cd, uvh.unit_int_course_level_cd,
cst_uicl_description, uvh.uicl_description,
cst_advance_maximum, TO_CHAR(uvh.advance_maximum),
cst_approval_date, IGS_GE_DATE.igscharDT( uvh.approval_date ),
cst_cal_type_enrol_load_cal, uvh.cal_type_enrol_load_cal,
cst_cal_type_offer_load_cal, uvh.cal_type_offer_load_cal,
cst_clock_hours, TO_CHAR(uvh.clock_hours),
cst_contact_hrs_lab, TO_CHAR(uvh.contact_hrs_lab),
cst_contact_hrs_lecture, TO_CHAR(uvh.contact_hrs_lecture),
cst_contact_hrs_other, TO_CHAR(uvh.contact_hrs_other),
cst_continuing_education_units, TO_CHAR(uvh.continuing_education_units),
cst_curriculum_id, uvh.curriculum_id,
cst_enrollment_expected, TO_CHAR(uvh.enrollment_expected),
cst_enrollment_maximum, TO_CHAR(uvh.enrollment_maximum),
cst_enrollment_minimum, TO_CHAR(uvh.enrollment_minimum),
cst_exclude_from_max_cp_limit, uvh.exclude_from_max_cp_limit,
cst_federal_financial_aid, uvh.federal_financial_aid,
c_institutional_financial_aid, uvh.institutional_financial_aid,
cst_lab_credit_points, TO_CHAR(uvh.lab_credit_points),
cst_lecture_credit_points, TO_CHAR(uvh.lecture_credit_points),
cst_level_code, uvh.level_code,
cst_max_repeat_credit_points, TO_CHAR(uvh.max_repeat_credit_points),
cst_max_repeats_for_credit, TO_CHAR(uvh.max_repeats_for_credit),
cst_max_repeats_for_funding, TO_CHAR(uvh.max_repeats_for_funding),
cst_non_schd_required_hrs, TO_CHAR(uvh.non_schd_required_hrs),
cst_other_credit_points, TO_CHAR(uvh.other_credit_points),
cst_override_enrollment_max, TO_CHAR(uvh.override_enrollment_max),
cst_record_exclusion_flag, uvh.record_exclusion_flag,
c_ss_display_ind, uvh.ss_display_ind,
cst_repeat_code, uvh.repeat_code,
cst_rpt_fmly_id, TO_CHAR(uvh.rpt_fmly_id),
cst_same_teach_period_repeats, TO_CHAR(uvh.same_teach_period_repeats),
c_same_teach_period_repeats_cp, TO_CHAR(uvh.same_teach_period_repeats_cp),
cst_same_teaching_period, uvh.same_teaching_period,
c_sequence_num_enrol_load_cal, TO_CHAR(uvh.sequence_num_enrol_load_cal),
c_sequence_num_offer_load_cal, TO_CHAR(uvh.sequence_num_offer_load_cal),
cst_special_permission_ind, uvh.special_permission_ind,
cst_state_financial_aid, uvh.state_financial_aid,
cst_subtitle, uvh.subtitle,
cst_subtitle_id, TO_CHAR(uvh.subtitle_id),
cst_subtitle_modifiable_flag, uvh.subtitle_modifiable_flag,
cst_unit_type_id, TO_CHAR(uvh.unit_type_id),
cst_work_load_cp_lab, TO_CHAR(uvh.work_load_cp_lab),
cst_work_load_cp_lecture, TO_CHAR(uvh.work_load_cp_lecture),
cst_work_load_other, TO_CHAR(uvh.work_load_other),
cst_claimable_hours, TO_CHAR(uvh.claimable_hours),
cst_auditable_ind, uvh.auditable_ind,
cst_audit_permission_ind, uvh.audit_permission_ind,
cst_max_auditors_allowed, TO_CHAR(uvh.max_auditors_allowed),
l_c_billing_credit_points, TO_CHAR(uvh.billing_credit_points),
l_c_ovrd_wkld_val_flag, uvh.ovrd_wkld_val_flag,
l_c_workload_val_code, uvh.workload_val_code,
l_c_billing_hrs, uvh.billing_hrs
) IS NOT NULL
ORDER BY hist_start_dt;