APPS.IGS_EN_SUA_API dependencies on IGS_EN_STDNT_PS_ATT

Line 601: FROM igs_en_stdnt_ps_att

597: -- cursor that gets version number given person_id and course_cd
598: CURSOR cur_get_prog_ver(cp_person_id igs_en_su_attempt.person_id%TYPE,
599: cp_course_cd igs_en_su_attempt.course_cd%TYPE) IS
600: SELECT version_number
601: FROM igs_en_stdnt_ps_att
602: WHERE
603: person_id = cp_person_id AND
604: course_cd = cp_course_cd;
605:

Line 688: l_prog_version_spat igs_en_stdnt_ps_att.version_number%TYPE;

684: v_wlst_same_unit VARCHAR2(1);
685: v_simul_term_wlst_flag VARCHAR2(1);
686: v_simul_org_allwd VARCHAR2(1);
687:
688: l_prog_version_spat igs_en_stdnt_ps_att.version_number%TYPE;
689:
690: BEGIN
691:
692: OPEN usec_upd_enr_act(new_references.uoo_id);