APPS.PER_US_ORG_INFO_LEG_HOOK dependencies on HR_ORGANIZATION_INFORMATION

Line 20: from hr_organization_information

16:
17: )
18: IS
19: select 'Y'
20: from hr_organization_information
21: where ORG_INFORMATION_CONTEXT like p_org_info_type_code
22: and ORG_INFORMATION_CONTEXT in
23: ( 'State Tax Rules', 'State Tax Rules 2', 'Local Tax Rules') --RLN 7421633
24: and org_information1 = p_org_information1

Line 45: from hr_organization_information hoi

41: l_org_id := -99999;
42: begin
43: select hoi.organization_id
44: into l_org_id
45: from hr_organization_information hoi
46: where P_ORG_INFORMATION_ID = hoi.org_information_id
47: -- and ORG_INFORMATION_CONTEXT = p_org_info_type_code
48: and rownum = 1;
49:

Line 95: from hr_organization_information

91:
92: )
93: IS
94: select 'Y'
95: from hr_organization_information
96: where ORG_INFORMATION_CONTEXT like p_org_info_type_code
97: and ORG_INFORMATION_CONTEXT in
98: ( 'State Tax Rules', 'State Tax Rules 2', 'Local Tax Rules') --RLN 7421633
99: and org_information1 = p_org_information1

Line 149: from hr_organization_information

145:
146: )
147: IS
148: select 'Y'
149: from hr_organization_information
150: where ORG_INFORMATION_CONTEXT like p_org_information_context
151: and org_information1 = p_org_information1
152: and organization_id = p_organization_id
153: ;