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 216: FROM hr_all_organization_units hou

212: ) IS
213: --
214: CURSOR get_business_group is
215: SELECT business_group_id
216: FROM hr_all_organization_units hou
217: ,hr_organization_information hoi
218: WHERE hoi.org_information_id = p_org_information_id
219: AND hoi.organization_id = hou.organization_id;
220: --

Line 232: FROM hr_organization_information hoi,hr_all_organization_units hou

228: ,c_org_info1 VARCHAR2
229: ,c_org_info2 VARCHAR2
230: ,c_effective_date DATE) IS
231: SELECT 'Y'
232: FROM hr_organization_information hoi,hr_all_organization_units hou
233: WHERE hoi.org_information_context = 'ES_WORK_CENTER_DETAILS'
234: AND hou.organization_id = hoi.organization_id
235: AND org_information4 = c_org_info2
236: AND org_information1 <> c_org_info1

Line 247: l_business_group_id hr_all_organization_units.business_group_id%TYPE;

243: AND hoi1.org_information2 = 'Y');
244: --
245: l_code VARCHAR2(2);
246: l_chk VARCHAR2(1);
247: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
248: --
249: BEGIN
250: --
251: -- Added for GSI Bug 5472781