APPS.QPR_DEAL_PVT dependencies on QPR_PN_RESPONSE_HDRS

Line 606: from qpr_pn_request_hdrs_b req, qpr_pn_response_hdrs res

602: p_quote_header_id is null then
603: begin
604: select req.source_id, req.source_ref_hdr_id, req.instance_id
605: into quote_origin, quote_header_id, instance_id
606: from qpr_pn_request_hdrs_b req, qpr_pn_response_hdrs res
607: where req.request_header_id = res.request_header_id
608: and req.source_ref_hdr_id = nvl(p_quote_header_id, req.source_ref_hdr_id)
609: and req.source_id = nvl(p_quote_origin, req.source_id)
610: and req.request_header_id = nvl(p_request_header_id, req.request_header_id)

Line 759: qpr_pn_response_hdrs res

755: l_dummy number;
756: begin
757: select count(*) into l_dummy
758: from qpr_pn_request_hdrs_b req,
759: qpr_pn_response_hdrs res
760: where req.request_header_id = res.request_header_id
761: and req.source_ref_hdr_id = p_quote_header_id
762: and req.source_id = p_quote_origin
763: and req.instance_id = p_instance_id

Line 791: qpr_pn_response_hdrs res

787: begin
788: select req.source_id, req.source_ref_hdr_id, req.instance_id
789: into l_source_id, l_source_header_id, l_instance_id
790: from qpr_pn_request_hdrs_b req,
791: qpr_pn_response_hdrs res
792: where req.request_header_id = res.request_header_id
793: and res.response_header_id = p_response_hdr_id
794: and nvl(req.request_status, 'ACTIVE') <> 'CANCELLED';
795: -- and nvl(req.request_status, 'ACTIVE') = 'ACTIVE';

Line 868: qpr_pn_response_hdrs res

864: l_fnd_user := fnd_global.user_name;
865: select req.source_id, req.source_ref_hdr_id, req.instance_id
866: into l_source_id, l_source_header_id, l_instance_id
867: from qpr_pn_request_hdrs_b req,
868: qpr_pn_response_hdrs res
869: where req.request_header_id = res.request_header_id
870: and res.response_header_id = p_response_hdr_id
871: and nvl(req.request_status, 'ACTIVE') <> 'CANCELLED';
872: l_ret1 := 'Y';