DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1447: hr_all_organization_units_tl orgtl

1443: cursor c_OrganizationLovVO(p_source_name1 varchar2, cv_effective_date date) is
1444: select orgtl.name name,
1445: org.organization_id id
1446: from hr_all_organization_units org,
1447: hr_all_organization_units_tl orgtl
1448: where org.business_group_id = p_target_business_group_id
1449: and orgtl.organization_id = org.organization_id
1450: and orgtl.language = userenv('LANG')
1451: and org.internal_external_flag = 'INT'