APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_PE_HZ_PARTIES

Line 115: FROM igs_pe_HZ_parties pd, hz_parties p , hz_person_profiles pp ,

111: Pd.proof_of_ins , pd.proof_of_immu,
112: pp.date_of_birth birth_dt, p.known_as preferred_given_name,
113: pd.level_of_qual level_of_qual_id, pd.military_service_reg,
114: pd.veteran, e.application_date
115: FROM igs_pe_HZ_parties pd, hz_parties p , hz_person_profiles pp ,
116: igs_uc_applicants e
117: WHERE p.party_id = e.oss_person_id AND e.app_no = p_app_no AND
118: pp.party_id(+)=p.party_id AND p.party_id=pd.party_id(+) AND
119: SYSDATE BETWEEN NVL(pp.effective_start_date,SYSDATE) AND NVL(pp.effective_end_date,SYSDATE);