DBA Data[Home] [Help]

APPS.PAY_SE_ARCHIVE_CWCA dependencies on HR_ALL_ORGANIZATION_UNITS

Line 336: FROM hr_all_organization_units o

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