APPS.PA_PO_INTEGRATION_UTILS dependencies on PA_CI_SUPPLIER_DETAILS
Line 667: FROM PA_CI_SUPPLIER_DETAILS pcsd,
663: --Cursor to update the change document to reference the new supplier.
664:
665: CURSOR c_update_doc(p_po_header_id IN NUMBER) IS
666: SELECT DISTINCT pcsd.ci_id, pcsd.creation_date -- Added for the bug 13617899 667: FROM PA_CI_SUPPLIER_DETAILS pcsd, 668: PA_CONTROL_ITEMS pci
669: WHERE pcsd.PO_HEADER_ID = p_po_header_id
670: AND pcsd.CI_ID = pci.CI_ID
671: AND pci.STATUS_CODE NOT IN ('CI_APPROVED', 'CI_CANCELED', 'CI_CLOSED' );