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.HR_DE_TAX_SUPPORT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 41: from per_org_structure_elements ose, per_org_structure_versions_v posv

37: ,P_TOP_ORG NUMBER
38: ,P_ORG_HIERARCHY NUMBER)
39: is
40: select distinct ose.organization_id_child organization_id
41: from per_org_structure_elements ose, per_org_structure_versions_v posv
42: where ose.org_structure_version_id = posv.ORG_STRUCTURE_VERSION_ID
43: and ose.BUSINESS_GROUP_ID = posv.BUSINESS_GROUP_ID
44: and posv.ORG_STRUCTURE_VERSION_ID = P_ORG_HIERARCHY
45: and posv.ORGANIZATION_STRUCTURE_ID = P_ORG_HIERARCHY

Line 59: from per_org_structure_elements ose

55: , P_ORGANIZATION_ID NUMBER
56: )
57: is
58: select distinct ose.organization_id_child organization_id
59: from per_org_structure_elements ose
60: where ose.org_structure_version_id +0 = P_ORG_HIERARCHY
61: connect by prior ose.organization_id_child = ose.organization_id_parent
62: and ose.org_structure_version_id = P_ORG_HIERARCHY
63: start with ose.organization_id_parent = P_ORGANIZATION_ID