DBA Data[Home] [Help]

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 1080: FROM FND_LOOKUP_VALUES_VL

1076: -- Cursor to retrieve the preference code from fnd lookups
1077: CURSOR get_preference_code(c_preference_code VARCHAR2)
1078: IS
1079: SELECT lookup_code
1080: FROM FND_LOOKUP_VALUES_VL
1081: WHERE lookup_code = c_preference_code
1082: AND lookup_type = 'AHL_SUPPLIER_PREF_TYPE'
1083: AND sysdate between nvl(start_date_active,sysdate)
1084: AND nvl(end_date_active,sysdate);