[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'x'
FROM IGS_FI_FEE_AS_RATE
WHERE fee_type = p_fee_type AND
fee_cal_type = p_fee_cal_type AND
fee_ci_sequence_number = p_fee_ci_sequence_number AND
s_relation_type = cp_s_relation_type AND
logical_delete_dt IS NULL;
SELECT IGS_AD_LOCATION.closed_ind,
location_type
FROM IGS_AD_LOCATION
WHERE location_cd = cp_location_cd;
SELECT s_location_type
FROM IGS_AD_LOCATION_TYPE
WHERE location_type = cp_location_type;
SELECT 'x'
FROM IGS_FI_FEE_TYPE ft
WHERE ft.fee_type = p_fee_type AND
ft.s_fee_type IN ('HECS','TUITION');
SELECT 'x'
FROM igs_fi_fee_as_rate far
WHERE far.fee_type = p_fee_type
AND far.fee_cal_type = p_fee_cal_type
AND far.fee_ci_sequence_number = p_fee_ci_sequence_number
AND far.s_relation_type = p_s_relation_type
AND far.rate_number <> NVL(p_rate_number,0)
AND NVL(far.fee_cat,'NULL') = NVL(p_fee_cat,'NULL')
AND NVL(far.location_cd,'NULL') = NVL(p_location_cd,'NULL')
AND NVL(far.attendance_type,'NULL') = NVL(p_attendance_type,'NULL')
AND NVL(far.attendance_mode,'NULL') = NVL(p_attendance_mode,'NULL')
AND NVL(far.govt_hecs_payment_option,'NULL') = NVL(p_govt_hecs_payment_option,'NULL')
AND NVL(far.govt_hecs_cntrbtn_band,0) = NVL(p_govt_hecs_cntrbtn_band,0)
AND NVL(far.chg_rate,0) = NVL(p_chg_rate,0)
-- AND NVL(far.unit_class,'NULL') = NVL(p_unit_class,'NULL')
AND far.logical_delete_dt IS NULL
AND NVL(far.residency_status_cd,0) = NVL(p_residency_status_cd,0)
AND NVL(far.course_cd,'NULL') = NVL(p_course_cd,'NULL')
AND NVL(far.version_number,0) = NVL(p_version_number,0)
AND NVL(far.org_party_id,0) = NVL(p_org_party_id,0)
--Bug #4564002, passed p_class_standing instead of class_standing
AND NVL(far.class_standing,'NULL') = NVL(p_class_standing,'NULL')
AND NVL(far.unit_set_cd,'NULL') = NVL(p_unit_set_cd,'NULL')
AND NVL(far.us_version_number,0) = NVL(p_us_version_number,0)
AND NVL(FAR.UNIT_TYPE_ID,0) = NVL(P_UNIT_TYPE_ID,0)
AND (( FAR.UNIT_CLASS = P_UNIT_CLASS) OR (FAR.UNIT_CLASS IS NULL AND P_UNIT_CLASS IS NULL))
AND ((FAR.UNIT_MODE = P_UNIT_MODE) OR (FAR.UNIT_MODE IS NULL AND P_UNIT_MODE IS NULL))
AND ((FAR.UNIT_CD = P_UNIT_CD) OR (FAR.UNIT_CD IS NULL AND P_UNIT_CD IS NULL))
AND NVL(FAR.UNIT_VERSION_NUMBER,0) = NVL(P_UNIT_VERSION_NUMBER,0)
AND ((FAR.UNIT_LEVEL = P_UNIT_LEVEL) OR (FAR.UNIT_LEVEL IS NULL AND P_UNIT_LEVEL IS NULL))
;
SELECT far.order_of_precedence
FROM IGS_FI_FEE_AS_RATE far
WHERE far.fee_type = cp_fee_type AND
far.fee_cal_type = cp_fee_cal_type AND
far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
far.s_relation_type = cp_s_relation_type AND
far.rate_number <> cp_rate_number AND
far.logical_delete_dt IS NULL AND
NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
((far.location_cd IS NULL) OR
(far.attendance_mode IS NOT NULL OR far.attendance_type IS NOT NULL));
SELECT far.order_of_precedence
FROM IGS_FI_FEE_AS_RATE far
WHERE far.fee_type = cp_fee_type AND
far.fee_cal_type = cp_fee_cal_type AND
far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
far.s_relation_type = cp_s_relation_type AND
far.rate_number <> cp_rate_number AND
far.logical_delete_dt IS NULL AND
NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
((far.location_cd IS NULL OR far.attendance_mode IS NULL) OR
(far.attendance_type IS NOT NULL));
SELECT far.order_of_precedence
FROM IGS_FI_FEE_AS_RATE far
WHERE far.fee_type = cp_fee_type AND
far.fee_cal_type = cp_fee_cal_type AND
far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
far.s_relation_type = cp_s_relation_type AND
far.rate_number <> cp_rate_number AND
far.logical_delete_dt IS NULL AND
NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
((far.location_cd IS NULL OR far.attendance_type IS NULL) OR
(far.attendance_mode IS NOT NULL));
SELECT far.order_of_precedence
FROM IGS_FI_FEE_AS_RATE far
WHERE far.fee_type = cp_fee_type AND
far.fee_cal_type = cp_fee_cal_type AND
far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
far.s_relation_type = cp_s_relation_type AND
far.rate_number <> cp_rate_number AND
far.logical_delete_dt IS NULL AND
NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
((far.location_cd IS NULL OR
far.attendance_mode IS NULL) OR
(far.attendance_type IS NULL));
SELECT far.order_of_precedence
FROM IGS_FI_FEE_AS_RATE far
WHERE far.fee_type = cp_fee_type AND
far.fee_cal_type = cp_fee_cal_type AND
far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
far.s_relation_type = cp_s_relation_type AND
far.rate_number <> cp_rate_number AND
far.logical_delete_dt IS NULL AND
NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
((far.attendance_type IS NULL) OR
(far.location_cd IS NOT NULL OR far.attendance_mode IS NOT NULL));
SELECT far.order_of_precedence
FROM IGS_FI_FEE_AS_RATE far
WHERE far.fee_type = cp_fee_type AND
far.fee_cal_type = cp_fee_cal_type AND
far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
far.s_relation_type = cp_s_relation_type AND
far.rate_number <> cp_rate_number AND
far.logical_delete_dt IS NULL AND
NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
((far.attendance_mode IS NULL OR far.attendance_type IS NULL) OR
(far.location_cd IS NOT NULL));
SELECT far.order_of_precedence
FROM IGS_FI_FEE_AS_RATE far
WHERE far.fee_type = cp_fee_type AND
far.fee_cal_type = cp_fee_cal_type AND
far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
far.s_relation_type = cp_s_relation_type AND
far.rate_number <> cp_rate_number AND
far.logical_delete_dt IS NULL AND
NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
((far.attendance_mode IS NULL) OR
(far.location_cd IS NOT NULL OR far.attendance_type IS NOT NULL));
SELECT far.order_of_precedence
FROM IGS_FI_FEE_AS_RATE far
WHERE far.fee_type = cp_fee_type AND
far.fee_cal_type = cp_fee_cal_type AND
far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
far.s_relation_type = cp_s_relation_type AND
far.rate_number <> cp_rate_number AND
far.logical_delete_dt IS NULL AND
NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
far.order_of_precedence = cp_order_of_precedence;
SELECT far.order_of_precedence
FROM IGS_FI_FEE_AS_RATE far
WHERE far.fee_type = cp_fee_type AND
far.fee_cal_type = cp_fee_cal_type AND
far.fee_ci_sequence_number = cp_fee_ci_sequence_number AND
far.s_relation_type = cp_s_relation_type AND
far.rate_number <> cp_rate_number AND
far.logical_delete_dt IS NULL AND
NVL(far.fee_cat,'NULL') = NVL(cp_fee_cat,'NULL') AND
NVL(far.location_cd,'NULL') = NVL(cp_location_cd,'NULL') AND
NVL(far.attendance_mode,'NULL') = NVL(cp_attendance_mode,'NULL') AND
NVL(far.attendance_type,'NULL') = NVL(cp_attendance_type,'NULL') AND
NVL(far.govt_hecs_payment_option,'X') =
NVL(cp_govt_hecs_payment_option,'X') AND
NVL(far.govt_hecs_cntrbtn_band,0) = nvl(cp_govt_hecs_cntrbtn_band,0);
SELECT s_fee_type
FROM IGS_FI_FEE_TYPE
WHERE fee_type = cp_fee_type;
SELECT closed_ind
FROM IGS_EN_ATD_MODE
WHERE attendance_mode = p_attend_mode;
SELECT closed_ind
FROM IGS_FI_GOVT_HEC_CNTB
WHERE govt_hecs_cntrbtn_band = cp_govt_hecs_cntrbtn_band;
SELECT closed_ind
FROM IGS_AS_UNIT_CLASS
WHERE unit_class = p_unit_class;
SELECT closed_ind
FROM IGS_FI_GOV_HEC_PA_OP
WHERE govt_hecs_payment_option = cp_govt_hecs_payment_option;
SELECT s_fee_trigger_cat,
s_fee_type
FROM IGS_FI_FEE_TYPE
WHERE fee_type = cp_fee_type;