APPS.PER_ES_ORG_INFO dependencies on HR_ALL_ORGANIZATION_UNITS

Line 22: FROM hr_all_organization_units

18: ,p_effective_date DATE
19: ) is
20: CURSOR get_business_group is
21: SELECT business_group_id
22: FROM hr_all_organization_units
23: WHERE organization_id=p_organization_id;
24: --
25: CURSOR csr_chk_province_code(c_prov_code VARCHAR2) IS
26: SELECT 'Y' FROM dual

Line 36: FROM hr_organization_information hoi,hr_all_organization_units hou

32: ,c_org_info1 VARCHAR2
33: ,c_org_info2 VARCHAR2
34: ,c_effective_date DATE) IS
35: SELECT 'Y'
36: FROM hr_organization_information hoi,hr_all_organization_units hou
37: WHERE hoi.org_information_context = 'ES_WORK_CENTER_DETAILS'
38: AND hou.organization_id = hoi.organization_id
39: AND org_information4 = c_org_info2
40: AND org_information1 <> c_org_info1

Line 52: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

48: --
49: l_code VARCHAR2(2);
50: l_chk VARCHAR2(1);
51:
52: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
53: --
54: BEGIN
55: --
56: -- Added for GSI Bug 5472781

Line 208: FROM hr_all_organization_units hou

204: ) IS
205: --
206: CURSOR get_business_group is
207: SELECT business_group_id
208: FROM hr_all_organization_units hou
209: ,hr_organization_information hoi
210: WHERE hoi.org_information_id = p_org_information_id
211: AND hoi.organization_id = hou.organization_id;
212: --

Line 224: FROM hr_organization_information hoi,hr_all_organization_units hou

220: ,c_org_info1 VARCHAR2
221: ,c_org_info2 VARCHAR2
222: ,c_effective_date DATE) IS
223: SELECT 'Y'
224: FROM hr_organization_information hoi,hr_all_organization_units hou
225: WHERE hoi.org_information_context = 'ES_WORK_CENTER_DETAILS'
226: AND hou.organization_id = hoi.organization_id
227: AND org_information4 = c_org_info2
228: AND org_information1 <> c_org_info1

Line 239: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

235: AND hoi1.org_information2 = 'Y');
236: --
237: l_code VARCHAR2(2);
238: l_chk VARCHAR2(1);
239: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
240: --
241: BEGIN
242: --
243: -- Added for GSI Bug 5472781