APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_HZ_PARTIES

Line 1506: igs_pe_hz_parties prt

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
1510: AND sysdate between hzpp.effective_start_date AND NVL(hzpp.effective_end_date,sysdate+1);

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