[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT version_number,
cal_type,
location_cd,
attendance_mode,
attendance_type
FROM igs_en_stdnt_ps_att
WHERE person_id = p_person_id AND
course_cd = cp_course_cd;
SELECT max(sequence_number)
FROM igs_as_su_setatmpt
WHERE person_id = p_person_id AND
course_cd = cp_course_cd AND
unit_set_cd = cp_unit_set_cd AND
us_version_number = cp_us_version_number;
SELECT disability_allow,
additional_sup_band,
sldd_discrete_prov,
credit_level_achieved1,
credit_level_achieved2,
credit_pt_achieved1,
credit_pt_achieved2,
fee_eligibility,
non_payment_reason,
calculated_fte ,
term_time_accom,
study_mode,
franchising_activity,
fte_perc_override,
completion_status,
good_stand_marker,
complete_pyr_study_cd,
grad_sch_grade,
mark,
fundability_code,
fee_band ,
fte_intensity,
fte_calc_type,
type_of_year,
new_he_entrant_cd,
credit_level_achieved3,
credit_level_achieved4,
credit_pt_achieved3,
credit_pt_achieved4,
additional_sup_cost,
enh_fund_elig_cd,
disadv_uplift_factor,
year_stu
FROM igs_he_en_susa
WHERE person_id = p_person_id AND
course_cd = p_old_course_cd AND
unit_set_cd = p_old_unit_set_cd AND
us_version_number = p_old_us_version_number AND
sequence_number = v_u_old_sequence_number;
SELECT attendance_type,
franchising_activity,
fte_intensity,
fte_calc_type,
grading_schema_cd,
gs_version_number,
fee_band,
type_of_year,
fundability_cd,
funding_source
FROM igs_he_poous_all
WHERE course_cd = p_old_course_cd AND
unit_set_cd = p_old_unit_set_cd AND
us_version_number = p_old_us_version_number AND
crv_version_number = v_u_old_version_number AND
cal_type = v_u_old_cal_type AND
location_cd = v_u_old_location_cd AND
attendance_mode = v_u_old_attendance_mode AND
attendance_type = v_u_old_attendance_type;
SELECT map1
FROM igs_ps_award, igs_he_code_map_val
WHERE course_cd = cp_course_cd AND
version_number = cp_version_number AND
closed_ind = 'N' AND
map2 = award_cd AND
association_code = 'OSS_HESA_AWD_ASSOC'
ORDER BY default_ind DESC, map1 ASC ;
SELECT funding_source
FROM igs_fi_fnd_src_rstn
WHERE course_cd = cp_course_cd AND
version_number = cp_version_number AND
dflt_ind = 'Y';
SELECT attendance_type,
franchising_activity,
fte_intensity,
fte_calc_type,
grading_schema_cd,
gs_version_number,
fee_band,type_of_year,
fundability_cd,
funding_source
FROM igs_he_poous_all
WHERE course_cd = p_new_course_cd AND
crv_version_number = v_u_new_version_number AND
cal_type = v_u_new_cal_type AND
location_cd = v_u_new_location_cd AND
attendance_mode = v_u_new_attendance_mode AND
attendance_type = v_u_new_attendance_type AND
unit_set_cd = p_new_unit_set_cd AND
us_version_number = p_new_us_version_number ;
SELECT map1
FROM igs_he_code_map_val
WHERE association_code = 'OSS_HESA_TTA_ASSOC' AND
map2 = (select term_time_accom
from igs_he_en_susa
where person_id = p_person_id AND
course_cd = p_old_course_cd AND
unit_set_cd = p_old_unit_set_cd AND
us_version_number = p_old_us_version_number);
SELECT fundability
FROM IGS_he_st_prog_all
WHERE course_cd = cp_course_cd AND
version_number = cp_version_number ;
SELECT b.course_group_cd
FROM igs_ps_grp_type a, igs_ps_grp_all b, igs_ps_grp_mbr c , igs_ps_grp_mbr d
WHERE a.course_group_type = b.course_group_type AND
a.closed_ind = 'N' AND
a.s_course_group_type = 'CONTINUOUS' AND
b.course_group_cd = c.course_group_cd AND
b.closed_ind = 'N' AND
c.course_cd = p_old_course_cd AND
c.version_number = v_u_old_version_number AND
b.course_group_cd = d.course_group_cd AND
d.course_cd = p_new_course_cd AND
d.version_number = v_u_new_version_number ;
SELECT susa.*
FROM igs_he_en_susa_cc susa
WHERE susa.person_id = cp_person_id
AND susa.course_cd = cp_course_cd
AND susa.unit_set_cd = cp_unit_set_cd
AND susa.sequence_number = cp_sequence_number;
SELECT 'X'
FROM igs_he_en_susa_cc susa
WHERE susa.person_id = cp_person_id
AND susa.course_cd = cp_course_cd
AND susa.unit_set_cd = cp_unit_set_cd
AND susa.sequence_number = cp_sequence_number
AND susa.cost_centre = cp_cost_centre
AND susa.subject = cp_subject;
igs_he_en_susa_pkg.insert_row(
x_rowid => v_rowid,
x_hesa_en_susa_id => v_hesa_en_susa_id,
x_person_id => p_person_id,
x_course_cd => p_new_course_cd,
x_unit_set_cd => p_new_unit_set_cd,
x_us_version_number => p_new_us_version_number,
x_sequence_number => v_u_new_sequence_number,
x_new_he_entrant_cd => NULL,
x_term_time_accom => NULL ,
x_disability_allow => NULL ,
x_additional_sup_band => NULL,
x_sldd_discrete_prov => NULL ,
x_study_mode => NULL ,
x_study_location => NULL,
x_fte_perc_override => NULL,
x_franchising_activity => NULL,
x_completion_status => NULL ,
x_good_stand_marker => NULL ,
x_complete_pyr_study_cd => NULL ,
x_credit_value_yop1 => NULL,
x_credit_value_yop2 => NULL,
x_credit_level_achieved1 => NULL ,
x_credit_level_achieved2 => NULL ,
x_credit_pt_achieved1 => NULL ,
x_credit_pt_achieved2 => NULL ,
x_credit_level1 => NULL,
x_credit_level2 => NULL,
x_grad_sch_grade => NULL ,
x_mark => NULL ,
x_teaching_inst1 => NULL,
x_teaching_inst2 => NULL,
x_pro_not_taught => NULL,
x_fundability_code => NULL ,
x_fee_eligibility => NULL ,
x_fee_band => NULL ,
x_non_payment_reason => NULL,
x_student_fee => NULL,
x_fte_intensity => NULL ,
x_fte_calc_type => NULL ,
x_calculated_fte => NULL ,
x_type_of_year => NULL,
x_mode => 'R',
x_credit_value_yop3 => NULL,
x_credit_value_yop4 => NULL,
x_credit_level_achieved3 => NULL,
x_credit_level_achieved4 => NULL,
x_credit_pt_achieved3 => NULL,
x_credit_pt_achieved4 => NULL,
x_credit_level3 => NULL,
x_credit_level4 => NULL,
x_additional_sup_cost => NULL,
x_enh_fund_elig_cd => NULL,
x_disadv_uplift_factor => NULL,
x_year_stu => NULL);
igs_he_en_susa_pkg.insert_row(
x_rowid => v_rowid,
x_hesa_en_susa_id => v_hesa_en_susa_id,
x_person_id => p_person_id,
x_course_cd => p_new_course_cd,
x_unit_set_cd => p_new_unit_set_cd,
x_us_version_number => p_new_us_version_number,
x_sequence_number => v_u_new_sequence_number,
x_new_he_entrant_cd => v_new_he_entrant_cd,
x_term_time_accom => v_term_time_accom,
x_disability_allow => c_old_susa_rec.disability_allow,
x_additional_sup_band => c_old_susa_rec.additional_sup_band,
x_sldd_discrete_prov => c_old_susa_rec.sldd_discrete_prov,
x_study_mode => v_study_mode,
x_study_location => NULL,
x_fte_perc_override => NULL,
x_franchising_activity => v_franchising_activity,
x_completion_status => v_completion_status,
x_good_stand_marker => v_good_stand_marker,
x_complete_pyr_study_cd => v_complete_pyr_study_cd,
x_credit_value_yop1 => NULL,
x_credit_value_yop2 => NULL,
x_credit_level_achieved1 => c_old_susa_rec.credit_level_achieved1,
x_credit_level_achieved2 => c_old_susa_rec.credit_level_achieved2,
x_credit_pt_achieved1 => c_old_susa_rec.credit_pt_achieved1,
x_credit_pt_achieved2 => c_old_susa_rec.credit_pt_achieved2,
x_credit_level1 => NULL,
x_credit_level2 => NULL,
x_grad_sch_grade => v_grad_sch_grade,
x_mark => v_mark,
x_teaching_inst1 => NULL,
x_teaching_inst2 => NULL,
x_pro_not_taught => NULL,
x_fundability_code => v_fundability_code,
x_fee_eligibility => c_old_susa_rec.fee_eligibility,
x_fee_band => v_fee_band,
x_non_payment_reason => c_old_susa_rec.non_payment_reason,
x_student_fee => NULL,
x_fte_intensity => v_fte_intensity,
x_fte_calc_type => v_fte_calc_type,
x_calculated_fte => c_old_susa_rec.calculated_fte,
x_type_of_year => v_type_of_year,
x_mode => 'R',
x_credit_value_yop3 => NULL,
x_credit_value_yop4 => NULL,
x_credit_level_achieved3 => c_old_susa_rec.credit_level_achieved3,
x_credit_level_achieved4 => c_old_susa_rec.credit_level_achieved4,
x_credit_pt_achieved3 => c_old_susa_rec.credit_pt_achieved3,
x_credit_pt_achieved4 => c_old_susa_rec.credit_pt_achieved4,
x_credit_level3 => NULL,
x_credit_level4 => NULL,
x_additional_sup_cost => NULL,
x_enh_fund_elig_cd => NULL,
x_disadv_uplift_factor => NULL,
x_year_stu => NULL);
igs_he_en_susa_cc_pkg.insert_row (
x_rowid => l_rowid,
x_he_susa_cc_id => l_he_susa_cc_id,
x_person_id => p_person_id,
x_course_cd => p_new_course_cd,
x_unit_set_cd => p_new_unit_set_cd,
x_sequence_number => v_u_new_sequence_number,
x_cost_centre => old_susa_cc_dtls_rec.cost_centre,
x_subject => old_susa_cc_dtls_rec.subject,
x_proportion => old_susa_cc_dtls_rec.proportion,
x_mode => 'R' );
SELECT version_number
FROM igs_en_stdnt_ps_att
WHERE person_id = p_person_id AND
course_cd = p_old_course_cd;
SELECT version_number
FROM igs_en_stdnt_ps_att
WHERE person_id = p_person_id AND
course_cd = p_new_course_cd;
SELECT map1
FROM igs_ps_award , igs_he_code_map_val
WHERE course_cd = cp_course_cd AND
version_number = cp_version_number AND
closed_ind = 'N' AND
map2 = award_cd AND
association_code = 'OSS_HESA_AWD_ASSOC'
ORDER BY default_ind DESC, map1 ASC ;
SELECT field_of_study
FROM igs_ps_field_study
WHERE course_cd = p_old_course_cd AND
version_number = v_u_old_version_number AND
major_field_ind = 'Y';
SELECT field_of_study
FROM igs_ps_field_study
WHERE course_cd = p_new_course_cd AND
version_number = v_u_new_version_number AND
major_field_ind = 'Y';
SELECT student_inst_number,
commencement_dt,
fe_student_marker,
domicile_cd,
postcode,
special_student,
social_class_ind,
occupation_code,
occcode,
student_qual_aim,
student_fe_qual_aim,
teacher_train_prog_id,
nhs_funding_source,
ufi_place,
nhs_employer,
qual_aim_subj1,
qual_aim_subj2,
qual_aim_subj3,
qual_aim_proportion ,
highest_qual_on_entry,
total_ucas_tariff
FROM igs_he_st_spa_all
WHERE person_id = p_person_id AND
course_cd = p_old_course_cd;
SELECT map1
FROM igs_he_code_map_val
WHERE association_code = 'OSS_HESA_TTCID_ASSOC' AND
map2 = cp_teacher_train_prog_id;
SELECT qualification_level,
number_of_qual,
tariff_score
FROM igs_he_st_spa_ut
WHERE person_id = p_person_id AND
course_cd = p_old_course_cd;
SELECT student_inst_number
FROM igs_he_st_spa_all
WHERE person_id = cp_person_id;
SELECT b.course_group_cd
FROM igs_ps_grp_type a, igs_ps_grp_all b, igs_ps_grp_mbr c , igs_ps_grp_mbr d
WHERE a.course_group_type = b.course_group_type AND
a.closed_ind = 'N' AND
a.s_course_group_type = 'CONTINUOUS' AND
b.course_group_cd = c.course_group_cd AND
b.closed_ind = 'N' AND
c.course_cd = p_old_course_cd AND
c.version_number = v_u_old_version_number AND
b.course_group_cd = d.course_group_cd AND
d.course_cd = p_new_course_cd AND
d.version_number = v_u_new_version_number ;
SELECT spa.*
FROM IGS_HE_ST_SPA_CC spa
WHERE spa.person_id = cp_person_id
AND spa.course_cd = cp_course_cd ;
SELECT 'X'
FROM IGS_HE_ST_SPA_CC spa
WHERE spa.person_id = cp_person_id
AND spa.course_cd = cp_course_cd
AND cost_centre = cp_cost_centre
AND subject = cp_subject;
igs_he_st_spa_all_pkg.insert_row(
x_rowid => v_rowid,
x_hesa_st_spa_id => v_hesa_st_spa_id,
x_org_id => v_org_id,
x_person_id => p_person_id,
x_course_cd => p_old_course_cd,
x_version_number => v_u_old_version_number,
x_fe_student_marker => NULL,
x_domicile_cd => NULL,
x_inst_last_attended => NULL,
x_year_left_last_inst => NULL,
x_highest_qual_on_entry => NULL,
x_date_qual_on_entry_calc => NULL,
x_a_level_point_score => NULL,
x_highers_points_scores => NULL,
x_occupation_code => NULL,
x_commencement_dt => NULL,
x_special_student => NULL ,
x_student_qual_aim => NULL ,
x_student_fe_qual_aim => NULL ,
x_teacher_train_prog_id => NULL ,
x_itt_phase => NULL,
x_bilingual_itt_marker => NULL,
x_teaching_qual_gain_sector => NULL,
x_teaching_qual_gain_subj1 => NULL,
x_teaching_qual_gain_subj2 => NULL,
x_teaching_qual_gain_subj3 => NULL,
x_student_inst_number => v_student_inst_number,
x_destination => NULL,
x_itt_prog_outcome => NULL,
x_hesa_return_name => NULL,
x_hesa_return_id => NULL,
x_hesa_submission_name => NULL,
x_associate_ucas_number => NULL,
x_associate_scott_cand => NULL,
x_associate_teach_ref_num => NULL,
x_associate_nhs_reg_num => NULL,
x_nhs_funding_source => NULL ,
x_ufi_place => NULL,
x_postcode => NULL ,
x_social_class_ind => NULL ,
x_occcode => NULL ,
x_total_ucas_tariff => NULL,
x_nhs_employer => NULL ,
x_return_type => NULL,
x_qual_aim_subj1 => NULL,
x_qual_aim_subj2 => NULL,
x_qual_aim_subj3 => NULL,
x_qual_aim_proportion => NULL,
x_exclude_flag => NULL,
x_mode => 'R' );
igs_he_st_spa_all_pkg.insert_row(
x_rowid => v_rowid,
x_hesa_st_spa_id => v_hesa_st_spa_id,
x_org_id => v_org_id,
x_person_id => p_person_id,
x_course_cd => p_new_course_cd,
x_version_number => v_u_new_version_number,
x_fe_student_marker => NULL,
x_domicile_cd => NULL,
x_inst_last_attended => NULL,
x_year_left_last_inst => NULL,
x_highest_qual_on_entry => NULL,
x_date_qual_on_entry_calc => NULL,
x_a_level_point_score => NULL,
x_highers_points_scores => NULL,
x_occupation_code => NULL,
x_commencement_dt => NULL,
x_special_student => NULL ,
x_student_qual_aim => NULL ,
x_student_fe_qual_aim => NULL ,
x_teacher_train_prog_id => NULL ,
x_itt_phase => NULL,
x_bilingual_itt_marker => NULL,
x_teaching_qual_gain_sector => NULL,
x_teaching_qual_gain_subj1 => NULL,
x_teaching_qual_gain_subj2 => NULL,
x_teaching_qual_gain_subj3 => NULL,
x_student_inst_number => v_student_inst_number,
x_destination => NULL,
x_itt_prog_outcome => NULL,
x_hesa_return_name => NULL,
x_hesa_return_id => NULL,
x_hesa_submission_name => NULL,
x_associate_ucas_number => NULL,
x_associate_scott_cand => NULL,
x_associate_teach_ref_num => NULL,
x_associate_nhs_reg_num => NULL,
x_nhs_funding_source => NULL ,
x_ufi_place => NULL,
x_postcode => NULL ,
x_social_class_ind => NULL ,
x_occcode => NULL ,
x_total_ucas_tariff => NULL,
x_nhs_employer => NULL ,
x_return_type => NULL,
x_qual_aim_subj1 => NULL,
x_qual_aim_subj2 => NULL,
x_qual_aim_subj3 => NULL,
x_qual_aim_proportion => NULL,
x_exclude_flag => NULL,
x_mode => 'R');
igs_he_st_spa_all_pkg.insert_row(
x_rowid => v_rowid,
x_hesa_st_spa_id => v_hesa_st_spa_id,
x_org_id => v_org_id,
x_person_id => p_person_id,
x_course_cd => p_new_course_cd,
x_version_number => v_u_new_version_number,
x_fe_student_marker => v_fe_student_marker,
x_domicile_cd => v_domicile_cd,
x_inst_last_attended => NULL,
x_year_left_last_inst => NULL,
x_highest_qual_on_entry => v_highest_qual_on_entry,
x_date_qual_on_entry_calc => NULL,
x_a_level_point_score => NULL,
x_highers_points_scores => NULL,
x_occupation_code => v_occupation_code,
x_commencement_dt => v_commencement_dt,
x_special_student => v_special_student,
x_student_qual_aim => v_student_qual_aim,
x_student_fe_qual_aim => v_student_fe_qual_aim,
x_teacher_train_prog_id => v_teacher_train_prog_id,
x_itt_phase => NULL,
x_bilingual_itt_marker => NULL,
x_teaching_qual_gain_sector => NULL,
x_teaching_qual_gain_subj1 => NULL,
x_teaching_qual_gain_subj2 => NULL,
x_teaching_qual_gain_subj3 => NULL,
x_student_inst_number => v_student_inst_number,
x_destination => NULL,
x_itt_prog_outcome => NULL,
x_hesa_return_name => NULL,
x_hesa_return_id => NULL,
x_hesa_submission_name => NULL,
x_associate_ucas_number => NULL,
x_associate_scott_cand => NULL,
x_associate_teach_ref_num => NULL,
x_associate_nhs_reg_num => NULL,
x_nhs_funding_source => v_nhs_funding_source,
x_ufi_place => c_old_spa_rec.ufi_place,
x_postcode => v_postcode,
x_social_class_ind => v_social_class_ind,
x_occcode => v_occcode,
x_total_ucas_tariff => v_total_ucas_tariff,
x_nhs_employer => c_old_spa_rec.nhs_employer,
x_return_type => NULL,
x_qual_aim_subj1 => v_qual_aim_subj1,
x_qual_aim_subj2 => v_qual_aim_subj2,
x_qual_aim_subj3 => v_qual_aim_subj3,
x_qual_aim_proportion => v_qual_aim_proportion,
x_exclude_flag => NULL,
x_mode => 'R');
igs_he_st_spa_ut_all_pkg.insert_row(
x_rowid => v_ut_rowid,
x_hesa_st_spau_id => v_hesa_st_spau_id,
x_org_id => v_org_id,
x_person_id => p_person_id,
x_course_cd => p_new_course_cd,
x_version_number => v_u_new_version_number,
x_qualification_level => v_qualification_level,
x_number_of_qual => v_number_of_qual,
x_tariff_score => v_tariff_score,
x_mode => 'R' );
igs_he_st_spa_cc_pkg.insert_row (
x_rowid => l_rowid,
x_he_spa_cc_id => l_he_spa_cc_id,
x_person_id => p_person_id,
x_course_cd => p_new_course_cd,
x_cost_centre => old_spa_cc_dtls_rec.cost_centre,
x_subject => old_spa_cc_dtls_rec.subject,
x_proportion => old_spa_cc_dtls_rec.proportion,
x_mode => 'R' );