[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT COUNT(UNIQUE um.s_unit_mode)
FROM IGS_ST_GVT_STDNTLOAD gslo,
IGS_EN_ST_SNAPSHOT ess,
IGS_AS_UNIT_CLASS ucl,
IGS_AS_UNIT_MODE um,
IGS_ST_GVT_SPSHT_CTL gsc
WHERE gslo.submission_yr = p_submission_yr AND
gslo.submission_number = p_submission_number AND
gslo.person_id = p_person_id AND
gslo.course_cd = p_course_cd AND
ess.snapshot_dt_time = gsc.ess_snapshot_dt_time AND
ess.person_id = gslo.person_id AND
ess.course_cd = gslo.course_cd AND
ess.unit_cd = gslo.unit_cd AND
ess.sua_cal_type = gslo.sua_cal_type AND
ess.sua_ci_sequence_number = gslo.sua_ci_sequence_number AND
ess.sua_location_cd = gslo.sua_location_cd AND
ess.unit_class = gslo.unit_class AND
ess.tr_org_unit_cd = gslo.tr_org_unit_cd AND
ess.tr_ou_start_dt = gslo.tr_ou_start_dt AND
ess.discipline_group_cd = gslo.discipline_group_cd AND
ess.govt_discipline_group_cd = gslo.govt_discipline_group_cd AND
ucl.unit_class = ess.unit_class AND
ucl.closed_ind = 'N' AND
um.unit_mode = ucl.unit_mode AND
gsc.submission_yr = gslo.submission_yr AND
gsc.submission_number = gslo.submission_number;
SELECT UNIQUE um.s_unit_mode
FROM IGS_ST_GVT_STDNTLOAD gslo,
IGS_EN_ST_SNAPSHOT ess,
IGS_AS_UNIT_CLASS ucl,
IGS_AS_UNIT_MODE um,
IGS_ST_GVT_SPSHT_CTL gsc
WHERE gslo.submission_yr = p_submission_yr AND
gslo.submission_number = p_submission_number AND
gslo.person_id = p_person_id AND
gslo.course_cd = p_course_cd AND
ess.snapshot_dt_time = gsc.ess_snapshot_dt_time AND
ess.person_id = gslo.person_id AND
ess.course_cd = gslo.course_cd AND
ess.unit_cd = gslo.unit_cd AND
ess.sua_cal_type = gslo.sua_cal_type AND
ess.sua_ci_sequence_number = gslo.sua_ci_sequence_number AND
ess.sua_location_cd = gslo.sua_location_cd AND
ess.unit_class = gslo.unit_class AND
ess.tr_org_unit_cd = gslo.tr_org_unit_cd AND
ess.tr_ou_start_dt = gslo.tr_ou_start_dt AND
ess.discipline_group_cd = gslo.discipline_group_cd AND
ess.govt_discipline_group_cd = gslo.govt_discipline_group_cd AND
ucl.unit_class = ess.unit_class AND
ucl.closed_ind = 'N' AND
um.unit_mode = ucl.unit_mode AND
gsc.submission_yr = gslo.submission_yr AND
gsc.submission_number = gslo.submission_number;
SELECT attendance_mode
FROM IGS_EN_ATD_MODE
WHERE govt_attendance_mode = cp_govt_attend_mode
ORDER
BY attendance_mode;
SELECT sca.commencement_dt
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd = p_course_cd;
SELECT crv.generic_course_ind,
cty.govt_course_type,
crv.responsible_org_unit_cd,
IGS_ST_GEN_002.stap_get_course_lvl(
cp_course_cd,
cp_version_number,
cty.govt_course_type)
FROM IGS_PS_VER crv,
IGS_PS_TYPE cty
WHERE crv.course_cd = cp_course_cd AND
crv.version_number = cp_version_number AND
cty.course_type = crv.course_type;
SELECT sca.course_cd,
sca.version_number,
sca.commencement_dt
FROM IGS_EN_STDNT_PS_ATT sca
WHERE sca.person_id = p_person_id AND
sca.course_cd <> p_course_cd AND
sca.commencement_dt < cp_april_dt
ORDER BY sca.commencement_dt DESC;
SELECT 'x'
FROM IGS_ST_GOVT_STDNT_EN gse
WHERE gse.person_id = p_person_id AND
gse.course_cd = p_course_cd AND
gse.submission_yr = p_collection_yr - 1;
SELECT api.api_person_id
FROM IGS_PE_ALT_PERS_ID api,
IGS_PE_PERSON_ID_TYP pit
WHERE api.pe_person_id = cp_person_id AND
pit.person_id_type = api.person_id_type AND
pit.s_person_id_type = 'OBSOLETE';
SELECT 'x'
FROM IGS_ST_GOVT_STDNT_EN gse
WHERE gse.person_id = p_person_id AND
gse.course_cd = p_course_cd AND
gse.submission_yr < p_collection_yr;
SELECT api.api_person_id
FROM IGS_PE_ALT_PERS_ID api,
IGS_PE_PERSON_ID_TYP pit
WHERE api.pe_person_id = cp_person_id AND
pit.person_id_type = api.person_id_type AND
pit.s_person_id_type = 'OBSOLETE';
SELECT 'x'
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.unit_attempt_status IN (
'ENROLLED',
'COMPLETED');
smvk 03-Jun-2003 Bug # 2858436. Modified the cursor c_caw to select open program awards only.
***************************************************************/
BEGIN
DECLARE
CURSOR c_caw IS
SELECT 'x'
FROM IGS_PS_AWARD caw
WHERE caw.course_cd = p_course_cd AND
caw.version_number = p_version_number AND
caw.closed_ind = 'N' AND
EXISTS (SELECT 'x'
FROM IGS_PS_AWARD caw1
WHERE caw1.course_cd = p_prev_course_cd AND
caw1.version_number = p_prev_version_number AND
caw1.award_cd <> caw.award_cd AND
caw1.closed_ind = 'N');
SELECT 'X'
FROM IGS_PS_GRP_MBR cgm1
WHERE cgm1.course_cd = p_prev_course_cd AND
cgm1.version_number = p_prev_version_number AND
EXISTS (
SELECT 'X'
FROM IGS_PS_GRP_MBR cgm,
IGS_PS_GRP cgr,
IGS_PS_GRP_TYPE cgt
WHERE cgm.course_cd = p_course_cd AND
cgm.version_number = p_version_number AND
cgr.course_group_cd = cgm.course_group_cd AND
cgt.course_group_type = cgr.course_group_type AND
cgt.s_course_group_type = 'EQUIV' AND
cgm.course_group_cd = cgm1.course_group_cd);
SELECT 'X'
FROM IGS_PS_GRP_MBR cgm,
IGS_PS_GRP cgr,
IGS_PS_GRP_TYPE cgt
WHERE cgm.course_cd = p_course_cd AND
cgm.version_number = p_version_number AND
cgr.course_group_cd = cgm.course_group_cd AND
cgt.course_group_type = cgr.course_group_type AND
cgt.s_course_group_type = 'COMBINED';
SELECT sua.course_cd,
sua.unit_cd,
sua.cal_type,
sua.ci_sequence_number,
sua.unit_attempt_status,
sua.uoo_id
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sua.unit_attempt_status = 'COMPLETED';
SELECT 'X'
FROM IGS_PS_STDNT_TRN sct
WHERE sct.person_id = p_person_id AND
sct.course_cd = p_course_cd AND
sct.transfer_course_cd = p_transfer_course_cd;
SELECT 'x'
FROM IGS_PS_GRP_MBR cgm1
WHERE cgm1.course_cd = p_course_cd AND
cgm1.version_number = p_version_number AND
EXISTS (
SELECT 'x'
FROM IGS_PS_GRP_MBR cgm2,
IGS_PS_GRP cgp,
IGS_PS_GRP_TYPE cgt
WHERE cgm2.course_cd = p_transfer_course_cd AND
cgm2.version_number = p_trnsfr_version_number AND
cgm2.course_group_cd = cgm1.course_group_cd AND
cgm2.course_group_cd = cgp.course_group_cd AND
cgp.course_group_type = cgt.course_group_type AND
cgt.s_course_group_type = cst_govt_ret);
SELECT gse.commencement_dt
FROM IGS_ST_GOVT_STDNT_EN gse
WHERE gse.submission_yr < p_collection_yr AND
gse.submission_number = 1 AND -- enrolment file is only ever submission 1
gse.person_id = p_person_id AND
gse.course_cd = p_prev_course_cd AND
gse.version_number = p_prev_version_number
ORDER BY gse.submission_yr DESC;