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'
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'