DBA Data[Home] [Help]

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')