APPS.PO_CHANGEORDERWF_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 7635: from po_requisition_headers_all porh,

7631:
7632: -- curosr to get the ReqHeaderId
7633: cursor c_getReqHdrId(p_po_header_id_csr IN NUMBER) is
7634: select distinct porh.requisition_header_id
7635: from po_requisition_headers_all porh,
7636: po_requisition_lines_all porl,
7637: po_headers_all poh,
7638: po_line_locations_all poll
7639: where porh.requisition_header_id = porl.requisition_header_id AND

Line 7670: update po_requisition_headers_all

7666: LOOP
7667: FETCH c_getReqHdrId INTO l_req_hdr_id;
7668: EXIT WHEN c_getReqHdrId%NOTFOUND;
7669: BEGIN
7670: update po_requisition_headers_all
7671: set change_pending_flag = 'N'
7672: where requisition_header_id = l_req_hdr_id
7673: AND change_pending_flag = 'Y';
7674: EXCEPTION

Line 8103: from po_requisition_headers_all porha

8099: and porla.line_location_id = polla.line_location_id;
8100:
8101: CURSOR getReqNum(c_req_header_id in NUMBER) IS
8102: select porha.segment1
8103: from po_requisition_headers_all porha
8104: where requisition_header_id = c_req_header_id;
8105:
8106: -- for releases
8107: CURSOR getReqHdrId_rel(c_po_header_id in NUMBER, c_po_release_id in NUMBER) IS