DBA Data[Home] [Help]

APPS.INVPVDR6 dependencies on FND_LOOKUP_VALUES_VL

Line 60: FROM FND_LOOKUP_VALUES_VL

56: -- Added the cursor for bug # 3762750
57: CURSOR c_fndlookup_exists(cp_lookup_type VARCHAR2,
58: cp_lookup_code VARCHAR2) IS
59: SELECT 'x'
60: FROM FND_LOOKUP_VALUES_VL
61: WHERE LOOKUP_TYPE = cp_lookup_type
62: AND LOOKUP_CODE = cp_lookup_code
63: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
64: AND ENABLED_FLAG = 'Y';