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

Line 339: from per_org_structure_elements ose

335: ,P_TOP_ORGANIZATION_ID NUMBER)
336: is
337: select ose.org_structure_element_id
338: ,ose.organization_id_child organization_id
339: from per_org_structure_elements ose
340: where ose.org_structure_version_id +0 = P_ORG_STRUCTURE_VERSION_ID
341: and ose.organization_id_parent = P_TOP_ORGANIZATION_ID
342: order by ose.organization_id_child;
343:

Line 350: from per_org_structure_elements ose

346: , P_ORGANIZATION_ID NUMBER
347: , P_ROLL_UP VARCHAR2)
348: is
349: select ose.organization_id_child organization_id
350: from per_org_structure_elements ose
351: where ose.org_structure_version_id +0 = P_ORG_STRUCTURE_VERSION_ID
352: and P_ROLL_UP = 'Y'
353: connect by prior ose.organization_id_child = ose.organization_id_parent
354: and ose.org_structure_version_id = P_ORG_STRUCTURE_VERSION_ID

Line 736: from per_org_structure_elements pose

732: ,pose.organization_id_child
733: ,posv1.version_number
734: ,greatest(posv1.date_from,P_REPORT_DATE_FROM) date_from
735: ,least(nvl(posv1.date_to,to_date('31/12/4712','DD/MM/YYYY')),P_REPORT_DATE_TO) date_to
736: from per_org_structure_elements pose
737: ,per_org_structure_versions posv1
738: where pose.organization_id_parent = P_TOP_ORGANIZATION_ID
739: and pose.org_structure_version_id = posv1.org_structure_version_id
740: and pose.org_structure_version_id in (