APPS.GHR_UTILITY dependencies on HR_ORGANIZATION_INFORMATION

Line 13: FROM hr_organization_information hoi

9: v_current_bg NUMBER;
10: CURSOR c_fed_bg (p_current_bg NUMBER) IS
11: SELECT hoi.org_information_context
12: , hoi.org_information1
13: FROM hr_organization_information hoi
14: WHERE hoi.org_information_context = 'GHR_US_ORG_INFORMATION'
15: AND hoi.organization_id = p_current_bg;
16:
17: CURSOR c_fed_nfc (p_current_bg NUMBER) IS

Line 20: FROM hr_organization_information hoi

16:
17: CURSOR c_fed_nfc (p_current_bg NUMBER) IS
18: SELECT hoi.org_information_context
19: , hoi.org_information6
20: FROM hr_organization_information hoi
21: WHERE hoi.org_information_context = 'GHR_US_ORG_INFORMATION'
22: AND hoi.organization_id = p_current_bg
23: AND hoi.org_information6 = 'Y';
24:

Line 95: from hr_organization_information oi

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;
98:
99: l_flex_num fnd_id_flex_structures_tl.id_flex_num%type;