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

Line 1504: FROM hz_person_profiles hzpp,

1500: hzpp.gender,
1501: prt.birth_country,
1502: hzc.country_code,
1503: prt.birth_city
1504: FROM hz_person_profiles hzpp,
1505: hz_citizenship hzc,
1506: igs_pe_hz_parties prt
1507: WHERE hzpp.party_id = p_person_rec.person_id
1508: AND prt.party_id = hzpp.party_id

Line 1542: l_last_name hz_person_profiles.person_last_name%TYPE;

1538: FROM igs_pe_stat_details psd
1539: WHERE psd.person_id = cp_person_id;
1540:
1541:
1542: l_last_name hz_person_profiles.person_last_name%TYPE;
1543: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1544: l_first_name hz_person_profiles.person_first_name%TYPE;
1545: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1546: l_birth_date hz_person_profiles.date_of_birth%TYPE;

Line 1543: l_middle_name hz_person_profiles.person_middle_name%TYPE;

1539: WHERE psd.person_id = cp_person_id;
1540:
1541:
1542: l_last_name hz_person_profiles.person_last_name%TYPE;
1543: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1544: l_first_name hz_person_profiles.person_first_name%TYPE;
1545: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1546: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1547: l_birth_city igs_pe_hz_parties.birth_city%TYPE;

Line 1544: l_first_name hz_person_profiles.person_first_name%TYPE;

1540:
1541:
1542: l_last_name hz_person_profiles.person_last_name%TYPE;
1543: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1544: l_first_name hz_person_profiles.person_first_name%TYPE;
1545: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1546: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1547: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1548: l_gender hz_person_profiles.gender%TYPE;

Line 1545: l_suffix hz_person_profiles.person_name_suffix%TYPE;

1541:
1542: l_last_name hz_person_profiles.person_last_name%TYPE;
1543: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1544: l_first_name hz_person_profiles.person_first_name%TYPE;
1545: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1546: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1547: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1548: l_gender hz_person_profiles.gender%TYPE;
1549: l_birth_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type

Line 1546: l_birth_date hz_person_profiles.date_of_birth%TYPE;

1542: l_last_name hz_person_profiles.person_last_name%TYPE;
1543: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1544: l_first_name hz_person_profiles.person_first_name%TYPE;
1545: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1546: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1547: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1548: l_gender hz_person_profiles.gender%TYPE;
1549: l_birth_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1550: l_citizen_cntry_code hz_citizenship.country_code%TYPE;

Line 1548: l_gender hz_person_profiles.gender%TYPE;

1544: l_first_name hz_person_profiles.person_first_name%TYPE;
1545: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1546: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1547: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1548: l_gender hz_person_profiles.gender%TYPE;
1549: l_birth_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1550: l_citizen_cntry_code hz_citizenship.country_code%TYPE;
1551: l_visa_type IGS_PE_VISA.visa_type%TYPE;
1552: l_commuter VARCHAR2(1); -- ASAP need new column and table to get type