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_NL_LAW_SAMEN_REPORT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 209: from per_org_structure_elements ose, per_org_structure_versions_v posv

205: ,P_TOP_ORGANIZATION_ID NUMBER
206: ,P_ORG_STRUCTURE_ID NUMBER)
207: is
208: select distinct ose.organization_id_child organization_id
209: from per_org_structure_elements ose, per_org_structure_versions_v posv
210: where ose.org_structure_version_id = posv.ORG_STRUCTURE_VERSION_ID
211: and ose.BUSINESS_GROUP_ID = posv.BUSINESS_GROUP_ID
212: and posv.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
213: and posv.ORGANIZATION_STRUCTURE_ID = P_ORG_STRUCTURE_ID

Line 227: from per_org_structure_elements ose

223: , P_ORGANIZATION_ID NUMBER
224: , P_ROLL_UP VARCHAR2)
225: is
226: select distinct ose.organization_id_child organization_id
227: from per_org_structure_elements ose
228: where ose.org_structure_version_id +0 = P_ORG_STRUCTURE_VERSION_ID
229: and P_ROLL_UP = 'Y'
230: connect by prior ose.organization_id_child = ose.organization_id_parent
231: and ose.org_structure_version_id = P_ORG_STRUCTURE_VERSION_ID