[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT IGS_CA_GEN_001.calp_set_alias_value(
daiv.absolute_val,
IGS_CA_GEN_002.cals_clc_dt_from_dai(
daiv.ci_sequence_number,
daiv.CAL_TYPE,
daiv.DT_ALIAS,
daiv.sequence_number) ) alias_val
FROM IGS_CA_DA_INST daiv,
IGS_AD_CAL_CONF sacc
WHERE daiv.dt_alias = sacc.adm_appl_course_strt_dt_alias AND
daiv.cal_type = p_adm_cal_type AND
daiv.ci_sequence_number = p_adm_ci_sequence_number AND
sacc.s_control_num = 1
ORDER BY 1 desc;
SELECT ccm.correspondence_cat,
cc.description
FROM IGS_CO_CAT_MAP ccm,
IGS_CO_CAT cc
WHERE ccm.admission_cat = p_admission_cat AND
ccm.dflt_cat_ind = 'Y' AND
cc.correspondence_cat = ccm.correspondence_cat AND
cc.closed_ind = 'N';
SELECT ecm.enrolment_cat,
ec.description
FROM IGS_EN_CAT_MAPPING ecm,
IGS_EN_ENROLMENT_CAT ec
WHERE ecm.admission_cat = p_admission_cat AND
ecm.dflt_cat_ind = 'Y' AND
ec.enrolment_cat = ecm.enrolment_cat AND
ec.closed_ind = 'N';
SELECT fcm.fee_cat,
fc.description
FROM IGS_FI_FEE_CAT_MAP fcm,
IGS_FI_FEE_CAT fc
WHERE admission_cat = p_admission_cat AND
dflt_cat_ind = 'Y' AND
fc.fee_cat = fcm.fee_cat AND
fc.closed_ind = 'N';
SELECT fsr.funding_source,
fs.description
FROM IGS_FI_FND_SRC_RSTN fsr,
IGS_FI_FUND_SRC fs
WHERE fsr.course_cd = p_course_cd AND
fsr.version_number = p_version_number AND
fsr.dflt_ind = 'Y' AND
fs.funding_source = fsr.funding_source AND
fs.closed_ind = 'N';
SELECT achpo.hecs_payment_option,
hpo.description
FROM IGS_AD_CT_HECS_PAYOP achpo,
IGS_FI_HECS_PAY_OPTN hpo
WHERE achpo.admission_cat = cp_admission_cat AND
1 = (
SELECT count(*)
FROM IGS_AD_CT_HECS_PAYOP achpo
WHERE achpo.admission_cat = cp_admission_cat) AND
hpo.hecs_payment_option = achpo.hecs_payment_option AND
hpo.closed_ind = 'N';
SELECT UNIQUE ucl.unit_class
FROM IGS_AS_UNIT_CLASS ucl
WHERE ucl.unit_mode = p_unit_mode AND
ucl.closed_ind = 'N';
SELECT ucl.unit_mode
FROM IGS_AS_UNIT_CLASS ucl
WHERE ucl.unit_class = p_unit_class
AND ucl.closed_ind = 'N';