APPS.JA_CN_COA_EXP_PKG dependencies on PO_VENDOR_SITES_ALL

Line 1352: TYPE t_sup_city_addr IS RECORD ( city PO_VENDOR_SITES_ALL.CITY%TYPE

1348:
1349: --For supplier
1350: l_vender_id PO_VENDORS.VENDOR_ID%TYPE;
1351: --For city and address of supplier
1352: TYPE t_sup_city_addr IS RECORD ( city PO_VENDOR_SITES_ALL.CITY%TYPE
1353: ,addr PO_VENDOR_SITES_ALL.ADDRESS_LINE1%TYPE
1354: );
1355: TYPE t_sup_city_addr_array IS TABLE OF t_sup_city_addr;
1356: l_all_sup_city_addr t_sup_city_addr_array;

Line 1353: ,addr PO_VENDOR_SITES_ALL.ADDRESS_LINE1%TYPE

1349: --For supplier
1350: l_vender_id PO_VENDORS.VENDOR_ID%TYPE;
1351: --For city and address of supplier
1352: TYPE t_sup_city_addr IS RECORD ( city PO_VENDOR_SITES_ALL.CITY%TYPE
1353: ,addr PO_VENDOR_SITES_ALL.ADDRESS_LINE1%TYPE
1354: );
1355: TYPE t_sup_city_addr_array IS TABLE OF t_sup_city_addr;
1356: l_all_sup_city_addr t_sup_city_addr_array;
1357: l_sup_city_addr t_sup_city_addr;

Line 1496: FROM PO_VENDOR_SITES_ALL PVSA

1492: nvl(PVSA.STATE, '')) sup_city
1493: */
1494: ,nvl(PVSA.ADDRESS_LINE1, '') sup_addr
1495: BULK COLLECT INTO l_all_sup_city_addr
1496: FROM PO_VENDOR_SITES_ALL PVSA
1497: ,HR_ORGANIZATION_INFORMATION HOI
1498: WHERE --Check "Primary Pay" Vendor site of OUs under current LE
1499: HOI.org_information_context = 'Operating Unit Information'
1500: AND HOI.Org_Information2 = l_le_id --using variable l_le_id

Line 1531: ,PO_VENDOR_SITES_ALL PVSA

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