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 1992: FROM po_requisition_headers_all

1988:
1989: CURSOR auth_status(header_id NUMBER)
1990: IS
1991: SELECT authorization_status
1992: FROM po_requisition_headers_all
1993: WHERE requisition_header_id = header_id;
1994:
1995: l_auth_status po_requisition_headers.authorization_status%TYPE;
1996:

Line 1995: l_auth_status po_requisition_headers.authorization_status%TYPE;

1991: SELECT authorization_status
1992: FROM po_requisition_headers_all
1993: WHERE requisition_header_id = header_id;
1994:
1995: l_auth_status po_requisition_headers.authorization_status%TYPE;
1996:
1997: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_req';
1998: d_progress NUMBER;
1999: