APPS.IGR_I_A_CHARTYP_PKG dependencies on IGS_PE_HZ_PARTIES

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

68: p_inserting IN BOOLEAN DEFAULT FALSE,
69: p_updating IN BOOLEAN DEFAULT FALSE,
70: p_deleting IN BOOLEAN DEFAULT FALSE
71: ) as
72: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
73: SELECT deceased_ind
74: FROM igs_pe_hz_parties
75: WHERE party_id = cp_party_id;
76: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

Line 74: FROM igs_pe_hz_parties

70: p_deleting IN BOOLEAN DEFAULT FALSE
71: ) as
72: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
73: SELECT deceased_ind
74: FROM igs_pe_hz_parties
75: WHERE party_id = cp_party_id;
76: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
77: v_message_name varchar2(30);
78: BEGIN

Line 76: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;

72: CURSOR c_deceased(cp_party_id igs_pe_hz_parties.party_id%TYPE) IS
73: SELECT deceased_ind
74: FROM igs_pe_hz_parties
75: WHERE party_id = cp_party_id;
76: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
77: v_message_name varchar2(30);
78: BEGIN
79: -- Fetch the Deceased Indicator
80: OPEN c_deceased(new_references.person_id);