APPS.IGS_AD_VAL_ACAI dependencies on IGS_PE_PERSON_BASE_V

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:

Line 4447: FROM IGS_PE_PERSON_BASE_V pe

4443: v_valid_excurr BOOLEAN := FALSE;
4444: CURSOR c_pe IS
4445: SELECT pe.birth_date birth_dt,
4446: pe.title
4447: FROM IGS_PE_PERSON_BASE_V pe
4448: WHERE pe.person_id = p_person_id;
4449: v_list_element VARCHAR2(30);
4450: BEGIN
4451: --set default message number