DBA Data[Home] [Help]

APPS.AHL_FMP_MR_RELATION_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 20: FROM FND_LOOKUP_VALUES_VL

16: as
17: CURSOR get_lookup_type_code(c_lookup_code VARCHAR2,c_lookup_type VARCHAR2)
18: IS
19: SELECT lookup_code
20: FROM FND_LOOKUP_VALUES_VL
21: WHERE lookup_code = c_lookup_code
22: AND lookup_type = c_lookup_type
23: AND sysdate between nvl(start_date_active,sysdate)
24: AND nvl(end_date_active,sysdate);