318: /*
319: OLD CODE, removed for performance bug 3666795
320: SELECT r.name
321: INTO X_approval_list_name
322: FROM wf_roles r, eng_engineering_changes eec, eng_ecn_approval_lists al
323: WHERE eec.approval_list_id = al.approval_list_id
324: AND eec.organization_id = X_org_id
325: AND eec.change_notice = X_change_notice
326: AND al.approval_list_name = r.display_name ;
332: select r.name
333: INTO X_approval_list_name
334: from wf_local_roles r
335: where r.display_name in (SELECT al.approval_list_name
336: FROM eng_ecn_approval_lists al, eng_engineering_changes eec
337: WHERE eec.approval_list_id = al.approval_list_id
338: AND eec.organization_id = X_org_id
339: AND eec.change_notice = X_change_notice) ;
340: Exception