APPS.IGS_UC_EXPORT_TO_OSS dependencies on 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);

Line 2297: FROM igs_uc_applicants a, hz_parties b

2293:
2294: /* Cursors used to import domicile code */
2295: CURSOR cur_app_dtls(cp_app_no igs_uc_applicants.app_no%TYPE) IS
2296: SELECT a.oss_person_id, a.domicile_apr, b.party_number
2297: FROM igs_uc_applicants a, hz_parties b
2298: WHERE a.oss_person_id = b.party_id
2299: AND app_no = cp_app_no;
2300: l_app_dtls cur_app_dtls%ROWTYPE;
2301: