DBA Data[Home] [Help]

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)