APPS.OTA_UTILITY dependencies on HR_ALL_ORGANIZATION_UNITS_TL
Line 2430: select name from hr_all_organization_units_tl
2426: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
2427: RETURN VARCHAR2 IS
2428:
2429: CURSOR c_organization_name IS 2430: select name from hr_all_organization_units_tl 2431: where language = userenv('LANG') and organization_id = p_organization_id;
2432:
2433: CURSOR c_customer_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS
2434: select substrb(party.party_name,1,50)