DBA Data[Home] [Help]

APPS.INV_ORGHIERARCHY_PVT dependencies on PER_SECURITY_PROFILES

Line 371: per_security_profiles prof

367: , l_view_all_flag
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

Line 646: FROM per_security_profiles psp,

642: SELECT pos.name,
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:

Line 950: FROM per_security_profiles psp,

946: SELECT pos.name,
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: