APPS.IGS_AS_GEN_007 dependencies on IGS_AS_GEN_002

Line 117: AND igs_as_gen_002.assp_get_ai_s_type (ai.ass_id) = 'ASSIGNMENT';

113: sua.ci_sequence_number,
114: 'Y'
115: ) = 'Y'
116: AND suaai.ass_id = ai.ass_id
117: AND igs_as_gen_002.assp_get_ai_s_type (ai.ass_id) = 'ASSIGNMENT';
118: --
119: CURSOR c_sua_uai_v (
120: cp_person_id igs_en_su_attempt.person_id%TYPE,
121: cp_course_cd igs_en_su_attempt.course_cd%TYPE,