1547: || DECODE(NVL(PVC.AREA_CODE, ''),'','','-')
1548: || nvl(PVC.PHONE, '') sup_phone
1549: BULK COLLECT INTO l_all_sup_phone
1550: FROM PO_VENDOR_CONTACTS PVC
1551: ,AP_SUPPLIER_SITES_ALL ASSA
1552: WHERE PVC.VENDOR_SITE_ID=ASSA.VENDOR_SITE_ID
1553: AND ASSA.VENDOR_ID=l_vender_id --using variable l_vender_id
1554: AND nvl(ASSA.PRIMARY_PAY_SITE_FLAG, 'N') = 'Y';
1555: