71: FROM hr_organization_information hoi
72: ,hr_organization_information ihoi
73: ,hr_organization_information choi
74: ,hr_organization_units hou
75: ,hr_locations_all hla
76: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
77: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
78: and hou.organization_id = hoi.organization_id
79: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'