[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pue.pue_start_dt,
pue.expiry_dt
FROM IGS_PE_PERSENC_EFFCT pee,
IGS_PE_PERS_UNT_EXCL pue
WHERE pee.person_id = p_person_id AND
pee.s_encmb_effect_type = 'EXC_CRS_U' AND
pee.course_cd = p_course_cd AND
pue.person_id = pee.person_id AND
pue.encumbrance_type = pee.encumbrance_type AND
pue.pen_start_dt = pee.pen_start_dt AND
pue.s_encmb_effect_type = pee.s_encmb_effect_type AND
pue.pee_start_dt = pee.pee_start_dt AND
pue.pee_sequence_number = pee.sequence_number AND
pue.unit_cd = p_unit_cd;
SELECT apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V
WHERE s_encmb_effect_type = cp_srv_type;
SELECT pee_start_dt, expiry_dt
FROM IGS_PE_PERSENC_EFFCT
WHERE person_id = p_person_id AND
s_encmb_effect_type = cp_srv_type;
SELECT pee_start_dt, expiry_dt
FROM IGS_PE_PERSENC_EFFCT
WHERE person_id = p_person_id AND
s_encmb_effect_type = cp_srv_type AND
course_cd = p_course_cd;
SELECT pce.pce_start_dt,
pce.expiry_dt
FROM IGS_PE_COURSE_EXCL pce
WHERE pce.person_id = p_person_id AND
pce.course_cd = p_course_cd AND
pce.s_encmb_effect_type IN (
cst_excluded,
cst_suspended);
SELECT pcge.pcge_start_dt,
pcge.expiry_dt
FROM IGS_PE_CRS_GRP_EXCL pcge,
IGS_PS_GRP_MBR cgm,
IGS_PS_GRP cg
WHERE pcge.person_id = p_person_id AND
pcge.s_encmb_effect_type = cst_excluded_grp AND
pcge.course_group_cd = cg.course_group_cd AND
cg.course_group_cd = cgm.course_group_cd AND
cgm.course_cd = p_course_cd;
SELECT puse.puse_start_dt,
puse.expiry_dt
FROM IGS_PE_PERSENC_EFFCT pee,
IGS_PE_UNT_SET_EXCL puse
WHERE pee.person_id = p_person_id AND
pee.s_encmb_effect_type = 'EXC_CRS_US' AND
pee.course_cd = p_course_cd AND
puse.person_id = pee.person_id AND
puse.encumbrance_type = pee.encumbrance_type AND
puse.pen_start_dt = pee.pen_start_dt AND
puse.s_encmb_effect_type = pee.s_encmb_effect_type AND
puse.pee_start_dt = pee.pee_start_dt AND
puse.pee_sequence_number = pee.sequence_number AND
puse.unit_set_cd = p_unit_set_cd AND
puse.us_version_number = p_us_version_number;
SELECT pur.unit_cd,
pur.pur_start_dt,
pur.expiry_dt
FROM IGS_PE_PERSENC_EFFCT pee,
IGS_PE_UNT_REQUIRMNT pur
WHERE pee.person_id = p_person_id AND
pee.s_encmb_effect_type = cst_effect_type AND
pee.course_cd = p_course_cd AND
pur.person_id = pee.person_id AND
pur.encumbrance_type = pee.encumbrance_type AND
pur.pen_start_dt = pee.pen_start_dt AND
pur.s_encmb_effect_type = pee.s_encmb_effect_type AND
pur.pee_start_dt = pee.pee_start_dt AND
pur.pee_sequence_number = pee.sequence_number;
SELECT sua.ci_start_dt,
sua.ci_end_dt,
sua.unit_attempt_status
FROM IGS_EN_SU_ATTEMPT sua
WHERE sua.person_id = cp_p_person_id AND
sua.course_cd = cp_p_course_cd AND
sua.unit_cd = cp_unit_cd AND
sua.unit_attempt_status IN ('COMPLETED',
'DUPLICATE',
'ENROLLED',
'DISCONTIN');
SELECT SEET.apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V SEET
WHERE s_encmb_effect_type = 'RSTR_AT_TY';
SELECT PEE.pee_start_dt,
PEE.expiry_dt,
PEE.restricted_attendance_type
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = 'RSTR_AT_TY';
SELECT PEE.pee_start_dt,
PEE.expiry_dt,
PEE.restricted_attendance_type
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = 'RSTR_AT_TY' AND
course_cd = p_course_cd;
SELECT SEET.apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V SEET
WHERE s_encmb_effect_type = cst_rstr_ge_cp;
SELECT SEET.apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V SEET
WHERE s_encmb_effect_type = cst_rstr_le_cp;
SELECT PEE.pee_start_dt,
PEE.expiry_dt,
PEE.restricted_enrolment_cp
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_rstr_ge_cp AND
restricted_enrolment_cp IS NOT NULL
ORDER BY PEE.restricted_enrolment_cp DESC;
SELECT PEE.pee_start_dt,
PEE.expiry_dt,
PEE.restricted_enrolment_cp
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_rstr_ge_cp AND
course_cd = p_course_cd AND
restricted_enrolment_cp IS NOT NULL
ORDER BY PEE.restricted_enrolment_cp DESC;
SELECT PEE.pee_start_dt,
PEE.expiry_dt,
PEE.restricted_enrolment_cp
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_rstr_le_cp AND
restricted_enrolment_cp IS NOT NULL
ORDER BY PEE.restricted_enrolment_cp ASC;
SELECT PEE.pee_start_dt,
PEE.expiry_dt,
PEE.restricted_enrolment_cp
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_rstr_le_cp AND
course_cd = p_course_cd AND
restricted_enrolment_cp IS NOT NULL
ORDER BY PEE.restricted_enrolment_cp ASC;
SELECT SEET.apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V SEET
WHERE s_encmb_effect_type = cst_crsmtrl_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_crsmtrl_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_crsmtrl_blk AND
course_cd = p_course_cd;
SELECT SEET.apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V SEET
WHERE s_encmb_effect_type = cst_grad_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_grad_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_grad_blk AND
course_cd = p_course_cd;
SELECT SEET.apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V SEET
WHERE s_encmb_effect_type = cst_idcard_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_idcard_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_idcard_blk AND
course_cd = p_course_cd;
SELECT SEET.apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V SEET
WHERE s_encmb_effect_type = cst_infbth_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_infbth_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_infbth_blk AND
course_cd = p_course_cd;
SELECT SEET.apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V SEET
WHERE s_encmb_effect_type = cst_result_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_result_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_result_blk AND
course_cd = p_course_cd;
SELECT SEET.apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V SEET
WHERE s_encmb_effect_type = cst_cor_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_cor_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_cor_blk AND
course_cd = p_course_cd;
SELECT SEET.apply_to_course_ind
FROM IGS_EN_ENCMB_EFCTTYP_V SEET
WHERE s_encmb_effect_type = cst_trans_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_trans_blk;
SELECT PEE.pee_start_dt,
PEE.expiry_dt
FROM IGS_PE_PERSENC_EFFCT PEE
WHERE person_id = p_person_id AND
s_encmb_effect_type = cst_trans_blk AND
course_cd = p_course_cd;
SELECT SUP_CAL_TYPE, SUP_CI_SEQUENCE_NUMBER
FROM igs_ca_inst_rel
WHERE sub_cal_type = cp_cal_Type
AND sub_ci_sequence_number = cp_cal_seq
AND sup_cal_type
IN (SELECT CAL_TYPE FROM IGS_CA_TYPE WHERE S_CAL_CAT = 'ACADEMIC');