DBA Data[Home] [Help]

APPS.JA_CN_HRMS_EXPORT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 281: FROM hr_organization_units org, hr_all_organization_units_tl orgtl

277: IS
278: SELECT orgtl.NAME DEPARTMENT_NAME,
279: org.organization_id DEPARMENT_ID,
280: NULL PARENT_DEPARTMENT_ID
281: FROM hr_organization_units org, hr_all_organization_units_tl orgtl
282: WHERE orgtl.organization_id = org.organization_id
283: AND orgtl.LANGUAGE = userenv('LANG')
284: AND org.business_group_id = fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')
285: AND date_from <= pd_acc_end_date