DBA Data[Home] [Help]

APPS.AHL_FMP_MR_ACTION_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 244: FROM FND_LOOKUP_VALUES_VL

240: as
241: CURSOR get_lookup_meaning_to_code(c_lookup_type VARCHAR2,c_meaning VARCHAR2)
242: IS
243: SELECT lookup_code
244: FROM FND_LOOKUP_VALUES_VL
245: WHERE lookup_type= c_lookup_type
246: AND upper(meaning)=upper(c_meaning)
247: AND sysdate between start_date_active
248: AND nvl(end_date_active,sysdate);