APPS.PER_IE_ORG_INFO dependencies on HR_ORGANIZATION_INFORMATION

Line 13: FROM hr_organization_information hoi,

9: ) is
10:
11: CURSOR get_unique is
12: SELECT 'x', hoi.org_information2
13: FROM hr_organization_information hoi,
14: hr_all_organization_units hou
15: WHERE hoi.org_information_context ='IE_ORG_INFORMATION'
16: AND hou.organization_id = hoi.organization_id
17: AND hoi.org_information2 = p_org_information2

Line 21: AND exists (select 1 from hr_organization_information hoi1

17: AND hoi.org_information2 = p_org_information2
18: AND hou.business_group_id =p_business_group_id
19: AND (p_org_info_id IS NULL OR hoi.org_information_id <> p_org_info_id)
20: AND p_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
21: AND exists (select 1 from hr_organization_information hoi1
22: where hoi1.org_information1 = 'HR_BG'
23: and hoi1.org_information_context = 'CLASS'
24: and hoi1.organization_id = hoi.organization_id
25: and hoi1.org_information2='Y');

Line 30: l_paye_ref_no hr_organization_information.org_information2%type;

26:
27:
28:
29: l_check_flag varchar2(1);
30: l_paye_ref_no hr_organization_information.org_information2%type;
31:
32: BEGIN
33:
34: /* Added for GSI Bug 5472781 */

Line 62: FROM hr_organization_information hoi,

58: ) is
59:
60: CURSOR get_unique is
61: SELECT 'x', hoi.org_information2
62: FROM hr_organization_information hoi,
63: hr_all_organization_units hou
64: WHERE hoi.org_information_context ='IE_EMPLOYER_INFO'
65: AND hou.organization_id = hoi.organization_id
66: AND hoi.org_information2 = p_org_information2

Line 70: AND exists (select 1 from hr_organization_information hoi1

66: AND hoi.org_information2 = p_org_information2
67: AND hou.business_group_id =p_business_group_id
68: AND (p_org_info_id IS NULL OR hoi.org_information_id <> p_org_info_id)
69: AND p_effective_date <= nvl(hou.date_to,to_Date('4712/12/31','YYYY/MM/DD'))
70: AND exists (select 1 from hr_organization_information hoi1
71: where hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
72: and hoi1.org_information_context = 'CLASS'
73: and hoi1.organization_id = hoi.organization_id
74: and hoi1.org_information2='Y');

Line 79: l_paye_ref_no hr_organization_information.org_information2%type;

75:
76:
77:
78: l_check_flag varchar2(1);
79: l_paye_ref_no hr_organization_information.org_information2%type;
80:
81: BEGIN
82:
83: /* Added for GSI Bug 5472781 */

Line 221: from hr_all_organization_units hou,hr_organization_information hoi

217: ) is
218:
219: CURSOR get_business_group is
220: SELECT business_group_id
221: from hr_all_organization_units hou,hr_organization_information hoi
222: where hoi.org_information_id=p_org_information_id
223: and hoi.organization_id=hou.organization_id;
224:
225: l_business_group_id hr_all_organization_units.business_group_id%TYPE;