APPS.IGS_GE_GEN_003 dependencies on IGS_AS_SU_SETATMPT

Line 870: FROM igs_as_su_setatmpt

866: -- This cursor will fetch no records when the unit set attempt is not exists in the system
867: -- or more than one unit set attempt is matching the criteria.
868: CURSOR cur_susa_dtl IS
869: SELECT us_version_number,sequence_number
870: FROM igs_as_su_setatmpt
871: WHERE person_id = p_person_id
872: AND course_cd = p_program_cd
873: AND unit_set_cd = p_unit_set_cd
874: AND 1 = (SELECT COUNT(*)

Line 875: FROM igs_as_su_setatmpt

871: WHERE person_id = p_person_id
872: AND course_cd = p_program_cd
873: AND unit_set_cd = p_unit_set_cd
874: AND 1 = (SELECT COUNT(*)
875: FROM igs_as_su_setatmpt
876: WHERE person_id = p_person_id
877: AND course_cd = p_program_cd
878: AND unit_set_cd = p_unit_set_cd);
879: