[Home] [Help]
509: and nvl(g_inc_org_hier_flag,'Y') = 'Y'
510: and pa.organization_id in (
511: select /*+ ORDERED */
512: distinct pose.organization_id_child
513: from per_organization_structures pos,
514: per_org_structure_versions posv,
515: per_org_structure_elements pose
516: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
517: and pos.primary_structure_flag = 'Y'
577: and nvl(g_inc_org_hier_flag,'Y') = 'Y'
578: and pa.organization_id in (
579: select /*+ ORDERED */
580: distinct pose.organization_id_child
581: from per_organization_structures pos,
582: per_org_structure_versions posv,
583: per_org_structure_elements pose
584: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
585: and pos.primary_structure_flag = 'Y'
649: and nvl(g_inc_org_hier_flag,'Y') = 'Y'
650: and pa.organization_id in (
651: select /*+ ORDERED */
652: distinct pose.organization_id_child
653: from per_organization_structures pos,
654: per_org_structure_versions posv,
655: per_org_structure_elements pose
656: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
657: and pos.primary_structure_flag = 'Y'
721: and nvl(g_inc_org_hier_flag,'Y') = 'Y'
722: and pa.organization_id in (
723: select /*+ ORDERED */
724: distinct pose.organization_id_child
725: from per_organization_structures pos,
726: per_org_structure_versions posv,
727: per_org_structure_elements pose
728: where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
729: and pos.primary_structure_flag = 'Y'