APPS.PO_CHANGEORDERWF_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 7793: from po_requisition_headers_all porh,

7789:
7790: -- curosr to get the ReqHeaderId
7791: cursor c_getReqHdrId(p_po_header_id_csr IN NUMBER) is
7792: select distinct porh.requisition_header_id
7793: from po_requisition_headers_all porh,
7794: po_requisition_lines_all porl,
7795: po_headers_all poh,
7796: po_line_locations_all poll
7797: where porh.requisition_header_id = porl.requisition_header_id AND

Line 7828: update po_requisition_headers_all

7824: LOOP
7825: FETCH c_getReqHdrId INTO l_req_hdr_id;
7826: EXIT WHEN c_getReqHdrId%NOTFOUND;
7827: BEGIN
7828: update po_requisition_headers_all
7829: set change_pending_flag = 'N'
7830: where requisition_header_id = l_req_hdr_id
7831: AND change_pending_flag = 'Y';
7832: EXCEPTION

Line 8378: from po_requisition_headers_all porha

8374: and porla.line_location_id = polla.line_location_id;
8375:
8376: CURSOR getReqNum(c_req_header_id in NUMBER) IS
8377: select porha.segment1
8378: from po_requisition_headers_all porha
8379: where requisition_header_id = c_req_header_id;
8380:
8381: -- for releases
8382: CURSOR getReqHdrId_rel(c_po_header_id in NUMBER, c_po_release_id in NUMBER) IS