248: RETURN VARCHAR2
249: IS
250: CURSOR c_uom (b_lookup_code VARCHAR2) IS
251: SELECT meaning
252: FROM fnd_lookups
253: WHERE lookup_type = 'CAC_VIEW_REMINDER_UOM'
254: AND lookup_code = b_lookup_code
255: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
256: AND TRUNC(NVL(end_date_active, SYSDATE));
513: RETURN VARCHAR2
514: IS
515: CURSOR c_uom (b_lookup_code VARCHAR2) IS
516: SELECT meaning
517: FROM fnd_lookups
518: WHERE lookup_type = 'CAC_VIEW_DURATION'
519: AND lookup_code = b_lookup_code
520: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
521: AND TRUNC(NVL(end_date_active, SYSDATE));