APPS.AHL_WBS_RULES_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 108: FROM fnd_lookup_values_vl

104:
105: CURSOR CHK_ROUTE_TYPE(c_route_type VARCHAR2)
106: IS
107: SELECT count(lookup_code)
108: FROM fnd_lookup_values_vl
109: WHERE lookup_type='AHL_ROUTE_TYPE'
110: AND sysdate BETWEEN NVL(start_date_active,sysdate) AND nvl(end_date_active,sysdate)
111: AND lookup_code = c_route_type;
112:

Line 122: FROM fnd_lookup_values_vl

118:
119: CURSOR CHK_PROCESS(c_process VARCHAR2)
120: IS
121: SELECT count(lookup_code)
122: FROM fnd_lookup_values_vl
123: WHERE lookup_type='AHL_PROCESS_CODE'
124: AND sysdate BETWEEN NVL(start_date_active,sysdate) AND nvl(end_date_active,sysdate)
125: AND lookup_code = c_process;
126: