eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_USERID_PKG dependencies on HZ_PERSON_PROFILES

Line 169: l_title HZ_PERSON_PROFILES.PERSON_TITLE%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;
173: l_birth_date DATE;

Line 170: l_prefix HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%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;
173: l_birth_date DATE;
174: l_email_address HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;

Line 172: l_gender HZ_PERSON_PROFILES.GENDER%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;
173: l_birth_date DATE;
174: l_email_address HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
175: l_email_format HZ_CONTACT_POINTS.EMAIL_FORMAT%TYPE;
176: l_test_user_name FND_USER.USER_NAME%TYPE;

Line 1769: FROM igs_pe_person_id_type_v alt, hz_parties hz, hz_person_profiles hzp

1765:
1766: CURSOR c_dup_zip(cp_first_name VARCHAR2, cp_last_name VARCHAR2, cp_birth_date VARCHAR2, cp_pref_alt_id VARCHAR2,
1767: cp_person_num VARCHAR2, cp_gender VARCHAR2, cp_zipcode VARCHAR2) IS
1768: SELECT count(*), max(hz.party_id)
1769: FROM igs_pe_person_id_type_v alt, hz_parties hz, hz_person_profiles hzp
1770: WHERE hz.party_id = alt.pe_person_id(+)
1771: AND UPPER(hz.person_first_name) = UPPER(cp_first_name)
1772: AND UPPER(hz.person_last_name) = UPPER(cp_last_name)
1773: AND NVL(hzp.date_of_birth,l_default_date) = NVL(cp_birth_date,l_default_date)