The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT s_admission_step_type,
step_type_restriction_num
FROM IGS_AD_PRCS_CAT_STEP
WHERE admission_cat = p_admission_cat AND
s_admission_process_type = p_s_admission_process_type AND
step_group_type <> 'TRACK'; --2402377
SELECT pd.archive_dt
FROM igs_pe_hz_parties pd
WHERE pd.party_id = cp_person_id ;
SELECT sacc.adm_appl_chng_of_pref_dt_alias
FROM IGS_AD_CAL_CONF sacc
WHERE sacc.s_control_num = 1;
SELECT acaiv.adm_cal_type,
acaiv.adm_ci_sequence_number,
aa.admission_cat,
aa.s_admission_process_type,
acaiv.course_cd,
acaiv.crv_version_number,
aa.acad_cal_type,
acaiv.location_cd,
acaiv.attendance_mode,
acaiv.attendance_type
FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL Bug: 3150054
igs_ad_appl aa
WHERE acaiv.admission_appl_number = aa.admission_appl_number AND
acaiv.person_id = aa.person_id AND
acaiv.person_id = p_person_id AND
acaiv.admission_appl_number = p_admission_appl_number AND
acaiv.nominated_course_cd = p_nominated_course_cd AND
acaiv.sequence_number = p_acai_sequence_number;
SELECT SUBSTR(IGS_AD_GEN_002.admp_get_acai_acadcd(
aav.person_id,
aav.admission_appl_number,
aav.acad_cal_type,
NVL(acai.adm_cal_type, aav.adm_cal_type),
NVL(acai.adm_ci_sequence_number, aav.adm_ci_sequence_number)),1,10) || '/' || ci.alternate_code commencement_period
FROM igs_ad_ps_appl_inst acai,
igs_ad_appl aav,
igs_ca_inst ci
WHERE aav.person_id = acai.person_id AND
aav.admission_appl_number = acai.admission_appl_number AND
ci.cal_type = NVL(acai.adm_cal_type, aav.adm_cal_type) AND
ci.sequence_number = NVL(acai.adm_ci_sequence_number,aav.adm_ci_sequence_number) AND
acai.person_id = p_person_id AND
acai.admission_appl_number = p_admission_appl_number AND
acai.nominated_course_cd = p_nominated_course_cd AND
acai.sequence_number = p_acai_sequence_number;
SELECT acaiv.preference_number,
acaiv.course_cd,
cv.short_title,
cv.title,
acaiv.location_cd,
acaiv.attendance_mode,
acaiv.attendance_type,
aav.acad_cal_type,
aav.acad_ci_sequence_number,
acaiv.sequence_number,
ci1.alternate_code || '/' || ci2.alternate_code commencement_period
FROM igs_ad_ps_appl_inst acaiv, -- Replaced IGS_AD_APPL_ADMAPPL_V with igs_ad_appl_inst Bug: 3150054
igs_ad_appl aav,
igs_ca_inst ci1,
igs_ca_inst ci2,
igs_ps_ver cv
WHERE acaiv.crv_version_number = cv.version_number AND
acaiv.course_cd = cv.course_cd AND
acaiv.person_id = p_person_id AND
acaiv.admission_appl_number = p_admission_appl_number AND
aav.person_id = acaiv.person_id AND
aav.admission_appl_number = acaiv.admission_appl_number AND
ci1.cal_type = aav.acad_cal_type AND
ci1.sequence_number = aav.acad_ci_sequence_number AND
ci2.cal_type = NVL(acaiv.adm_cal_type, aav.adm_cal_type) AND
ci2.sequence_number = NVL(acaiv.adm_cal_type, aav.adm_ci_sequence_number)
ORDER BY acaiv.preference_number,
acaiv.course_cd;
SELECT acai.course_cd,
acai.crv_version_number
FROM IGS_AD_PS_APPL_INST acai
WHERE acai.person_id = p_person_id AND
acai.admission_appl_number = p_admission_appl_number AND
acai.nominated_course_cd = p_nominated_course_cd AND
acai.sequence_number = p_acai_sequence_number;
SELECT crc.reference_cd
FROM IGS_PS_REF_CD crc,
IGS_GE_REF_CD_TYPE rct
WHERE rct.s_reference_cd_type = 'OTHER' AND
crc.reference_cd_type = rct.reference_cd_type AND
crc.course_cd = cp_course_cd AND
crc.version_number = cp_crv_version_number;
SELECT co.cal_type
FROM IGS_PS_OFR co
WHERE co.course_cd = p_course_cd AND
co.version_number = p_crv_version_number;
SELECT adm_appl_e_comp_perd_dt_alias,
adm_appl_m_comp_perd_dt_alias,
adm_appl_s_comp_perd_dt_alias
FROM IGS_AD_CAL_CONF sacco
WHERE s_control_num = 1;
SELECT dai.alias_val
FROM IGS_CA_DA_INST_V dai
WHERE dt_alias = v_comp_perd_dt_alias AND
cal_type = v_cal_type AND
NVL(alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) >= v_context_completion_dt AND
SUBSTR(IGS_GE_DATE.IGSCHAR(alias_val),1,4) >= p_expected_completion_yr
ORDER BY alias_val; -- Order is changed to Ascending. Bug :2647482
SELECT alias_val,
dt_alias
FROM IGS_CA_DA_INST_V dai
WHERE dt_alias IN(
NVL(cp_adm_e_perd_dt_alias, 'NONE'),
NVL(cp_adm_m_perd_dt_alias, 'NONE'),
NVL(cp_adm_s_perd_dt_alias, 'NONE')
) AND
cal_type = v_cal_type AND
NVL(alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) >= v_context_completion_dt --Replaced '<' with '>'. Bug: 2647482
ORDER BY alias_val; -- Order is changed to Ascending. Bug :2647482
SELECT program_length,
program_length_measurement
FROM igs_ps_ofr_opt_all
WHERE course_cd = p_course_cd AND
version_number = p_crv_version_number AND
cal_type = p_cal_type AND
location_cd = p_location_cd AND
attendance_mode = p_attendance_mode AND
attendance_type = p_attendance_type;