APPS.IGS_AS_GEN_007 dependencies on IGS_AS_UNIT_CLASS

Line 85: igs_as_unit_class ucl

81: sua.uoo_id
82: FROM igs_as_su_atmpt_itm suaai,
83: igs_en_su_attempt sua,
84: igs_as_assessmnt_itm ai,
85: igs_as_unit_class ucl
86: WHERE suaai.person_id = NVL (p_person_id, suaai.person_id)
87: AND suaai.logical_delete_dt IS NULL
88: AND suaai.attempt_number = (SELECT MAX (attempt_number)
89: FROM igs_as_su_atmpt_itm suaai2

Line 135: igs_as_unit_class uc

131: uai.unit_class,
132: uai.unit_mode
133: FROM igs_en_su_attempt sua,
134: igs_as_unitass_item uai,
135: igs_as_unit_class uc
136: WHERE sua.person_id = cp_person_id
137: AND sua.course_cd = cp_course_cd
138: AND sua.uoo_id = cp_uoo_id
139: AND uai.ass_id = cp_ass_id

Line 573: igs_as_unit_class uc

569: SELECT uai.REFERENCE
570: INTO v_uai_reference
571: FROM igs_en_su_attempt sua,
572: igs_as_unitass_item uai,
573: igs_as_unit_class uc
574: WHERE sua.person_id = v_suaai_rec.person_id
575: AND sua.course_cd = v_suaai_rec.course_cd
576: AND sua.uoo_id = v_suaai_rec.uoo_id
577: AND uai.ass_id = v_suaai_rec.ass_id

Line 855: igs_as_unit_class uc,

851: sua.uoo_id
852: FROM igs_pe_std_todo st,
853: igs_pe_std_todo_ref str,
854: igs_en_su_attempt_all sua,
855: igs_as_unit_class uc,
856: igs_ca_inst_rel cir
857: WHERE ((NVL (p_person_id, 9999999999) = 9999999999)
858: OR (st.person_id = p_person_id)
859: )

Line 1225: igs_as_unit_class uc,

1221: usai.gs_version_number
1222: FROM igs_ps_unitass_item usai,
1223: igs_as_assessmnt_itm ai,
1224: igs_ps_unit_ofr_opt uai,
1225: igs_as_unit_class uc,
1226: igs_ca_inst_rel cir
1227: WHERE usai.uoo_id = uai.uoo_id
1228: AND uai.unit_class = uc.unit_class
1229: AND uc.closed_ind = 'N'