DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_VENDOR_CONTACTS

Line 3745: FROM PO_VENDOR_CONTACTS pvc, po_headers_gt poh

3741: substr(l_textline,1,240),
3742: 'PO_PDOI_INVALID_VDR_CNTCT'
3743: FROM dual
3744: WHERE NOT EXISTS (SELECT 'Y'
3745: FROM PO_VENDOR_CONTACTS pvc, po_headers_gt poh
3746: WHERE POH.po_header_id = l_agreement_id
3747: AND pvc.vendor_contact_id =poh.vendor_contact_id
3748: AND SYSDATE < nvl(pvc.inactive_date, SYSDATE+1));
3749:

Line 5539: FROM PO_VENDOR_CONTACTS pvc, po_headers_gt poh

5535: substr(l_textline,1,240),
5536: 'PO_PDOI_INVALID_VDR_CNTCT'
5537: FROM dual
5538: WHERE NOT EXISTS (SELECT 'Y'
5539: FROM PO_VENDOR_CONTACTS pvc, po_headers_gt poh
5540: WHERE POH.po_header_id = p_document_id
5541: AND pvc.vendor_contact_id =poh.vendor_contact_id
5542: AND SYSDATE < nvl(pvc.inactive_date, SYSDATE+1));
5543: