425:
426: CURSOR c_get_details(p_business_group_id NUMBER , p_tax_unit_id NUMBER, p_effective_date DATE) IS
427: SELECT hoi2.org_information1,hoi2.org_information2,hoi2.org_information3
428: FROM hr_organization_units o1
429: , hr_organization_information hoi1
430: , hr_organization_information hoi2
431: WHERE o1.business_group_id = p_business_group_id
432: AND hoi1.organization_id = o1.organization_id
433: AND hoi1.organization_id = p_tax_unit_id
426: CURSOR c_get_details(p_business_group_id NUMBER , p_tax_unit_id NUMBER, p_effective_date DATE) IS
427: SELECT hoi2.org_information1,hoi2.org_information2,hoi2.org_information3
428: FROM hr_organization_units o1
429: , hr_organization_information hoi1
430: , hr_organization_information hoi2
431: WHERE o1.business_group_id = p_business_group_id
432: AND hoi1.organization_id = o1.organization_id
433: AND hoi1.organization_id = p_tax_unit_id
434: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'