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 IGS_PE_HZ_PARTIES

Line 1284: igs_pe_hz_parties prt

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
1287: AND hzc.party_id (+) = hzpp.party_id
1288: AND sysdate between hzpp.effective_start_date AND NVL(hzpp.effective_end_date,sysdate+1);

Line 1325: l_birth_city igs_pe_hz_parties.birth_city%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;
1329: l_visa_type IGS_PE_VISA.visa_type%TYPE;