APPS.IGS_AD_VAL_ACAI dependencies on IGS_PE_HZ_PARTIES

Line 2935: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd

2931: lv_pe_typ_cd pe_typ_cd%RowType;
2932:
2933: CURSOR c_dmi IS
2934: SELECT 'X'
2935: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd
2936: WHERE base.person_id = p_person_id
2937: AND base.person_id = pd.party_id (+)
2938: AND DECODE(base.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y') = 'Y';
2939:

Line 2979: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd

2975: lv_pe_typ_cd pe_typ_cd%RowType;
2976:
2977: CURSOR c_dmi IS
2978: SELECT 'X'
2979: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd
2980: WHERE base.person_id = p_person_id
2981: AND base.person_id = pd.party_id (+)
2982: AND DECODE(base.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y') = 'Y';
2983: