DBA Data[Home] [Help]

APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on FND_LOOKUP_VALUES

Line 737: FROM fnd_lookup_values

733: ELSE
734:
735: SELECT meaning
736: INTO l_status
737: FROM fnd_lookup_values
738: WHERE language = USERENV('LANG')
739: AND lookup_type = 'PON_AUCTION_STATUS'
740: AND lookup_code = p_status_code;
741: END IF;

Line 777: FROM fnd_lookup_values

773:
774: -- Get the status using the lookup type.
775: SELECT meaning
776: INTO l_status
777: FROM fnd_lookup_values
778: WHERE lookup_type = l_lookup_type
779: AND language = USERENV('LANG')
780: AND lookup_code = p_status_code;
781: END IF;