DBA Data[Home] [Help]

APPS.PA_ADVERTISEMENTS_PVT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 541: FROM per_org_structure_elements

537: -- cursor to get the next organization up in the
538: -- specified Organization Hierarchy
539: CURSOR get_next_start_org(c_org_hierarchy_version_id NUMBER, c_start_org_id NUMBER) IS
540: SELECT organization_id_parent
541: FROM per_org_structure_elements
542: WHERE org_structure_version_id = c_org_hierarchy_version_id
543: AND organization_id_child = c_start_org_id;
544:
545: -- cursor to get all organizations under the specified starting