926: (p_org_structure_id IN NUMBER,
927: p_org_structure_version_id OUT NOCOPY NUMBER) is
928: Cursor c1 is
929: Select org_structure_version_id
930: From per_org_structure_versions
931: Where organization_structure_id = p_org_structure_id
932: AND version_number =
933: (select max(version_number)
934: From per_org_structure_versions
930: From per_org_structure_versions
931: Where organization_structure_id = p_org_structure_id
932: AND version_number =
933: (select max(version_number)
934: From per_org_structure_versions
935: Where organization_structure_id = p_org_structure_id);
936: Begin
937: --
938: Open c1;
952: --
953: l_proc varchar2(72) := g_package||'chk_org_in_org_structure';
954: l_dummy varchar2(1);
955: l_api_updating boolean;
956: l_org_structure_version_id per_org_structure_versions.org_structure_version_id%type;
957: --
958: Cursor c1 is
959: Select null
960: FROM per_org_structure_elements a