APPS.IGS_AS_GEN_007 dependencies on IGS_AS_VAL_UAI

Line 147: AND igs_as_val_uai.assp_val_sua_ai_acot (uai.ass_id, sua.person_id, sua.course_cd) = 'TRUE';

143: AND sua.cal_type = uai.cal_type
144: AND sua.ci_sequence_number = uai.ci_sequence_number
145: AND sua.unit_class = uc.unit_class
146: AND uc.closed_ind = 'N'
147: AND igs_as_val_uai.assp_val_sua_ai_acot (uai.ass_id, sua.person_id, sua.course_cd) = 'TRUE';
148: --
149: CURSOR c_lock_suaai (
150: cp_person_id igs_en_su_attempt.person_id%TYPE,
151: cp_course_cd igs_en_su_attempt.course_cd%TYPE,

Line 585: AND igs_as_val_uai.assp_val_sua_ai_acot (uai.ass_id, sua.person_id, sua.course_cd) = 'TRUE';

581: AND sua.cal_type = uai.cal_type
582: AND sua.ci_sequence_number = uai.ci_sequence_number
583: AND sua.unit_class = uc.unit_class
584: AND uc.closed_ind = 'N'
585: AND igs_as_val_uai.assp_val_sua_ai_acot (uai.ass_id, sua.person_id, sua.course_cd) = 'TRUE';
586: v_record := TO_CHAR (v_suaai_rec.person_id)
587: || '|'
588: || v_suaai_rec.course_cd
589: || '|'