DBA Data[Home] [Help]

APPS.HR_JP_GENERAL_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 198: hr_organization_information hoi1

194: ,hoi2.org_information3
195: ,hoi2.org_information4
196: ,hoi2.org_information5
197: from
198: hr_organization_information hoi1
199: ,hr_organization_information hoi2
200: where
201: hoi1.organization_id = p_organization_id
202: and hoi1.org_information_context = 'CLASS'

Line 199: ,hr_organization_information hoi2

195: ,hoi2.org_information4
196: ,hoi2.org_information5
197: from
198: hr_organization_information hoi1
199: ,hr_organization_information hoi2
200: where
201: hoi1.organization_id = p_organization_id
202: and hoi1.org_information_context = 'CLASS'
203: and hoi1.org_information1 = 'JP_EXTRA_NAME'