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_INFORMATION

Line 389: from hr_organization_information hoi , hr_lookups lookups

385:
386:
387: cursor get_info_from_local_unit is
388: select lookups.meaning
389: from hr_organization_information hoi , hr_lookups lookups
390: where hoi.organization_id = l_org_id
391: and hoi.org_information_context = 'FI_EMPLOYMENT_DEFAULTS'
392: and lookups.lookup_type = l_information_code
393: and lookups.enabled_flag = 'Y'

Line 402: from hr_organization_information hoi1 , hr_organization_information hoi2

398: 'FI_COM_PRICE_CAT',hoi.org_information5,null);
399:
400: cursor get_legal_employer is
401: select hoi2.organization_id
402: from hr_organization_information hoi1 , hr_organization_information hoi2
403: where hoi1.org_information1 = to_char(l_local_unit) and hoi1.org_information_context = 'FI_LOCAL_UNITS'
404: and hoi2.org_information_context = 'CLASS' and hoi2.org_information1 = 'HR_LEGAL_EMPLOYER'
405: and hoi2.organization_id = hoi1.organization_id;
406:

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

405: and hoi2.organization_id = hoi1.organization_id;
406:
407: cursor get_info_from_org is
408: select lookups.meaning
409: from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
410: where hou.organization_id = l_organization_id
411: and hou.organization_id = hoi.organization_id
412: and hoi.org_information_context = 'FI_EMPLOYMENT_DEFAULTS'
413: and lookups.lookup_type = l_information_code

Line 877: , HR_ORGANIZATION_INFORMATION hoi1

873: CURSOR get_details(p_assignment_id NUMBER ,p_effective_date DATE ) IS
874: select hoi2.org_information2,hoi2.org_information3,hoi2.org_information4,pap1.per_information11
875: , pap1.per_information12 , pap1.per_information13
876: from HR_ORGANIZATION_UNITS o1
877: , HR_ORGANIZATION_INFORMATION hoi1
878: , HR_ORGANIZATION_INFORMATION hoi2
879: , per_all_people_f pap1
880: , per_all_assignments_f paa
881: WHERE hoi1.organization_id = o1.organization_id

Line 878: , HR_ORGANIZATION_INFORMATION hoi2

874: select hoi2.org_information2,hoi2.org_information3,hoi2.org_information4,pap1.per_information11
875: , pap1.per_information12 , pap1.per_information13
876: from HR_ORGANIZATION_UNITS o1
877: , HR_ORGANIZATION_INFORMATION hoi1
878: , HR_ORGANIZATION_INFORMATION hoi2
879: , per_all_people_f pap1
880: , per_all_assignments_f paa
881: WHERE hoi1.organization_id = o1.organization_id
882: and hoi1.org_information1 = 'FI_TRADE_UNION'