APPS.INV_ORGHIERARCHY_PVT dependencies on PER_ORGANIZATION_STRUCTURES

Line 369: , per_organization_structures hier

365: , l_include_origin_flag
366: , l_sec_origin_org_id
367: FROM
368: per_security_profiles prof
369: , per_organization_structures hier
370: WHERE
371: prof.security_profile_id = l_security_profile_id
372: AND hier.organization_structure_id (+) = prof.organization_structure_id
373: ;

Line 499: , per_organization_structures s

495: SELECT
496: sv.org_structure_version_id
497: FROM
498: per_org_structure_versions sv
499: , per_organization_structures s
500: WHERE
501: sv.organization_structure_id = s.organization_structure_id
502: AND SYSDATE >= sv.date_from
503: AND ( SYSDATE <= sv.date_to

Line 591: per_organization_structures pos

587: psp.view_all_organizations_flag,
588: psp.include_top_organization_flag,
589: psp.organization_id
590: FROM per_security_profiles psp,
591: per_organization_structures pos
592: WHERE psp.security_profile_id = FND_PROFILE.value('PER_SECURITY_PROFILE_ID')
593: AND pos.organization_structure_id(+) = psp.organization_structure_id;
594:
595: BEGIN

Line 782: per_organization_structures pos

778: psp.view_all_organizations_flag,
779: psp.include_top_organization_flag,
780: psp.organization_id
781: FROM per_security_profiles psp,
782: per_organization_structures pos
783: WHERE psp.security_profile_id = FND_PROFILE.value('PER_SECURITY_PROFILE_ID')
784: AND pos.organization_structure_id(+) = psp.organization_structure_id;
785:
786:

Line 995: PER_ORGANIZATION_STRUCTURES OS

991: OSV.org_structure_version_id
992: , OSV.business_group_id
993: FROM
994: PER_ORG_STRUCTURE_VERSIONS OSV,
995: PER_ORGANIZATION_STRUCTURES OS
996: WHERE
997: OSV.ORGANIZATION_STRUCTURE_ID = OS.ORGANIZATION_STRUCTURE_ID
998:
999: -- rschaub: replaced NVL and date truncation so date index is used