APPS.PO_SUPPLY dependencies on PO_REQUISITION_HEADERS

Line 491: -- po_requisition_headers instead of po_headers. Verified against

487:
488: l_auth_status po_headers.authorization_status%TYPE;
489:
490: -- : This cursor was incorrectly accessing
491: -- po_requisition_headers instead of po_headers. Verified against
492: -- older Pro*C code, which was using po_headers.
493:
494: /*Bug 4537860:Hit the _all tables instead of the striped views.*/
495: CURSOR auth_status(header_id NUMBER)

Line 2164: FROM po_requisition_headers_all

2160:
2161: CURSOR auth_status(header_id NUMBER)
2162: IS
2163: SELECT authorization_status
2164: FROM po_requisition_headers_all
2165: WHERE requisition_header_id = header_id;
2166:
2167: l_auth_status po_requisition_headers.authorization_status%TYPE;
2168:

Line 2167: l_auth_status po_requisition_headers.authorization_status%TYPE;

2163: SELECT authorization_status
2164: FROM po_requisition_headers_all
2165: WHERE requisition_header_id = header_id;
2166:
2167: l_auth_status po_requisition_headers.authorization_status%TYPE;
2168:
2169: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_req';
2170: d_progress NUMBER;
2171:

Line 2391: FROM po_requisition_headers_all

2387: d_progress := 20;
2388:
2389: BEGIN
2390: SELECT conformed_header_id INTO l_conformed_id
2391: FROM po_requisition_headers_all
2392: WHERE requisition_header_id = p_entity_id;
2393: EXCEPTION
2394: WHEN No_Data_Found THEN
2395: l_conformed_id := NULL;