DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on PO_VENDOR_CONTACTS

Line 687: FROM PO_VENDOR_CONTACTS

683: x_progress := '003';
684: BEGIN
685: SELECT distinct 'Y'
686: INTO x_valid_flag
687: FROM PO_VENDOR_CONTACTS
688: WHERE vendor_contact_id = x_vendor_contact_id
689: AND vendor_site_id = x_vendor_site_id
690: AND SYSDATE < nvl(inactive_date, SYSDATE+1);
691: EXCEPTION