DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on FND_LOOKUP_VALUES_VL

Line 357: FROM FND_LOOKUP_VALUES_VL

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