695: SELECT PAR.pay_site_id,
696: PV.vendor_name
697: FROM OKL_PARTY_PAYMENT_DTLS_V PAR,
698: PO_VENDORS PV,
699: PO_VENDOR_SITES_ALL VS
700: WHERE PAR.cpl_id = p_party_id
701: AND PAR.pay_site_id = VS.vendor_site_id(+)
702: AND VS.vendor_id = PV.vendor_id;
703: