DBA Data[Home] [Help]

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