[Home] [Help]
APPS.IGS_AS_SUARC_LGCY_PUB dependencies on IGS_EN_SU_ATTEMPT_ALL
Line 313: l_sua_status igs_en_su_attempt_all.unit_attempt_status%TYPE;
309: l_msg_data VARCHAR2(2000);
310: l_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
311: l_ref_cd_id NUMBER;
312: L_EXISTS VARCHAR2(30);
313: l_sua_status igs_en_su_attempt_all.unit_attempt_status%TYPE;
314:
315: CURSOR cur_sua_status
316: IS
317: SELECT unit_attempt_status
Line 318: FROM igs_en_su_attempt_all
314:
315: CURSOR cur_sua_status
316: IS
317: SELECT unit_attempt_status
318: FROM igs_en_su_attempt_all
319: where person_id = l_person_id
320: AND course_cd =p_suarc_dtls_rec.program_cd
321: AND uoo_id = l_uoo_id ;
322: