APPS.IGS_AS_GEN_005 dependencies on IGS_AS_COURSE_TYPE_ALL

Line 820: FROM igs_as_course_type_all

816: v_message_name VARCHAR2 (30);
817: v_valid_ass_item BOOLEAN;
818: CURSOR cur_as_prg_type (cp_ass_id IN NUMBER) IS
819: SELECT 'X' record_exists
820: FROM igs_as_course_type_all
821: WHERE ass_id = cp_ass_id;
822: rec_as_prg_type cur_as_prg_type%ROWTYPE;
823: BEGIN
824: -- For unit testing, it will be necessary to set p_s_log_type = 'ASS3213',

Line 886: FROM igs_as_course_type_all act

882: AND sca.version_number = crv.version_number
883: AND sua.unit_attempt_status IN ('ENROLLED', 'UNCONFIRM', 'WAITLISTED')
884: AND EXISTS (
885: SELECT 'X'
886: FROM igs_as_course_type_all act
887: WHERE act.course_type <> crv.course_type
888: AND act.ass_id = suaai.ass_id
889: ));
890: p_warning_count := SQL%ROWCOUNT;