DBA Data[Home] [Help]

APPS.PAY_SE_ARCHIVE_CWCA dependencies on HR_ALL_ORGANIZATION_UNITS

Line 339: FROM hr_all_organization_units o

335: SELECT o.NAME
336: ,hoi3.org_information2 "ORG_NUMBER"
337: ,o.location_id
338: ,o.organization_id
339: FROM hr_all_organization_units o
340: ,hr_organization_information hoi1
341: ,hr_organization_information hoi2
342: ,hr_organization_information hoi3
343: WHERE o.business_group_id = g_business_group_id