DBA Data[Home] [Help]

APPS.AMW_WF_HIERARCHY_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 2674: (select org_structure_version_id from per_org_structure_versions

2670: (select organization_id_child
2671: from
2672: (select organization_id_parent, organization_id_child from per_org_structure_elements
2673: where org_structure_version_id =
2674: (select org_structure_version_id from per_org_structure_versions
2675: where date_to is null and organization_structure_id =
2676: (select organization_structure_id from per_organization_structures where name = hier_name)))
2677: start with organization_id_parent = l_org
2678: connect by organization_id_parent = prior organization_id_child);