21: eswv_excluded.ci_sequence_number,
22: eswv_excluded.person_id,
23: eswv_excluded.course_version,
24: eswv_excluded.unit_version
25: FROM IGS_EN_ST_SNAPSHOT_WARNING_V eswv_excluded
26: WHERE eswv_excluded.snapshot_dt_time = p_snapshot_dt_time AND
27: eswv_excluded.govt_reportable_ind = 'X';
28: CURSOR c_eswv_warning (
29: cp_snapshot_dt_time
26: WHERE eswv_excluded.snapshot_dt_time = p_snapshot_dt_time AND
27: eswv_excluded.govt_reportable_ind = 'X';
28: CURSOR c_eswv_warning (
29: cp_snapshot_dt_time
30: IGS_EN_ST_SNAPSHOT_WARNING_V.snapshot_dt_time%TYPE,
31: cp_ci_cal_type IGS_EN_ST_SNAPSHOT_WARNING_V.ci_cal_type%TYPE,
32: cp_ci_sequence_number
33: IGS_EN_ST_SNAPSHOT_WARNING_V.ci_sequence_number%TYPE,
34: cp_person_id IGS_EN_ST_SNAPSHOT_WARNING_V.person_id%TYPE,
27: eswv_excluded.govt_reportable_ind = 'X';
28: CURSOR c_eswv_warning (
29: cp_snapshot_dt_time
30: IGS_EN_ST_SNAPSHOT_WARNING_V.snapshot_dt_time%TYPE,
31: cp_ci_cal_type IGS_EN_ST_SNAPSHOT_WARNING_V.ci_cal_type%TYPE,
32: cp_ci_sequence_number
33: IGS_EN_ST_SNAPSHOT_WARNING_V.ci_sequence_number%TYPE,
34: cp_person_id IGS_EN_ST_SNAPSHOT_WARNING_V.person_id%TYPE,
35: cp_course_version
29: cp_snapshot_dt_time
30: IGS_EN_ST_SNAPSHOT_WARNING_V.snapshot_dt_time%TYPE,
31: cp_ci_cal_type IGS_EN_ST_SNAPSHOT_WARNING_V.ci_cal_type%TYPE,
32: cp_ci_sequence_number
33: IGS_EN_ST_SNAPSHOT_WARNING_V.ci_sequence_number%TYPE,
34: cp_person_id IGS_EN_ST_SNAPSHOT_WARNING_V.person_id%TYPE,
35: cp_course_version
36: IGS_EN_ST_SNAPSHOT_WARNING_V.course_version%TYPE,
37: cp_unit_version IGS_EN_ST_SNAPSHOT_WARNING_V.unit_version%TYPE)
30: IGS_EN_ST_SNAPSHOT_WARNING_V.snapshot_dt_time%TYPE,
31: cp_ci_cal_type IGS_EN_ST_SNAPSHOT_WARNING_V.ci_cal_type%TYPE,
32: cp_ci_sequence_number
33: IGS_EN_ST_SNAPSHOT_WARNING_V.ci_sequence_number%TYPE,
34: cp_person_id IGS_EN_ST_SNAPSHOT_WARNING_V.person_id%TYPE,
35: cp_course_version
36: IGS_EN_ST_SNAPSHOT_WARNING_V.course_version%TYPE,
37: cp_unit_version IGS_EN_ST_SNAPSHOT_WARNING_V.unit_version%TYPE)
38: IS
32: cp_ci_sequence_number
33: IGS_EN_ST_SNAPSHOT_WARNING_V.ci_sequence_number%TYPE,
34: cp_person_id IGS_EN_ST_SNAPSHOT_WARNING_V.person_id%TYPE,
35: cp_course_version
36: IGS_EN_ST_SNAPSHOT_WARNING_V.course_version%TYPE,
37: cp_unit_version IGS_EN_ST_SNAPSHOT_WARNING_V.unit_version%TYPE)
38: IS
39: SELECT 'X'
40: FROM IGS_EN_ST_SNAPSHOT_WARNING_V eswv_warning
33: IGS_EN_ST_SNAPSHOT_WARNING_V.ci_sequence_number%TYPE,
34: cp_person_id IGS_EN_ST_SNAPSHOT_WARNING_V.person_id%TYPE,
35: cp_course_version
36: IGS_EN_ST_SNAPSHOT_WARNING_V.course_version%TYPE,
37: cp_unit_version IGS_EN_ST_SNAPSHOT_WARNING_V.unit_version%TYPE)
38: IS
39: SELECT 'X'
40: FROM IGS_EN_ST_SNAPSHOT_WARNING_V eswv_warning
41: WHERE eswv_warning.snapshot_dt_time = cp_snapshot_dt_time AND
36: IGS_EN_ST_SNAPSHOT_WARNING_V.course_version%TYPE,
37: cp_unit_version IGS_EN_ST_SNAPSHOT_WARNING_V.unit_version%TYPE)
38: IS
39: SELECT 'X'
40: FROM IGS_EN_ST_SNAPSHOT_WARNING_V eswv_warning
41: WHERE eswv_warning.snapshot_dt_time = cp_snapshot_dt_time AND
42: eswv_warning.ci_cal_type = cp_ci_cal_type AND
43: eswv_warning.ci_sequence_number = cp_ci_sequence_number AND
44: eswv_warning.person_id = cp_person_id AND