APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_REQUISITION_HEADERS

Line 72: FROM po_requisition_headers porh

68: FOR UPDATE NOWAIT;
69: ELSIF (p_doc_type = 'REQUISITION') THEN
70: SELECT 'Lock req'
71: INTO l_lock_row
72: FROM po_requisition_headers porh
73: WHERE porh.requisition_header_id = p_doc_id
74: FOR UPDATE NOWAIT;
75: ELSE
76: -- This document type is not supported

Line 3526: FROM po_requisition_headers porh

3522: -- Find the original agent or preparer of the document depending on its type
3523: IF (p_doc_type = 'REQUISITION') THEN
3524: SELECT porh.preparer_id
3525: INTO l_doc_agent_id
3526: FROM po_requisition_headers porh
3527: WHERE porh.requisition_header_id = p_doc_id;
3528: ELSIF (p_doc_type = 'RELEASE') THEN
3529: SELECT por.agent_id
3530: INTO l_doc_agent_id