APPS.PON_RESP_SCORES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 105

select
	a.from_range,
	a.to_range,
	a.value,
	a.score,
	b.datatype,
        b.sequence_number
from
	pon_attribute_scores a,
	pon_auction_attributes b
where
	b.auction_header_id 		= x_auction_id
and	b.line_number			= x_line_number
and	b.sequence_number		= x_attr_seq_number
and	a.auction_header_id		= b.auction_header_id
and	a.line_number			= b.line_number
and	a.attribute_sequence_number = b.sequence_number;

Line: 134

select SHOW_BIDDER_SCORES into x_show_scores
from pon_auction_headers_all
where auction_header_id = x_auction_id;