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;
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;