DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on HR_ORGANIZATION_INFORMATION

Line 140: , HR_ORGANIZATION_INFORMATION hoi1

136: and hsk.enabled_flag = 'Y'
137: and hsk.segment2 in (
138: select hoi2.org_information1
139: from HR_ORGANIZATION_UNITS o1
140: , HR_ORGANIZATION_INFORMATION hoi1
141: , HR_ORGANIZATION_INFORMATION hoi2
142: WHERE o1.business_group_id = pa1.business_group_id
143: and hoi1.organization_id = o1.organization_id
144: and hoi1.organization_id = p_le_id

Line 141: , HR_ORGANIZATION_INFORMATION hoi2

137: and hsk.segment2 in (
138: select hoi2.org_information1
139: from HR_ORGANIZATION_UNITS o1
140: , HR_ORGANIZATION_INFORMATION hoi1
141: , HR_ORGANIZATION_INFORMATION hoi2
142: WHERE o1.business_group_id = pa1.business_group_id
143: and hoi1.organization_id = o1.organization_id
144: and hoi1.organization_id = p_le_id
145: and hoi1.ORG_INFORMATION_CONTEXT='CLASS'