DBA Data[Home] [Help]

APPS.JA_CN_PS_HRMS_EXPORT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 512: , hr_all_organization_units_tl orgtl

508: orgtl.name department_name
509: , org.organization_id department_id
510: FROM
511: hr_organization_units org
512: , hr_all_organization_units_tl orgtl
513: WHERE orgtl.organization_id = org.organization_id
514: AND orgtl.LANGUAGE = userenv('LANG')
515: AND org.business_group_id = fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')
516: AND date_from <= ld_acc_end_date