APPS.IGS_HE_IMPORT_DATA dependencies on HZ_PARTIES

Line 29: FROM hz_parties p , hz_person_profiles pp

25: SELECT p.party_id person_id, p.person_last_name surname,
26: p.person_first_name given_names,
27: pp.gender sex,
28: pp.date_of_birth birth_dt
29: FROM hz_parties p , hz_person_profiles pp
30: WHERE p.party_number = cp_person_number AND
31: pp.party_id(+)=p.party_id AND
32: SYSDATE BETWEEN NVL(pp.effective_start_date,SYSDATE) AND NVL(pp.effective_end_date,SYSDATE);
33: c_pe_det_rec c_pe_det%ROWTYPE ;

Line 1172: FROM igs_pe_alt_pers_id , hz_parties

1168: -- Get the person id for the passed alternate person id
1169: CURSOR c_alt_persid( cp_persid_type igs_pe_alt_pers_id.person_id_type%TYPE,
1170: cp_person_id igs_pe_alt_pers_id.api_person_id%TYPE ) IS
1171: SELECT party_number person_number
1172: FROM igs_pe_alt_pers_id , hz_parties
1173: WHERE person_id_type = cp_persid_type AND
1174: api_person_id = cp_person_id AND
1175: NVL(start_dt,SYSDATE) <= SYSDATE AND
1176: end_dt IS NULL AND