DBA Data[Home] [Help]

APPS.PQP_HROSS_INTEGRATION dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 362: FROM hr_all_organization_units_tl htl

358: ,c_business_group_id IN Number
359: ,c_effective_date IN Date
360: ) IS
361: SELECT htl.NAME
362: FROM hr_all_organization_units_tl htl
363: ,hr_all_organization_units hao
364: WHERE hao.organization_id = c_organization_id
365: AND hao.business_group_id = c_business_group_id
366: AND htl.organization_id = hao.organization_id