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_SV_NI_BATCH_PROCESS_PKG dependencies on HZ_PERSON_PROFILES

Line 1282: FROM hz_person_profiles hzpp,

1278: hzpp.gender,
1279: prt.birth_country,
1280: hzc.country_code,
1281: prt.birth_city
1282: FROM hz_person_profiles hzpp,
1283: hz_citizenship hzc,
1284: igs_pe_hz_parties prt
1285: WHERE hzpp.party_id = p_person_rec.person_id
1286: AND prt.party_id = hzpp.party_id

Line 1320: l_last_name hz_person_profiles.person_last_name%TYPE;

1316: FROM igs_pe_stat_details psd
1317: WHERE psd.person_id = cp_person_id;
1318:
1319:
1320: l_last_name hz_person_profiles.person_last_name%TYPE;
1321: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1322: l_first_name hz_person_profiles.person_first_name%TYPE;
1323: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1324: l_birth_date hz_person_profiles.date_of_birth%TYPE;

Line 1321: l_middle_name hz_person_profiles.person_middle_name%TYPE;

1317: WHERE psd.person_id = cp_person_id;
1318:
1319:
1320: l_last_name hz_person_profiles.person_last_name%TYPE;
1321: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1322: l_first_name hz_person_profiles.person_first_name%TYPE;
1323: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1324: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1325: l_birth_city igs_pe_hz_parties.birth_city%TYPE;

Line 1322: l_first_name hz_person_profiles.person_first_name%TYPE;

1318:
1319:
1320: l_last_name hz_person_profiles.person_last_name%TYPE;
1321: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1322: l_first_name hz_person_profiles.person_first_name%TYPE;
1323: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1324: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1325: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1326: l_gender hz_person_profiles.gender%TYPE;

Line 1323: l_suffix hz_person_profiles.person_name_suffix%TYPE;

1319:
1320: l_last_name hz_person_profiles.person_last_name%TYPE;
1321: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1322: l_first_name hz_person_profiles.person_first_name%TYPE;
1323: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1324: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1325: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1326: l_gender hz_person_profiles.gender%TYPE;
1327: l_birth_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type

Line 1324: l_birth_date hz_person_profiles.date_of_birth%TYPE;

1320: l_last_name hz_person_profiles.person_last_name%TYPE;
1321: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1322: l_first_name hz_person_profiles.person_first_name%TYPE;
1323: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1324: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1325: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1326: l_gender hz_person_profiles.gender%TYPE;
1327: l_birth_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1328: l_citizen_cntry_code hz_citizenship.country_code%TYPE;

Line 1326: l_gender hz_person_profiles.gender%TYPE;

1322: l_first_name hz_person_profiles.person_first_name%TYPE;
1323: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1324: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1325: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1326: l_gender hz_person_profiles.gender%TYPE;
1327: l_birth_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1328: l_citizen_cntry_code hz_citizenship.country_code%TYPE;
1329: l_visa_type IGS_PE_VISA.visa_type%TYPE;
1330: l_commuter VARCHAR2(1); -- ASAP need new column and table to get type