APPS.QPR_PRICE_NEGOTIATION_PUB SQL Statements

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

Line: 67

        select response_header_id into p_response_id
        from (
        select response_header_id
        from qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req
        where resp.request_header_id = req.request_header_id
        and req.source_ref_hdr_short_desc = (p_quote_number || ' - Ver ' || p_quote_version)
        and req.source_id = p_quote_origin
        and req.instance_id = p_instance_id
        order by resp.request_header_id, resp.version_number desc)
        where rownum < 2;

Line: 135

	select response_status, response_header_id
	into l_response_status, l_deal_id
	from (
	select resp.response_status, resp.response_header_id
	from qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req
	where resp.request_header_id = req.request_header_id
	and req.source_ref_hdr_id = p_quote_header_id
	and req.source_id = p_quote_origin
	order by resp.version_number)
	where rownum < 2;

Line: 375

select distinct rule_description
from qpr_pn_response_approvals pnra, qpr_pn_request_hdrs_b pnre,
	qpr_pn_response_hdrs pnrs
where pnra.response_header_id = pnrs.response_header_id
and pnrs.request_header_id = pnre.request_header_id
and pnrs.version_number = 1
and pnre.source_id = source_id
and pnre.source_ref_hdr_id = source_ref_id
and pnre.instance_id = instance_id;