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 DUAL

Line 135: from sys.dual

131: >= P_REPORT_DATE_TO ))
132: and pose.organization_id_parent = P_TOP_ORGANIZATION_ID
133: union
134: select P_TOP_ORGANIZATION_ID
135: from sys.dual
136: where P_INCLUDE_TOP_ORG = 'Y';
137:
138: cursor get_org_structure_version
139: (P_ORGANIZATION_STRUCTURE_ID NUMBER

Line 181: from dual

177: start with ose.organization_id_parent = P_ORGANIZATION_ID
178: and ose.org_structure_version_id = P_ORG_STRUCTURE_VERSION_ID
179: UNION
180: select P_ORGANIZATION_ID organization_id
181: from dual
182: where P_ROLL_UP = 'Y'
183: UNION
184: select P_ORGANIZATION_ID organization_id
185: from dual

Line 185: from dual

181: from dual
182: where P_ROLL_UP = 'Y'
183: UNION
184: select P_ORGANIZATION_ID organization_id
185: from dual
186: where P_ROLL_UP = 'N';
187:
188: cursor get_assignment_start_end
189: ( P_EFFECTIVE_DATE DATE