APPS.IGS_EN_SVS_AUTH_PKG dependencies on HZ_PARTIES

Line 40: CURSOR c_max_auth_no (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS

36: SELECT *
37: FROM igs_en_svs_auth
38: WHERE rowid = x_rowid;
39:
40: CURSOR c_max_auth_no (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
41: SELECT SEVIS_AUTHORIZATION_NO
42: FROM igs_en_svs_auth esa1
43: WHERE person_id = cp_person_id
44: AND SEVIS_AUTHORIZATION_NO = (SELECT max(SEVIS_AUTHORIZATION_NO)