How to get supplier ID and supplier site ID for the Isupplier login.

BEGIN
SELECT DISTINCT assa.vendor_id,LISTAGG(assa.vendor_site_id, ‘,’) WITHIN GROUP (ORDER BY assa.vendor_id)
INTO v_vendor_id,v_vendor_site_id
FROM ak_web_user_sec_attr_values aw,
ap_supplier_sites_all assa
WHERE aw.web_user_id = FND_GLOBAL.USER_ID
AND aw.attribute_code = ‘ICX_SUPPLIER_ORG_ID’
AND assa.vendor_id = aw.number_value
AND assa.org_id = FND_GLOBAL.ORG_ID
GROUP BY assa.vendor_id;
EXCEPTION
WHEN OTHERS THEN
v_vendor_id := NULL;
v_vendor_site_id := NULL;
END;