APPS.IGS_AD_IMP_ADM_DES dependencies on IGS_PE_HZ_PARTIES

Line 151: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd

147: AND (SYSDATE between typeinst.start_date AND NVL(typeinst.end_date,SYSDATE));
148:
149: CURSOR c_dmi (cp_person_id NUMBER) IS
150: SELECT 'X'
151: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd
152: WHERE base.person_id = cp_person_id
153: AND base.person_id = pd.party_id (+)
154: AND DECODE(base.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y') = 'Y';
155: