APPS.IGS_EN_DASHBOARD dependencies on IGS_PS_USEC_REF

Line 441: AND NOT EXISTS (SELECT * FROM igs_ps_usec_ref usr WHERE usr.uoo_id = sua.uoo_id AND NVL(CLASS_SCHEDULE_EXCLUSION_FLAG,'N') = 'Y')

437: AND sca.course_cd = sua.course_cd
438: AND sua.unit_attempt_status NOT IN ('UNCONFIRM')
439: AND tt11.teach_cal_type = sua.cal_type
440: AND tt11.teach_ci_sequence_number = sua.ci_sequence_number
441: AND NOT EXISTS (SELECT * FROM igs_ps_usec_ref usr WHERE usr.uoo_id = sua.uoo_id AND NVL(CLASS_SCHEDULE_EXCLUSION_FLAG,'N') = 'Y')
442: AND sua.person_id = cp_n_person_id
443: AND sca.course_cd = cp_c_program_cd
444: AND tt11.load_cal_type = cp_c_cal_type
445: AND tt11.load_ci_sequence_number = cp_n_seq_num