DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 2366: select name from hr_all_organization_units_tl

2362: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
2363: RETURN VARCHAR2 IS
2364:
2365: CURSOR c_organization_name IS
2366: select name from hr_all_organization_units_tl
2367: where language = userenv('LANG') and organization_id = p_organization_id;
2368:
2369: CURSOR c_customer_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS
2370: select substrb(party.party_name,1,50)