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_DK_UTILITY dependencies on HR_ORGANIZATION_UNITS

Line 334: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups

330: 'DK_EMP_GROUP',scl.segment4,NULL);
331:
332: cursor get_info_from_org is
333: select lookups.meaning
334: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
335: where hou.organization_id = l_organization_id
336: and hou.organization_id = hoi.organization_id
337: and hoi.org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
338: and lookups.lookup_type = l_information_code

Line 361: from hr_organization_units

357: 'DK_EMP_GROUP',hoi.org_information2,NULL);
358:
359: cursor get_bg_id is
360: select business_group_id
361: from hr_organization_units
362: where organization_id = l_organization_id;
363:
364: cursor is_hr_org is
365: select nvl(hoi.org_information1,'NO_DATA')

Line 366: from hr_organization_units hou , hr_organization_information hoi

362: where organization_id = l_organization_id;
363:
364: cursor is_hr_org is
365: select nvl(hoi.org_information1,'NO_DATA')
366: from hr_organization_units hou , hr_organization_information hoi
367: where hou.organization_id = l_organization_id
368: and hou.organization_id = hoi.organization_id
369: and hoi.org_information_context = 'CLASS'
370: and hoi.org_information1 = 'HR_ORG';