DBA Data[Home] [Help]

APPS.CAC_VIEW_UTIL_PVT dependencies on FND_LOOKUPS

Line 252: FROM fnd_lookups

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));

Line 517: FROM fnd_lookups

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));