[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT scpc.stream_num
FROM IGS_PR_S_CRV_PRG_CAL scpc
WHERE scpc.course_cd = p_course_cd AND
scpc.version_number = p_version_number AND
scpc.prg_cal_type = p_prg_cal_type;
SELECT 'X'
FROM IGS_PR_S_CRV_PRG_CAL scpc
WHERE scpc.course_cd = p_course_cd AND
scpc.version_number = p_version_number AND
scpc.prg_cal_type = p_comparison_prg_cal_type AND
scpc.stream_num = cp_stream_num;
SELECT sopc.org_unit_cd,
sopc.ou_start_dt,
sopc.stream_num
FROM IGS_PR_S_OU_PRG_CAL sopc
WHERE prgp_get_crv_cmt(
p_course_cd,
p_version_number,
sopc.org_unit_cd,
sopc.ou_start_dt) = 'Y' AND
sopc.prg_cal_type = p_prg_cal_type;
SELECT 'X'
FROM IGS_PR_S_OU_PRG_CAL sopc
WHERE sopc.org_unit_cd = cp_org_unit_cd AND
sopc.ou_start_dt = cp_ou_start_dt AND
sopc.prg_cal_type = p_comparison_prg_cal_type AND
sopc.stream_num = cp_stream_num;
SELECT spc.stream_num
FROM IGS_PR_S_PRG_CAL spc
WHERE spc.s_control_num = 1 AND
spc.prg_cal_type = p_prg_cal_type;
SELECT 'X'
FROM IGS_PR_S_PRG_CAL spc
WHERE spc.s_control_num = 1 AND
spc.prg_cal_type = p_comparison_prg_cal_type AND
spc.stream_num = cp_stream_num;
SELECT crv.course_type,
cow.org_unit_cd,
cow.ou_start_dt
FROM IGS_PS_VER crv,
IGS_PS_OWN cow
WHERE crv.course_cd = p_course_cd AND
crv.version_number = p_version_number AND
crv.course_cd = cow.course_cd AND
crv.version_number = cow.version_number;
SELECT 'X'
FROM IGS_OR_UNIT_REL our
WHERE our.parent_org_unit_cd = p_org_unit_cd AND
our.parent_start_dt = p_ou_start_dt AND
our.child_org_unit_cd = cp_cow_org_unit_cd AND
our.child_start_dt = cp_cow_ou_start_dt AND
our.logical_delete_dt IS NULL AND
EXISTS (
SELECT 'X'
FROM IGS_OR_REL_PS_TYPE ourct
WHERE our.parent_org_unit_cd = ourct.parent_org_unit_cd AND
our.parent_start_dt = ourct.parent_start_dt AND
our.child_org_unit_cd = ourct.child_org_unit_cd AND
our.child_start_dt = ourct.child_start_dt AND
our.create_dt = ourct.our_create_dt AND
ourct.course_type = cp_course_type);
SELECT cir.sub_cal_type,
cir.sub_ci_sequence_number
FROM IGS_CA_TYPE cat,
IGS_CA_INST ci,
IGS_CA_INST_REL cir,
IGS_CA_STAT cs
WHERE cir.sup_cal_type = p_prg_cal_type AND
cir.sup_ci_sequence_number = p_prg_sequence_number AND
ci.cal_type = cir.sub_cal_type AND
ci.sequence_number = cir.sub_ci_sequence_number AND
cs.cal_status = ci.cal_status AND
cs.s_cal_status = cst_active AND
cat.cal_type = ci.cal_type AND
cat.s_cal_cat = cst_teaching;
SELECT sua.unit_cd,
sua.cal_type,
sua.ci_sequence_number,
sua.unit_attempt_status,
sua.discontinued_dt,
sca.version_number,
sua.uoo_id
FROM IGS_EN_SU_ATTEMPT sua,
IGS_EN_STDNT_PS_ATT sca
WHERE sua.person_id = p_person_id AND
sua.course_cd = p_course_cd AND
sca.person_id = sua.person_id AND
sca.course_cd = sua.course_cd AND
sua.cal_type = cp_sub_cal_type AND
sua.ci_sequence_number = cp_sub_ci_sequence_number AND
sua.unit_attempt_status IN (
cst_enrolled,
cst_completed,
cst_discontin);
SELECT cir.sup_cal_type,
cir.sup_ci_sequence_number
FROM IGS_CA_TYPE cat,
IGS_CA_INST ci1,
IGS_CA_INST_REL cir,
IGS_CA_STAT cs
WHERE cir.sub_cal_type = cp_sua_cal_type AND
cir.sub_ci_sequence_number = cp_sua_ci_sequence_number AND
ci1.cal_type = cir.sup_cal_type AND
ci1.sequence_number = cir.sup_ci_sequence_number AND
cs.cal_status = ci1.cal_status AND
cs.s_cal_status = cst_active AND
cat.cal_type = ci1.cal_type AND
cat.s_cal_cat = cst_progress AND
prgp_get_cal_stream (
p_course_cd,
cp_sca_version_number,
p_prg_cal_type,
cir.sup_cal_type) = 'Y' AND
ci1.start_dt <
(SELECT ci2.start_dt
FROM IGS_CA_INST ci2
WHERE ci2.cal_type = p_prg_cal_type AND
ci2.sequence_number = p_prg_sequence_number);
SELECT cir.sub_cal_type,
cir.sub_ci_sequence_number
FROM IGS_CA_TYPE cat,
IGS_CA_INST ci,
IGS_CA_INST_REL cir,
IGS_CA_STAT cs
WHERE cir.sup_cal_type = p_prg_cal_type AND
cir.sup_ci_sequence_number = p_prg_sequence_number AND
ci.cal_type = cir.sub_cal_type AND
ci.sequence_number = cir.sub_ci_sequence_number AND
ci.cal_status = cs.cal_status AND
cs.s_cal_status = cst_active AND
cat.cal_type = ci.cal_type AND
cat.s_cal_cat = cst_teaching;
SELECT sua.unit_cd,
sua.cal_type,
sua.ci_sequence_number,
sua.unit_attempt_status,
sua.discontinued_dt,
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.cal_type = cp_sub_cal_type AND
sua.ci_sequence_number = cp_sub_ci_sequence_number AND
sua.unit_attempt_status IN (
cst_enrolled,
cst_completed,
cst_discontin);
SELECT IGS_CA_GEN_001.calp_get_alias_val(
dai.dt_alias,
dai.sequence_number,
dai.cal_type,
dai.ci_sequence_number)
FROM IGS_CA_DA_INST dai
WHERE dai.cal_type = p_prg_cal_type AND
dai.ci_sequence_number = p_prg_sequence_number AND
dt_alias =
(SELECT sprgcc.effective_end_dt_alias
FROM IGS_PR_S_PRG_CONF sprgcc
WHERE sprgcc.s_control_num = 1)
ORDER BY 1 DESC; -- for latest if multiple dates exist
SELECT ci.end_dt
FROM IGS_CA_INST ci
WHERE ci.cal_type = p_prg_cal_type AND
ci.sequence_number = p_prg_sequence_number;
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;