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_VERSIONS

Line 324: from per_org_structure_versions posv

320: is
321: select posv.org_structure_version_id
322: ,posv.date_from date_from
323: ,nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY')) date_to
324: from per_org_structure_versions posv
325: where posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID
326: and (P_REPORT_DATE_FROM between posv.date_from and
327: nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY'))
328: or posv.date_from between P_REPORT_DATE_FROM and P_REPORT_DATE_TO)

Line 737: ,per_org_structure_versions posv1

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 (
741: select posv.org_structure_version_id

Line 742: from per_org_structure_versions posv

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 (
741: select posv.org_structure_version_id
742: from per_org_structure_versions posv
743: where posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID
744: and (P_REPORT_DATE_FROM between posv.date_from and
745: nvl(posv.date_to, P_REPORT_DATE_TO)
746: or posv.date_from between P_REPORT_DATE_FROM and P_REPORT_DATE_TO))

Line 763: from per_org_structure_versions posv

759: ,P_TOP_ORGANIZATION_ID organization_id_child
760: ,posv.version_number
761: ,greatest(posv.date_from,P_REPORT_DATE_FROM) date_from
762: ,least(nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY')),P_REPORT_DATE_TO) date_to
763: from per_org_structure_versions posv
764: where posv.organization_structure_id = P_ORGANIZATION_STRUCTURE_ID
765: and (P_REPORT_DATE_FROM between posv.date_from and
766: nvl(posv.date_to, P_REPORT_DATE_TO)
767: or posv.date_from between P_REPORT_DATE_FROM and P_REPORT_DATE_TO)