1665: or exists (select null
1666: from rcv_headers_interface rhi
1667: where rhi.vendor_id = pvl.vendor_id)
1668: or exists (select null
1669: from rcv_transactions_interface rti
1670: where rti.vendor_id = pvl.vendor_id);
1671:
1672:
1673: end if;
3554: from rcv_headers_interface rhi
3555: where rhi.vendor_id = pvl.vendor_id)
3556: or
3557: exists (select null
3558: from rcv_transactions_interface rti
3559: where rti.vendor_id = pvl.vendor_id));
3560: end if;
3561:
3562: if (g_chv_status = 'Y') then