[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT count(*)
FROM IGS_AD_SBM_PS_FNTRGT
WHERE submission_yr = p_submission_yr AND
submission_number = p_submission_number AND
course_cd = p_course_cd AND
crv_version_number = p_crv_version_number AND
funding_source = p_funding_source AND
NVL(location_cd, 'NULL') = NVL(p_location_cd, 'NULL') AND
NVL(attendance_mode, 'NULL') = NVL(p_attendance_mode, 'NULL') AND
NVL(attendance_type, 'NULL') = NVL(p_attendance_type, 'NULL') AND
NVL(unit_set_cd, 'NULL') = NVL(p_unit_set_cd, 'NULL') AND
NVL(us_version_number, 0) = NVL(p_us_version_number, 0);
SELECT 'x'
FROM IGS_PS_OFR_PAT cop,
IGS_ST_GVTSEMLOAD_CA gslc,
IGS_CA_INST_REL cir
WHERE gslc.submission_yr = p_submission_yr AND
gslc.submission_number = p_submission_number AND
cop.course_cd = p_course_cd AND
cop.version_number = p_crv_version_number AND
(cop.offered_ind = 'Y' OR
cop.enrollable_ind = 'Y') AND
cop.cal_type = cir.sup_cal_type AND
cop.ci_sequence_number = cir.sup_ci_sequence_number AND
gslc.cal_type = cir.sub_cal_type AND
gslc.ci_sequence_number = cir.sub_ci_sequence_number;
SELECT 'x'
FROM IGS_FI_FND_SRC_RSTN
WHERE course_cd = p_course_cd AND
version_number = p_crv_version_number AND
restricted_ind = 'Y' AND
(cp_funding_source IS NULL OR
funding_source = cp_funding_source);
SELECT 'x'
FROM IGS_PS_OFR_OPT_UNIT_SET_V coousv,
IGS_EN_UNIT_SET us,
IGS_EN_UNIT_SET_STAT uss
WHERE coousv.unit_set_cd = p_unit_set_cd AND
coousv.us_version_number = p_us_version_number AND
coousv.course_cd = p_course_cd AND
coousv.crv_version_number = p_crv_version_number AND
coousv.location_cd LIKE NVL(p_location_cd, '%') AND
coousv.attendance_mode LIKE NVL(p_attendance_mode, '%') AND
coousv.attendance_type LIKE NVL(p_attendance_type, '%') AND
us.unit_set_cd = coousv.unit_set_cd AND
us.version_number = coousv.us_version_number AND
uss.unit_set_status = us.unit_set_status AND
uss.s_unit_set_status <> cst_inactive;
SELECT 'x'
FROM IGS_PS_OFR_PAT cop,
IGS_ST_GVTSEMLOAD_CA gslc,
IGS_CA_INST_REL cir
WHERE gslc.submission_yr = p_submission_yr AND
gslc.submission_number = p_submission_number AND
cop.course_cd = p_course_cd AND
cop.version_number = p_crv_version_number AND
(cop.offered_ind = 'Y' OR
cop.enrollable_ind = 'Y') AND
cop.cal_type = cir.sup_cal_type AND
cop.ci_sequence_number = cir.sup_ci_sequence_number AND
gslc.cal_type = cir.sub_cal_type AND
gslc.ci_sequence_number = cir.sub_ci_sequence_number AND
cop.location_cd LIKE NVL(p_location_cd, '%') AND
cop.attendance_mode LIKE NVL(p_attendance_mode, '%') AND
cop.attendance_type LIKE NVL(p_attendance_type, '%');