APPS.IGS_PE_USERID_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 168: l_pref_alt_id IGS_PE_ALT_PERS_ID.API_PERSON_ID%TYPE;

164: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
165: l_last_name HZ_PARTIES. PERSON_LAST_NAME%TYPE;
166: l_middle_name HZ_PARTIES. PERSON_MIDDLE_NAME%TYPE;
167: l_pref_name HZ_PARTIES.KNOWN_AS%TYPE;
168: l_pref_alt_id IGS_PE_ALT_PERS_ID.API_PERSON_ID%TYPE;
169: l_title HZ_PERSON_PROFILES.PERSON_TITLE%TYPE;
170: l_prefix HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%TYPE;
171: l_suffix HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;
172: l_gender HZ_PERSON_PROFILES.GENDER%TYPE;

Line 1760: FROM igs_pe_alt_pers_id alt, igs_pe_person_id_typ typ

1756: l_zip_party_id HZ_PARTIES.PARTY_ID%TYPE;
1757:
1758: CURSOR c_pref_alt_id(cp_alt_id VARCHAR2) IS
1759: SELECT 1
1760: FROM igs_pe_alt_pers_id alt, igs_pe_person_id_typ typ
1761: WHERE alt.api_person_id = cp_alt_id
1762: AND typ.person_id_type = alt.person_id_type
1763: AND typ.preferred_ind = 'Y';
1764: l_alt_id_found NUMBER;