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

Line 74: ,per_org_structure_elements ele

70: ,MAX(ele.last_update_date) last_updated
71: FROM
72: per_organization_structures ost
73: ,per_org_structure_versions osv
74: ,per_org_structure_elements ele
75: WHERE
76: ost.organization_structure_id = osv.organization_structure_id
77: AND osv.org_structure_version_id = ele.org_structure_version_id
78: AND ost.primary_structure_flag = 'Y'

Line 81: AND NOT EXISTS (SELECT 1 FROM per_org_structure_elements dummy

77: AND osv.org_structure_version_id = ele.org_structure_version_id
78: AND ost.primary_structure_flag = 'Y'
79: AND (osv.date_to IS NULL
80: OR SYSDATE BETWEEN osv.date_from AND osv.date_to)
81: AND NOT EXISTS (SELECT 1 FROM per_org_structure_elements dummy
82: WHERE dummy.org_structure_version_id = ele.org_structure_version_id
83: AND dummy.organization_id_child = ele.organization_id_parent)
84: GROUP BY
85: ost.organization_structure_id

Line 102: per_org_structure_elements ele

98: ,ele.organization_id_parent parent_organization_id
99: ,LEVEL+1 child_level
100: ,ele.last_update_date last_updated
101: FROM
102: per_org_structure_elements ele
103: WHERE
104: ele.org_structure_version_id = cp_org_structure_version_id
105: CONNECT BY (prior ele.organization_id_child = ele.organization_id_parent
106: AND prior ele.org_structure_version_id = ele.org_structure_version_id)