eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BUDGET_ANALYSIS_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 74: (select null from per_org_structure_elements e

70: FROM HR_ALL_ORGANIZATION_UNITS u
71: WHERE ORGANIZATION_ID = p_start_org_id
72: and business_group_id = p_business_group_id
73: and exists
74: (select null from per_org_structure_elements e
75: where e.org_structure_version_id = p_org_structure_version_id
76: and (e.organization_id_child = p_start_org_id
77: or e.organization_id_parent = p_start_org_id) )
78: UNION

Line 83: FROM PER_ORG_STRUCTURE_ELEMENTS A

79: SELECT
80: rownum rn,
81: level level1,
82: organization_id_child organization_id
83: FROM PER_ORG_STRUCTURE_ELEMENTS A
84: start with
85: organization_id_parent = p_start_org_id
86: and ORG_STRUCTURE_VERSION_ID = p_org_structure_version_id
87: connect by

Line 1379: from per_org_structure_elements a

1375: -- Cursor to fetch the top Org of Hierarchy
1376: --
1377: cursor c_top_org(p_org_structure_version_id number) is
1378: select organization_id_parent organization_id
1379: from per_org_structure_elements a
1380: where org_structure_version_id = p_org_structure_version_id
1381: and not exists (
1382: select organization_id_child organization_id
1383: from per_org_structure_elements b

Line 1383: from per_org_structure_elements b

1379: from per_org_structure_elements a
1380: where org_structure_version_id = p_org_structure_version_id
1381: and not exists (
1382: select organization_id_child organization_id
1383: from per_org_structure_elements b
1384: where org_structure_version_id = p_org_structure_version_id
1385: and b.organization_id_child = a.organization_id_parent
1386: )
1387: and rownum <2;

Line 1402: (select null from per_org_structure_elements e

1398: from hr_all_organization_units u
1399: where organization_id = p_start_org_id
1400: and business_group_id = p_business_group_id
1401: and exists
1402: (select null from per_org_structure_elements e
1403: where e.org_structure_version_id = p_org_structure_version_id
1404: and (e.organization_id_child = p_start_org_id
1405: or e.organization_id_parent = p_start_org_id ) )
1406: union

Line 1410: from per_org_structure_elements a

1406: union
1407: select rownum rn,
1408: level level1,
1409: organization_id_child organization_id
1410: from per_org_structure_elements a
1411: start with
1412: organization_id_parent = p_start_org_id
1413: and org_structure_version_id = p_org_structure_version_id
1414: connect by

Line 3289: from per_org_structure_elements a

3285: -- Cursor to fetch the top Org of Hierarchy
3286: --
3287: cursor c_top_org(p_org_structure_version_id number) is
3288: select organization_id_parent organization_id
3289: from per_org_structure_elements a
3290: where org_structure_version_id = p_org_structure_version_id
3291: and not exists (
3292: select organization_id_child organization_id
3293: from per_org_structure_elements b

Line 3293: from per_org_structure_elements b

3289: from per_org_structure_elements a
3290: where org_structure_version_id = p_org_structure_version_id
3291: and not exists (
3292: select organization_id_child organization_id
3293: from per_org_structure_elements b
3294: where org_structure_version_id = p_org_structure_version_id
3295: and b.organization_id_child = a.organization_id_parent
3296: )
3297: and rownum <2;

Line 3311: (select null from per_org_structure_elements e

3307: from hr_all_organization_units u
3308: where organization_id = p_start_org_id
3309: and business_group_id = p_business_group_id
3310: and exists
3311: (select null from per_org_structure_elements e
3312: where e.org_structure_version_id = p_org_structure_version_id
3313: and (e.organization_id_child = p_start_org_id
3314: or e.organization_id_parent = p_start_org_id) )
3315: union

Line 3319: from per_org_structure_elements a

3315: union
3316: select rownum rn,
3317: level level1,
3318: organization_id_child organization_id
3319: from per_org_structure_elements a
3320: start with
3321: organization_id_parent = p_start_org_id
3322: and org_structure_version_id = p_org_structure_version_id
3323: connect by