64: SELECT deceased_ind
65: FROM igs_pe_hz_parties
66: WHERE party_id = cp_party_id;
67:
68: CURSOR c_information_type (p_info_type_id igr_i_info_types_v.info_type_id%TYPE) IS
69: SELECT information_type
70: FROM igr_i_info_types_v
71: WHERE info_type_id =p_info_type_id ;
72:
66: WHERE party_id = cp_party_id;
67:
68: CURSOR c_information_type (p_info_type_id igr_i_info_types_v.info_type_id%TYPE) IS
69: SELECT information_type
70: FROM igr_i_info_types_v
71: WHERE info_type_id =p_info_type_id ;
72:
73: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
74: v_message_name varchar2(30);
71: WHERE info_type_id =p_info_type_id ;
72:
73: v_deceased_ind igs_pe_hz_parties.deceased_ind%TYPE;
74: v_message_name varchar2(30);
75: p_enquiry_information_type igr_i_info_types_v.information_type%TYPE;
76: BEGIN
77: -- Fetch the Deceased Indicator
78: OPEN c_deceased(new_references.person_id);
79: FETCH c_deceased INTO v_deceased_ind;