APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 514: per_org_structure_versions posv,

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'
518: and posv.organization_structure_id = pos.organization_structure_id

Line 523: from per_org_structure_versions posv2

519: and posv.date_from <= g_effective_date
520: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date
521: and not exists(
522: select null
523: from per_org_structure_versions posv2
524: where posv2.organization_structure_id = pos.organization_structure_id
525: and posv2.date_from <= g_effective_date
526: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date
527: and posv2.version_number > posv.version_number)

Line 582: per_org_structure_versions posv,

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'
586: and posv.organization_structure_id = pos.organization_structure_id

Line 591: from per_org_structure_versions posv2

587: and posv.date_from <= g_effective_date
588: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date
589: and not exists(
590: select null
591: from per_org_structure_versions posv2
592: where posv2.organization_structure_id = pos.organization_structure_id
593: and posv2.date_from <= g_effective_date
594: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date
595: and posv2.version_number > posv.version_number)

Line 654: per_org_structure_versions posv,

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'
658: and posv.organization_structure_id = pos.organization_structure_id

Line 663: from per_org_structure_versions posv2

659: and posv.date_from <= g_effective_date
660: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date
661: and not exists(
662: select null
663: from per_org_structure_versions posv2
664: where posv2.organization_structure_id = pos.organization_structure_id
665: and posv2.date_from <= g_effective_date
666: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date
667: and posv2.version_number > posv.version_number)

Line 726: per_org_structure_versions posv,

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'
730: and posv.organization_structure_id = pos.organization_structure_id

Line 735: from per_org_structure_versions posv2

731: and posv.date_from <= g_effective_date
732: and nvl(posv.date_to,hr_api.g_eot) >= g_effective_date
733: and not exists(
734: select null
735: from per_org_structure_versions posv2
736: where posv2.organization_structure_id = pos.organization_structure_id
737: and posv2.date_from <= g_effective_date
738: and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_date
739: and posv2.version_number > posv.version_number)