341:
342:
343: cursor get_info_from_local_unit is
344: select lookups.meaning
345: from hr_organization_information hoi , hr_lookups lookups
346: where hoi.organization_id = l_org_id
347: and hoi.org_information_context = 'FI_EMPLOYMENT_DEFAULTS'
348: and lookups.lookup_type = l_information_code
349: and lookups.enabled_flag = 'Y'
354: 'FI_COM_PRICE_CAT',hoi.org_information5,null);
355:
356: cursor get_legal_employer is
357: select hoi2.organization_id
358: from hr_organization_information hoi1 , hr_organization_information hoi2
359: where hoi1.org_information1 = to_char(l_local_unit) and hoi1.org_information_context = 'FI_LOCAL_UNITS'
360: and hoi2.org_information_context = 'CLASS' and hoi2.org_information1 = 'HR_LEGAL_EMPLOYER'
361: and hoi2.organization_id = hoi1.organization_id;
362:
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
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
742: WHERE hoi1.organization_id = o1.organization_id
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
742: WHERE hoi1.organization_id = o1.organization_id
743: and hoi1.org_information1 = 'FI_TRADE_UNION'