APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on HZ_CITIZENSHIP

Line 1505: hz_citizenship hzc,

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
1509: AND hzc.party_id (+) = hzpp.party_id

Line 1550: l_citizen_cntry_code hz_citizenship.country_code%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
1553: l_legal_res_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1554: l_position_code IGS_PE_EV_FORM.position_code%TYPE;