[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pd.contact_ind,
dt.govt_disability_type
FROM
IGS_PE_PERS_DISABLTY pd,
IGS_AD_DISBL_TYPE dt
WHERE
pd.person_id = cp_person_id AND
dt.disability_type = pd.disability_type;
SELECT given_names
FROM IGS_PE_PERSON
WHERE person_id = cp_person_id;
SELECT hpo.govt_hecs_payment_option
FROM
IGS_EN_STDNTPSHECSOP scho,
IGS_FI_HECS_PAY_OPTN hpo
WHERE
scho.person_id = p_person_id AND
scho.course_cd = p_course_cd AND
scho.start_dt <= p_submission_cutoff_dt AND
(scho.end_dt IS NULL OR
scho.end_dt >= p_submission_cutoff_dt)AND
hpo.hecs_payment_option = scho.hecs_payment_option
ORDER BY
scho.end_dt ASC;
-- Select the first record only.
-- This will be the end dated record if one exists.
OPEN c_scho_hpo;
SELECT uc.unit_cat
FROM IGS_PS_UNIT_CATEGORY uc
WHERE uc.unit_cd = p_unit_cd AND
uc.version_number = p_uv_version_number AND
uc.unit_cat IN (
cst_govt_report,
cst_govt_noreport );
SELECT crc.course_cat
FROM IGS_PS_CATEGORISE crc
WHERE crc.course_cd = p_course_cd AND
crc.version_number = p_crv_version_number AND
crc.course_cat IN (
cst_govt_report,
cst_govt_noreport );
SELECT crv.responsible_org_unit_cd,
crv.responsible_ou_start_dt,
cty.govt_course_type,
cty.award_course_ind
FROM IGS_PS_VER crv,
IGS_PS_TYPE cty
WHERE crv.course_cd = p_course_cd AND
crv.version_number = p_crv_version_number AND
cty.course_type = crv.course_type;
SELECT uv.enrolled_credit_points
FROM IGS_PS_UNIT_VER uv
WHERE uv.unit_cd = p_unit_cd AND
uv.version_number = p_uv_version_number;
SELECT sca.fee_cat,
sca.course_rqrmnt_complete_ind,
sca.commencement_dt,
hpo.govt_hecs_payment_option
FROM IGS_EN_STDNT_PS_ATT sca,
IGS_EN_STDNTPSHECSOP scho,
IGS_FI_HECS_PAY_OPTN hpo
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_course_cd AND
sca.person_id = scho.person_id (+) AND
sca.course_cd = scho.course_cd (+) AND
(scho.start_dt <= p_effective_dt OR
scho.start_dt IS NULL) AND
( scho.end_dt IS NULL OR
scho.end_dt >= p_effective_dt) AND
scho.hecs_payment_option = hpo.hecs_payment_option(+)
ORDER BY scho.end_dt;
SELECT ft.fee_type
FROM IGS_FI_FEE_TYPE ft
WHERE ft.s_fee_type = cst_tuition;
SELECT sua.unit_attempt_status
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.uoo_id = p_uoo_id;
SELECT daiv.alias_val
FROM IGS_CA_DA_INST_V daiv,
IGS_GE_S_GEN_CAL_CON sgcc
WHERE daiv.cal_type = cp_cal_type AND
daiv.ci_sequence_number = cp_ci_seq_num AND
daiv.dt_alias = sgcc.census_dt_alias
ORDER BY daiv.alias_val ASC;
-- select the alias_val from IGS_CA_DA_INST_V.
-- select the first record only
OPEN c_daiv(
p_teach_cal_type,
p_teach_ci_sequence_number);
SELECT sca.commencement_dt,
sca.adm_admission_appl_number,
sca.adm_nominated_course_cd
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_course_cd;
SELECT aca.basis_for_admission_type
FROM IGS_AD_PS_APPL aca
WHERE aca.person_id = p_person_id AND
aca.admission_appl_number = cp_admission_appl_number AND
aca.nominated_course_cd = cp_nominated_course_cd;
SELECT bfa.govt_basis_for_adm_type
FROM IGS_AD_BASIS_FOR_AD bfa
WHERE bfa.basis_for_admission_type = cp_basis_for_adm_type;
SELECT ase.score,
ase.result_obtained_yr,
aseat.aus_scndry_edu_ass_type
FROM IGS_AD_AUS_SEC_EDU ase,
IGS_AD_AUSE_ED_AS_TY aseat
WHERE ase.person_id = p_person_id AND
aseat.aus_scndry_edu_ass_type = ase.aus_scndry_edu_ass_type AND
aseat.govt_reported_ind = 'Y'
ORDER BY NVL(ase.result_obtained_yr,0) DESC,
ase.last_update_date DESC;
SELECT atgsm.govt_score
FROM IGS_AS_TYPGOV_SCORMP atgsm
WHERE atgsm.result_obtained_yr = cp_result_obtained_yr AND
atgsm.scndry_edu_ass_type = cp_scndry_edu_ass_type AND
atgsm.institution_score = cp_institution_score;
SELECT TRUNC(ast.total_exmptn_perc_grntd),
ast.exemption_institution_cd
FROM IGS_AV_ADV_STANDING ast
WHERE ast.person_id = p_person_id AND
ast.course_cd = p_course_cd AND
ast.version_number = p_crv_version_number;
SELECT ins.govt_institution_cd
FROM IGS_OR_INSTITUTION ins
WHERE ins.institution_cd = cp_exemption_institution_cd;
SELECT scho.differential_hecs_ind,
scho.hecs_payment_option,
hpo.govt_hecs_payment_option,
ghpo.s_hecs_payment_type
FROM IGS_EN_STDNTPSHECSOP scho,
IGS_FI_HECS_PAY_OPTN hpo,
IGS_FI_GOV_HEC_PA_OP ghpo
WHERE scho.person_id = p_person_id AND
scho.course_cd = p_course_cd AND
scho.start_dt <= p_effective_dt AND
(scho.end_dt IS NULL OR
scho.end_dt >= p_effective_dt) AND
hpo.hecs_payment_option = scho.hecs_payment_option AND
ghpo.govt_hecs_payment_option = hpo.govt_hecs_payment_option
ORDER BY scho.end_dt ASC;
-- select the first record only, which will be
-- the end dated record if one exists
OPEN c_get_hpo;
SELECT ps.prior_post_grad,
ps.prior_degree,
ps.prior_subdeg_notafe,
ps.prior_subdeg_tafe,
ps.prior_tafe_award,
ps.prior_other_qual,
ps.prior_seced_school,
ps.prior_seced_tafe
FROM IGS_PE_STATISTICS ps
WHERE ps.person_id = p_person_id AND
TRUNC(ps.start_dt) <= TRUNC(SYSDATE) AND
(ps.end_dt IS NULL OR
TRUNC(ps.end_dt) >= TRUNC(SYSDATE))
ORDER BY ps.end_dt;
SELECT fos.govt_field_of_study
FROM IGS_PS_FIELD_STUDY cfos,
IGS_PS_FLD_OF_STUDY fos
WHERE cfos.course_cd = p_course_cd AND
cfos.version_number = p_version_number AND
cfos.major_field_ind = 'Y' AND
fos.field_of_study = cfos.field_of_study;