DBA Data[Home] [Help]

APPS.INV_ORGHIERARCHY_PVT dependencies on PER_SECURITY_PROFILES

Line 368: per_security_profiles prof

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

Line 590: FROM per_security_profiles psp,

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

Line 781: FROM per_security_profiles psp,

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