APPS.PAY_SE_TAX_CARD dependencies on HR_ORGANIZATION_INFORMATION

Line 159: , HR_ORGANIZATION_INFORMATION hoi1

155: AND SCL.SEGMENT2 in
156: (
157: select to_char(hoi1.organization_id)
158: from HR_ORGANIZATION_UNITS o1
159: , HR_ORGANIZATION_INFORMATION hoi1
160: , HR_ORGANIZATION_INFORMATION hoi2
161: , HR_ORGANIZATION_INFORMATION hoi3
162: , HR_ORGANIZATION_INFORMATION hoi4
163: WHERE o1.business_group_id = p_business_group_id

Line 160: , HR_ORGANIZATION_INFORMATION hoi2

156: (
157: select to_char(hoi1.organization_id)
158: from HR_ORGANIZATION_UNITS o1
159: , HR_ORGANIZATION_INFORMATION hoi1
160: , HR_ORGANIZATION_INFORMATION hoi2
161: , HR_ORGANIZATION_INFORMATION hoi3
162: , HR_ORGANIZATION_INFORMATION hoi4
163: WHERE o1.business_group_id = p_business_group_id
164: and hoi1.organization_id = o1.organization_id

Line 161: , HR_ORGANIZATION_INFORMATION hoi3

157: select to_char(hoi1.organization_id)
158: from HR_ORGANIZATION_UNITS o1
159: , HR_ORGANIZATION_INFORMATION hoi1
160: , HR_ORGANIZATION_INFORMATION hoi2
161: , HR_ORGANIZATION_INFORMATION hoi3
162: , HR_ORGANIZATION_INFORMATION hoi4
163: WHERE o1.business_group_id = p_business_group_id
164: and hoi1.organization_id = o1.organization_id
165: and hoi1.org_information1 = 'SE_LOCAL_UNIT'

Line 162: , HR_ORGANIZATION_INFORMATION hoi4

158: from HR_ORGANIZATION_UNITS o1
159: , HR_ORGANIZATION_INFORMATION hoi1
160: , HR_ORGANIZATION_INFORMATION hoi2
161: , HR_ORGANIZATION_INFORMATION hoi3
162: , HR_ORGANIZATION_INFORMATION hoi4
163: WHERE o1.business_group_id = p_business_group_id
164: and hoi1.organization_id = o1.organization_id
165: and hoi1.org_information1 = 'SE_LOCAL_UNIT'
166: and hoi1.org_information_context = 'CLASS'