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);