DBA Data[Home] [Help]

APPS.PON_EXHIBITS_PKG dependencies on FND_LOOKUP_VALUES

Line 360: from fnd_lookup_values

356:
357: SELECT lookup_code
358: INTO p_new_exhibit_number
359: FROM (select lookup_code
360: from fnd_lookup_values
361: where lookup_type = 'PO_CLM_EXHIBIT_NUMBER'
362: AND Length(lookup_code) = 1
363: AND lookup_code NOT IN
364: (SELECT exhibit_number FROM pon_auction_exhibit_details WHERE auction_header_id=p_source_auction_header_id)

Line 372: from fnd_lookup_values

368: ELSE
369: SELECT lookup_code
370: INTO p_new_exhibit_number
371: FROM (select lookup_code
372: from fnd_lookup_values
373: where lookup_type = 'PO_CLM_EXHIBIT_NUMBER'
374: AND lookup_code NOT IN
375: (SELECT exhibit_number FROM pon_auction_exhibit_details WHERE auction_header_id=p_source_auction_header_id)
376: ORDER BY length(lookup_code), lookup_code)