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 3381: FROM po_requisition_headers porh

3377: -- Find the original agent or preparer of the document depending on its type
3378: IF (p_doc_type = 'REQUISITION') THEN
3379: SELECT porh.preparer_id
3380: INTO l_doc_agent_id
3381: FROM po_requisition_headers porh
3382: WHERE porh.requisition_header_id = p_doc_id;
3383: ELSIF (p_doc_type = 'RELEASE') THEN
3384: SELECT por.agent_id
3385: INTO l_doc_agent_id