184:
185:
186: CURSOR cur_contact IS
187: SELECT 'Y' contact_ind
188: FROM igs_pe_sn_contact
189: WHERE disability_id = new_references.igs_pe_pers_disablty_id;
190: cur_contact_rec cur_contact%ROWTYPE;
191: l_contact_ind VARCHAR2(1);
192: -- End of fix
257:
258: PROCEDURE Check_Child_Existance AS
259: BEGIN
260:
261: igs_pe_sn_contact_pkg.get_fk_igs_pe_pers_disablty (
262: old_references.IGS_PE_PERS_DISABLTY_ID
263: );
264:
265: igs_pe_sn_service_pkg.get_fk_igs_pe_pers_disablty (