80: cursor c_business_place_count
81: is
82: select count(distinct hoi.org_information2||ihoi.org_information9) bp_count
83: from hr_organization_information hoi
84: ,hr_organization_units hou
85: ,hr_organization_units phou
86: ,hr_organization_information phoi
87: ,hr_organization_information ihoi
88: where hou.organization_id = hoi.organization_id
81: is
82: select count(distinct hoi.org_information2||ihoi.org_information9) bp_count
83: from hr_organization_information hoi
84: ,hr_organization_units hou
85: ,hr_organization_units phou
86: ,hr_organization_information phoi
87: ,hr_organization_information ihoi
88: where hou.organization_id = hoi.organization_id
89: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'