APPS.PO_CONC_MODS_PVT dependencies on PO_HEADERS_ALL

Line 153: SELECT type_lookup_code INTO l_doc_subtype FROM po_headers_all WHERE po_header_id = l_document_id ;

149: --action requested details
150:
151: wf_engine.SetItemAttrText ( itemtype => l_itemtype, itemkey => l_itemkey, aname =>
152: 'ACTION_REQ_DETAILS' , avalue => p_action_req_details);
153: SELECT type_lookup_code INTO l_doc_subtype FROM po_headers_all WHERE po_header_id = l_document_id ;
154:
155: l_edit_po_url := po_reqapproval_init1.get_mod_url(
156: p_po_header_id => l_document_id
157: ,p_draft_id => p_lock_by_draft_id