DBA Data[Home] [Help]

APPS.HR_SECURITY_INTERNAL dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 3653: FROM per_org_structure_elements o

3649: -- organization and a hierarchy version.
3650: --
3651: CURSOR csr_get_orgs_in_hier IS
3652: SELECT o.organization_id_child
3653: FROM per_org_structure_elements o
3654: CONNECT BY o.organization_id_parent = PRIOR o.organization_id_child
3655: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
3656: START WITH o.organization_id_parent = p_top_organization_id
3657: AND o.org_structure_version_id = p_org_structure_version_id;

Line 3664: FROM per_org_structure_elements o

3660: -- Check if the top organization is in the hierarchy.
3661: --
3662: CURSOR csr_top_org_in_hier IS
3663: SELECT NULL
3664: FROM per_org_structure_elements o
3665: WHERE o.org_structure_version_id = p_org_structure_version_id
3666: AND o.organization_id_child = p_top_organization_id
3667: AND rownum = 1;
3668: