APPS.IGR_I_APPL_PKG dependencies on IGS_PE_HZ_PARTIES

Line 143: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS

139: SELECT birth_date
140: FROM igs_pe_person_base_v
141: WHERE person_id =p_person_id ;
142:
143: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
144: SELECT deceased_ind
145: FROM igs_pe_hz_parties
146: WHERE party_id = cp_party_id;
147: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

Line 145: FROM igs_pe_hz_parties

141: WHERE person_id =p_person_id ;
142:
143: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
144: SELECT deceased_ind
145: FROM igs_pe_hz_parties
146: WHERE party_id = cp_party_id;
147: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
148: v_message_name varchar2(30);
149: l_birth_date igs_pe_person_base_v.birth_date%TYPE;

Line 147: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

143: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
144: SELECT deceased_ind
145: FROM igs_pe_hz_parties
146: WHERE party_id = cp_party_id;
147: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
148: v_message_name varchar2(30);
149: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
150:
151: BEGIN