APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_AS_SU_SETATMPT

Line 3337: FROM igs_as_su_setatmpt susa

3333: FUNCTION get_latest_yop (p_person_id hz_parties.party_id%TYPE, p_course_cd igs_ps_ver.course_cd%TYPE)
3334: RETURN VARCHAR2 IS
3335: CURSOR c_susa IS
3336: SELECT susa.unit_set_cd
3337: FROM igs_as_su_setatmpt susa
3338: WHERE susa.person_id = p_person_id
3339: AND susa.course_cd = p_course_cd
3340: ORDER BY susa.selection_dt DESC;
3341: l_yop VARCHAR2 (10);