APPS.JA_CN_COA_EXP_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 1553: ,AP_SUPPLIER_SITES_ALL ASSA

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