DBA Data[Home] [Help]

APPS.OTA_GENERAL dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 865: from hr_all_organization_units orgs,hr_all_organization_units_tl orgs_tl

861: --
862: cursor csr_lookup is
863: --Bug 2846475
864: select orgs_tl.name
865: from hr_all_organization_units orgs,hr_all_organization_units_tl orgs_tl
866: where orgs.organization_id = p_organization_id
867: and orgs.organization_id = orgs_tl.organization_id
868: and orgs_tl.language = userenv('LANG');
869: -- select name

Line 1180: FROM hr_all_organization_units_tl org

1176: IS
1177: --
1178: CURSOR org_name_cr IS
1179: SELECT org.name
1180: FROM hr_all_organization_units_tl org
1181: WHERE org.organization_id = p_organization_id
1182: AND org.language = USERENV('LANG');
1183:
1184: --