APPS.PO_CLM_DOCUMENT_CONTROL_PVT dependencies on PO_DRAFTS
Line 280: FROM po_drafts
276: SELECT 'Y'
277: INTO l_open_mod_exists_flag
278: FROM dual
279: WHERE EXISTS (SELECT 'open mod exists' 280: FROM po_drafts 281: WHERE document_id = p_doc_header_id
282: AND status NOT IN ('COMPLETED', 'WITHDRAWN')
283: -- IN ('DRAFT', 'IN PROCESS', 'REJECTED',
284: -- 'PRE-APPROVED', 'SUPPLIER SIGN')