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

Line 124: from per_org_structure_elements pose

120: ,P_REPORT_DATE_FROM DATE
121: ,P_REPORT_DATE_TO DATE)
122: is
123: select distinct pose.ORGANIZATION_ID_CHILD organization_id
124: from per_org_structure_elements pose
125: where exists (select 1
126: from per_org_structure_versions posv
127: where posv.org_structure_version_id = pose.org_structure_version_id
128: and posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID

Line 161: from per_org_structure_elements ose

157: ,P_TOP_ORGANIZATION_ID NUMBER)
158: is
159: select ose.org_structure_element_id,
160: ose.organization_id_child organization_id1
161: from per_org_structure_elements ose
162: where ose.org_structure_version_id +0 = P_ORG_STRUCTURE_VERSION_ID
163: and ose.organization_id_parent = P_TOP_ORGANIZATION_ID
164: order by ose.organization_id_child;
165:

Line 172: from per_org_structure_elements ose

168: , P_ORGANIZATION_ID NUMBER
169: , P_ROLL_UP VARCHAR2)
170: is
171: select ose.organization_id_child organization_id2
172: from per_org_structure_elements ose
173: where ose.org_structure_version_id +0 = P_ORG_STRUCTURE_VERSION_ID
174: and P_ROLL_UP = 'Y'
175: connect by prior ose.organization_id_child = ose.organization_id_parent
176: and ose.org_structure_version_id = P_ORG_STRUCTURE_VERSION_ID