APPS.HR_US_REPORTS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 1249: FROM per_org_structure_elements ose

1245: -- Fixed connect by so connect by loop not raised.
1246: --
1247: CURSOR get_parent IS
1248: SELECT ose.organization_id_parent
1249: FROM per_org_structure_elements ose
1250: WHERE ose.org_structure_version_id = p_org_structure_version_id
1251: START WITH ose.organization_id_child = p_starting_org_id
1252: CONNECT BY PRIOR ose.organization_id_parent = ose.organization_id_child
1253: AND ose.org_structure_version_id = p_org_structure_version_id;

Line 1317: FROM per_org_structure_elements ose

1313: -- Fixed connect by so connect by loop not raised.
1314: --
1315: CURSOR get_hr_parent IS
1316: SELECT ose.organization_id_parent
1317: FROM per_org_structure_elements ose
1318: WHERE ose.org_structure_version_id = p_org_structure_version_id
1319: START WITH ose.organization_id_child = p_starting_org_id
1320: CONNECT BY PRIOR ose.organization_id_parent = ose.organization_id_child
1321: AND ose.org_structure_version_id = p_org_structure_version_id;

Line 1590: from per_org_structure_elements

1586: --
1587: --
1588: cursor csr_get_parent(l_organization_id_child number) is
1589: select organization_id_parent
1590: from per_org_structure_elements
1591: where business_group_id = p_business_group_id
1592: and org_structure_version_id = p_org_structure_version_id
1593: and organization_id_child = l_organization_id_child;
1594:

Line 1597: from per_org_structure_elements

1593: and organization_id_child = l_organization_id_child;
1594:
1595: cursor csr_get_element is
1596: select '1'
1597: from per_org_structure_elements
1598: where business_group_id = p_business_group_id
1599: and org_structure_version_id = p_org_structure_version_id;
1600:
1601: cursor csr_get_max_child_id is

Line 1603: from per_org_structure_elements

1599: and org_structure_version_id = p_org_structure_version_id;
1600:
1601: cursor csr_get_max_child_id is
1602: select max(organization_id_child)
1603: from per_org_structure_elements
1604: where business_group_id = p_business_group_id
1605: and org_structure_version_id = p_org_structure_version_id;
1606:
1607: --