DBA Data[Home] [Help]

APPS.AMW_WF_HIERARCHY_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 2672: (select organization_id_parent, organization_id_child from per_org_structure_elements

2668: select 1 into l_dummy
2669: from dual where p_org_id in
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)))