APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on FND_LOOKUP_VALUES

Line 731: FROM fnd_lookup_values

727: ELSE
728:
729: SELECT meaning
730: INTO l_status
731: FROM fnd_lookup_values
732: WHERE language = USERENV('LANG')
733: AND lookup_type = 'PON_AUCTION_STATUS'
734: AND lookup_code = p_status_code;
735: END IF;

Line 771: FROM fnd_lookup_values

767:
768: -- Get the status using the lookup type.
769: SELECT meaning
770: INTO l_status
771: FROM fnd_lookup_values
772: WHERE lookup_type = l_lookup_type
773: AND language = USERENV('LANG')
774: AND lookup_code = p_status_code;
775: END IF;