1394: WHERE fund_id = p_segment_used_by_id;
1395:
1396: CURSOR c_segment_exists (p_segment IN VARCHAR2) IS
1397: SELECT 1 1398: FROM ozf_lookups 1399: WHERE lookup_type = 'OZF_OFFER_DEAL_CUSTOMER_TYPES'
1400: AND enabled_flag = 'Y'
1401: AND lookup_code = p_segment;
1402: