APPS.PO_COPYDOC_SUB dependencies on PO_VENDORS

Line 443: -- Bug# 4546121:All columns that referred to the obsolete columns in po_vendors have

439: BEGIN
440:
441: x_progress := '001';
442:
443: -- Bug# 4546121:All columns that referred to the obsolete columns in po_vendors have
444: -- been nulled out.
445: SELECT null,
446: null,
447: null,

Line 457: FROM PO_VENDORS

453: x_ship_via_lookup_code,
454: x_fob_lookup_code,
455: x_freight_terms_lu_code,
456: x_terms_id
457: FROM PO_VENDORS
458: WHERE vendor_id = x_vendor_id;
459:
460: EXCEPTION
461: WHEN NO_DATA_FOUND THEN

Line 626: FROM PO_VENDORS

622: x_progress := '001';
623: BEGIN
624: SELECT distinct 'Y'
625: INTO x_valid_flag
626: FROM PO_VENDORS
627: WHERE vendor_id = x_vendor_id
628: AND enabled_flag = 'Y'
629: AND SYSDATE BETWEEN nvl(start_date_active, SYSDATE-1)
630: AND nvl(end_date_active, SYSDATE+1);