APPS.INV_ORGHIERARCHY_PVT dependencies on PER_ORGANIZATION_STRUCTURES

Line 372: , per_organization_structures hier

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

Line 502: , per_organization_structures s

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

Line 647: per_organization_structures pos

643: psp.view_all_organizations_flag,
644: psp.include_top_organization_flag,
645: psp.organization_id
646: FROM per_security_profiles psp,
647: per_organization_structures pos
648: WHERE psp.security_profile_id = FND_PROFILE.value('PER_SECURITY_PROFILE_ID')
649: AND pos.organization_structure_id(+) = psp.organization_structure_id;
650:
651: BEGIN

Line 951: per_organization_structures pos

947: psp.view_all_organizations_flag,
948: psp.include_top_organization_flag,
949: psp.organization_id
950: FROM per_security_profiles psp,
951: per_organization_structures pos
952: WHERE psp.security_profile_id = FND_PROFILE.value('PER_SECURITY_PROFILE_ID')
953: AND pos.organization_structure_id(+) = psp.organization_structure_id;
954:
955:

Line 1278: PER_ORGANIZATION_STRUCTURES OS

1274: OSV.org_structure_version_id
1275: , OSV.business_group_id
1276: FROM
1277: PER_ORG_STRUCTURE_VERSIONS OSV,
1278: PER_ORGANIZATION_STRUCTURES OS
1279: WHERE
1280: OSV.ORGANIZATION_STRUCTURE_ID = OS.ORGANIZATION_STRUCTURE_ID
1281:
1282: -- rschaub: replaced NVL and date truncation so date index is used