DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on FND_LOOKUP_VALUES_VL

Line 359: FROM FND_LOOKUP_VALUES_VL

355: -- Added the cursor for bug # 3762750
356: CURSOR c_fndlookup_exists(cp_lookup_type VARCHAR2,
357: cp_lookup_code VARCHAR2) IS
358: SELECT 'x'
359: FROM FND_LOOKUP_VALUES_VL
360: WHERE LOOKUP_TYPE = cp_lookup_type
361: AND LOOKUP_CODE = cp_lookup_code
362: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
363: AND ENABLED_FLAG = 'Y';