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 209: ,hr_organization_information hoi

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

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

227: AND org_information4 = c_org_info2
228: AND org_information1 <> c_org_info1
229: AND hou.business_group_id = c_business_group_id
230: AND c_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
231: AND EXISTS (SELECT 1 FROM hr_organization_information hoi1
232: WHERE hoi1.org_information1 = 'ES_WORK_CENTER'
233: AND hoi1.org_information_context = 'CLASS'
234: AND hoi1.organization_id = hoi.organization_id
235: AND hoi1.org_information2 = 'Y');