APPS.JA_CN_COA_EXP_PKG dependencies on PO_VENDOR_CONTACTS

Line 1532: FROM PO_VENDOR_CONTACTS PVC

1528: SELECT DISTINCT
1529: '0' || DECODE(nvl(PVC.AREA_CODE, ''), '', '', PVC.AREA_CODE || '-')
1530: || nvl(PVC.PHONE, '') sup_phone
1531: BULK COLLECT INTO l_all_sup_phone
1532: FROM PO_VENDOR_CONTACTS PVC
1533: ,PO_VENDOR_SITES_ALL PVSA
1534: ,HR_ORGANIZATION_INFORMATION HOI
1535: WHERE PVC.vendor_site_id = PVSA.vendor_site_id
1536: --Check "Primary Pay" Vendor site of OUs under current LE

Line 1552: FROM PO_VENDOR_CONTACTS PVC

1548: nvl(PVC.AREA_CODE, '')
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';