APPS.GHR_UTILITY dependencies on HR_ALL_ORGANIZATION_UNITS

Line 82: FUNCTION get_pos_flex_num(p_bus_org_id hr_all_organization_units.business_group_id%type) RETURN NUMBER IS

78:
79:
80: --############### Function to get Position Flex Number #############################################
81:
82: FUNCTION get_pos_flex_num(p_bus_org_id hr_all_organization_units.business_group_id%type) RETURN NUMBER IS
83: CURSOR c_pos_flex_num(c_bus_org_id hr_all_organization_units.business_group_id%type) IS
84: select org_information8
85: from hr_organization_information oi
86: where org_information_context = 'Business Group Information'

Line 83: CURSOR c_pos_flex_num(c_bus_org_id hr_all_organization_units.business_group_id%type) IS

79:
80: --############### Function to get Position Flex Number #############################################
81:
82: FUNCTION get_pos_flex_num(p_bus_org_id hr_all_organization_units.business_group_id%type) RETURN NUMBER IS
83: CURSOR c_pos_flex_num(c_bus_org_id hr_all_organization_units.business_group_id%type) IS
84: select org_information8
85: from hr_organization_information oi
86: where org_information_context = 'Business Group Information'
87: and organization_id = c_bus_org_id;