APPS.IGS_AS_GEN_005 dependencies on IGS_EN_SU_ATTEMPT

Line 111: FROM igs_en_su_attempt sua,

107: cp_acad_ci_seq_num igs_ps_ofr_pat.ci_sequence_number%TYPE
108: ) IS
109: SELECT cop.grading_schema_cd,
110: cop.gs_version_number
111: FROM igs_en_su_attempt sua,
112: igs_en_stdnt_ps_att sca,
113: igs_ps_unit_ofr_opt uoo,
114: igs_ps_ofr_pat cop
115: WHERE sua.person_id = p_person_id

Line 285: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE

281: cp_course_cd igs_as_su_atmpt_itm.course_cd%TYPE,
282: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
283: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
284: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
285: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
286: ) IS
287: SELECT suaai.ass_id,
288: suaai.unit_section_ass_item_id,
289: suaai.unit_ass_item_id

Line 291: igs_en_su_attempt_all sua

287: SELECT suaai.ass_id,
288: suaai.unit_section_ass_item_id,
289: suaai.unit_ass_item_id
290: FROM igs_as_su_atmpt_itm suaai,
291: igs_en_su_attempt_all sua
292: WHERE suaai.person_id = cp_person_id
293: AND suaai.course_cd = cp_course_cd
294: AND suaai.uoo_id = cp_uoo_id
295: AND sua.person_id = suaai.person_id

Line 314: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE

310: cp_unit_cd igs_as_su_atmpt_itm.unit_cd%TYPE,
311: cp_cal_type igs_as_su_atmpt_itm.cal_type%TYPE,
312: cp_ci_sequence_number igs_as_su_atmpt_itm.ci_sequence_number%TYPE,
313: cp_ass_id igs_as_su_atmpt_itm.ass_id%TYPE,
314: cp_uoo_id igs_en_su_attempt.uoo_id%TYPE
315: ) IS
316: SELECT suv.ass_id
317: FROM igs_as_uai_sua_v suv
318: WHERE suv.person_id = cp_person_id

Line 580: igs_en_su_attempt suav,

576: 10
577: )
578: )
579: FROM igs_en_stdnt_ps_att sca,
580: igs_en_su_attempt suav,
581: igs_ps_ofr_pat cop,
582: igs_ca_inst ci
583: WHERE sca.person_id = p_person_id
584: AND sca.course_cd = p_course_cd

Line 589: FROM igs_en_su_attempt sua

585: AND sca.person_id = suav.person_id
586: AND sca.course_cd = suav.course_cd
587: AND EXISTS (
588: SELECT 'X'
589: FROM igs_en_su_attempt sua
590: WHERE sua.person_id = suav.person_id
591: AND sua.course_cd = suav.course_cd
592: AND sua.uoo_id = suav.uoo_id
593: AND igs_as_gen_001.assp_val_sua_display

Line 665: igs_en_su_attempt suav,

661: v_max_year VARCHAR2 (10);
662: CURSOR c_sca IS
663: SELECT MAX (SUBSTR (igs_en_gen_014.enrs_get_acad_alt_cd (suav.cal_type, suav.ci_sequence_number), 1, 10)) acad_alternate_code
664: FROM igs_en_stdnt_ps_att sca,
665: igs_en_su_attempt suav,
666: igs_ps_ofr_pat cop,
667: igs_ca_inst ci
668: WHERE sca.person_id = p_person_id
669: AND sca.course_cd = p_course_cd

Line 673: FROM igs_en_su_attempt sua

669: AND sca.course_cd = p_course_cd
670: AND sca.person_id = suav.person_id
671: AND sca.course_cd = suav.course_cd
672: AND EXISTS ( SELECT 'X'
673: FROM igs_en_su_attempt sua
674: WHERE sua.person_id = suav.person_id
675: AND sua.course_cd = suav.course_cd
676: AND sua.uoo_id = suav.uoo_id
677: AND igs_as_gen_001.assp_val_sua_display (

Line 788: FROM igs_en_su_attempt_all sua,

784: sua.location_cd,
785: sua.unit_class,
786: uc.unit_mode,
787: sua.uoo_id
788: FROM igs_en_su_attempt_all sua,
789: igs_as_unit_class uc
790: WHERE sua.uoo_id = NVL(p_uoo_id,sua.uoo_id) AND
791: sua.unit_cd = p_unit_cd
792: AND sua.cal_type = p_cal_type

Line 873: FROM igs_en_su_attempt_all sua,

869: AND (suaai2.unit_section_ass_item_id = suaai.unit_section_ass_item_id
870: OR suaai2.unit_ass_item_id = suaai.unit_ass_item_id))
871: AND EXISTS (
872: SELECT 'X'
873: FROM igs_en_su_attempt_all sua,
874: igs_en_stdnt_ps_att sca,
875: igs_ps_ver crv
876: WHERE suaai.person_id = sua.person_id
877: AND suaai.course_cd = sua.course_cd