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

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

361: and hoi2.organization_id = hoi1.organization_id;
362:
363: cursor get_info_from_org is
364: select lookups.meaning
365: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
366: where hou.organization_id = l_organization_id
367: and hou.organization_id = hoi.organization_id
368: and hoi.org_information_context = 'FI_EMPLOYMENT_DEFAULTS'
369: and lookups.lookup_type = l_information_code

Line 379: from hr_organization_units

375: 'FI_COM_PRICE_CAT',hoi.org_information5,null);
376:
377: cursor get_bg_id is
378: select business_group_id
379: from hr_organization_units
380: where organization_id = l_organization_id;
381:
382:
383: begin

Line 737: from HR_ORGANIZATION_UNITS o1

733:
734: CURSOR get_details(p_assignment_id NUMBER ,p_effective_date DATE ) IS
735: select hoi2.org_information2,hoi2.org_information3,hoi2.org_information4,pap1.per_information11
736: , pap1.per_information12 , pap1.per_information13
737: from HR_ORGANIZATION_UNITS o1
738: , HR_ORGANIZATION_INFORMATION hoi1
739: , HR_ORGANIZATION_INFORMATION hoi2
740: , per_all_people_f pap1
741: , per_all_assignments_f paa