361: Procedure get_org_structure_version_id (p_org_structure_id IN NUMBER,
362: p_org_structure_version_id OUT nocopy NUMBER) is
363: Cursor c1 is
364: Select org_structure_version_id
365: From per_org_structure_versions
366: Where organization_structure_id = p_org_structure_id
367: AND version_number =
368: (select max(version_number)
369: From per_org_structure_versions
365: From per_org_structure_versions
366: Where organization_structure_id = p_org_structure_id
367: AND version_number =
368: (select max(version_number)
369: From per_org_structure_versions
370: Where organization_structure_id = p_org_structure_id);
371: --
372: l_proc varchar2(72) := g_package||'g_org_structure_version_id';
373: --