113: -------------------------------------------------------------------
114:
115: cursor cur_deceased_hold(cp_person_id NUMBER) is
116: SELECT DECODE(pp.date_of_death, NULL,NVL(pd.deceased_ind,'N'),'Y') deceased_flag,
117: igs_en_gen_003.enrp_get_encmbrd_ind(p.party_id) encumbered_ind,
118: p.status status
119: FROM hz_parties p,
120: igs_pe_hz_parties pd,
121: hz_person_profiles pp
197: ELSE
198: -- If party account is present then
199: -- check whether the person is an Active Staff.
200: -- If not then RETURN with setting the message
201: l_staff := igs_en_gen_003.get_staff_ind(p_person_id);
202:
203: IF l_staff = 'N' THEN
204: p_message_name := 'IGS_PE_HOLD_AUTH_CR';
205: RETURN;