APPS.PER_ES_ORG_INFO dependencies on HR_ORGANIZATION_INFORMATION

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 43: AND EXISTS (SELECT 1 FROM hr_organization_information hoi1

39: AND org_information4 = c_org_info2
40: AND org_information1 <> c_org_info1
41: AND hou.business_group_id = c_business_group_id
42: AND c_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
43: AND EXISTS (SELECT 1 FROM hr_organization_information hoi1
44: WHERE hoi1.org_information1 = 'ES_WORK_CENTER'
45: AND hoi1.org_information_context = 'CLASS'
46: AND hoi1.organization_id = hoi.organization_id
47: AND hoi1.org_information2 = 'Y');

Line 217: ,hr_organization_information hoi

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: --
221: CURSOR csr_chk_province_code(c_prov_code VARCHAR2) IS

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 239: AND EXISTS (SELECT 1 FROM hr_organization_information hoi1

235: AND org_information4 = c_org_info2
236: AND org_information1 <> c_org_info1
237: AND hou.business_group_id = c_business_group_id
238: AND c_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
239: AND EXISTS (SELECT 1 FROM hr_organization_information hoi1
240: WHERE hoi1.org_information1 = 'ES_WORK_CENTER'
241: AND hoi1.org_information_context = 'CLASS'
242: AND hoi1.organization_id = hoi.organization_id
243: AND hoi1.org_information2 = 'Y');