DBA Data[Home] [Help]

APPS.HR_SECURITY_INTERNAL dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 3693: FROM per_org_structure_elements o

3689: -- organization and a hierarchy version.
3690: --
3691: CURSOR csr_get_orgs_in_hier IS
3692: SELECT o.organization_id_child
3693: FROM per_org_structure_elements o
3694: CONNECT BY o.organization_id_parent = PRIOR o.organization_id_child
3695: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
3696: START WITH o.organization_id_parent = p_top_organization_id
3697: AND o.org_structure_version_id = p_org_structure_version_id;

Line 3704: FROM per_org_structure_elements o

3700: -- Check if the top organization is in the hierarchy.
3701: --
3702: CURSOR csr_top_org_in_hier IS
3703: SELECT NULL
3704: FROM per_org_structure_elements o
3705: WHERE o.org_structure_version_id = p_org_structure_version_id
3706: AND o.organization_id_child = p_top_organization_id
3707: AND rownum = 1;
3708: