88:
89:
90: --############### Function to get Position Flex Number #############################################
91:
92: FUNCTION get_pos_flex_num(p_bus_org_id hr_all_organization_units.business_group_id%type) RETURN NUMBER IS
93: CURSOR c_pos_flex_num(c_bus_org_id hr_all_organization_units.business_group_id%type) IS
94: select org_information8
95: from hr_organization_information oi
96: where org_information_context = 'Business Group Information'
89:
90: --############### Function to get Position Flex Number #############################################
91:
92: FUNCTION get_pos_flex_num(p_bus_org_id hr_all_organization_units.business_group_id%type) RETURN NUMBER IS
93: CURSOR c_pos_flex_num(c_bus_org_id hr_all_organization_units.business_group_id%type) IS
94: select org_information8
95: from hr_organization_information oi
96: where org_information_context = 'Business Group Information'
97: and organization_id = c_bus_org_id;