DBA Data[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: