286: -- used in get_org_details
287: FUNCTION get_latest_engagement(p_org_id number) return varchar2 is
288: v_name varchar2(80);
289: BEGIN
290: select project_name into v_name from amw_audit_projects_v where audit_project_id =
291: (select entity_id from
292: (select distinct entity_id,creation_date from amw_Execution_scope
293: where entity_type='PROJECT' and organization_id=p_org_id
294: order by creation_date desc