DBA Data[Home] [Help]

APPS.QPR_PRICE_NEGOTIATION_PUB dependencies on QPR_PN_REQUEST_HDRS_B

Line 70: from qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req

66: begin
67: select response_header_id into p_response_id
68: from (
69: select response_header_id
70: from qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req
71: where resp.request_header_id = req.request_header_id
72: and req.source_ref_hdr_short_desc = (p_quote_number || ' - Ver ' || p_quote_version)
73: and req.source_id = p_quote_origin
74: and req.instance_id = p_instance_id

Line 139: from qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req

135: select response_status, response_header_id
136: into l_response_status, l_deal_id
137: from (
138: select resp.response_status, resp.response_header_id
139: from qpr_pn_response_hdrs resp, qpr_pn_request_hdrs_b req
140: where resp.request_header_id = req.request_header_id
141: and req.source_ref_hdr_id = p_quote_header_id
142: and req.source_id = p_quote_origin
143: order by resp.version_number)

Line 376: from qpr_pn_response_approvals pnra, qpr_pn_request_hdrs_b pnre,

372: l_count_lines number;
373:
374: cursor c_resp_app is
375: select distinct rule_description
376: from qpr_pn_response_approvals pnra, qpr_pn_request_hdrs_b pnre,
377: qpr_pn_response_hdrs pnrs
378: where pnra.response_header_id = pnrs.response_header_id
379: and pnrs.request_header_id = pnre.request_header_id
380: and pnrs.version_number = 1