DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on PA_CONTROL_ITEMS

Line 668: PA_CONTROL_ITEMS pci

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