APPS.AHL_DI_DOC_INDEX_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 147: FROM FND_LOOKUP_VALUES_VL

143:
144: CURSOR get_product_type_code(c_product_type_code VARCHAR2)
145: IS
146: SELECT lookup_code
147: FROM FND_LOOKUP_VALUES_VL
148: WHERE lookup_code = c_product_type_code
149: --Enhancement #2525604: pbarman : April 2003
150: AND lookup_type = 'ITEM_TYPE'
151:

Line 1166: FROM FND_LOOKUP_VALUES_VL

1162: -- Cursor to retrieve the preference code from fnd lookups
1163: CURSOR get_preference_code(c_preference_code VARCHAR2)
1164: IS
1165: SELECT lookup_code
1166: FROM FND_LOOKUP_VALUES_VL
1167: WHERE lookup_code = c_preference_code
1168: AND lookup_type = 'AHL_SUPPLIER_PREF_TYPE'
1169: AND sysdate between nvl(start_date_active,sysdate)
1170: AND nvl(end_date_active,sysdate);