APPS.MRP_CL_FUNCTION dependencies on HZ_LOCATIONS

Line 1465: from AP_SUPPLIER_SITES_ALL PVS ,HZ_LOCATIONS HL

1461: where last_update_date >= p_date and creation_date < p_date;
1462:
1463: Cursor all_vendor_sites is
1464: select PVS.vendor_site_id,PVS.country,PVS.state,PVS.city,PVS.zip,nvl(HL.language,userenv('LANG')) lang
1465: from AP_SUPPLIER_SITES_ALL PVS ,HZ_LOCATIONS HL
1466: WHERE PVS.LOCATION_ID = HL.LOCATION_ID(+);
1467:
1468: Cursor new_vendor_sites(p_date DATE) is
1469: select PVS.vendor_site_id,PVS.country,PVS.state,PVS.city,PVS.zip,nvl(HL.language,userenv('LANG')) lang

Line 1470: from AP_SUPPLIER_SITES_ALL PVS ,HZ_LOCATIONS HL

1466: WHERE PVS.LOCATION_ID = HL.LOCATION_ID(+);
1467:
1468: Cursor new_vendor_sites(p_date DATE) is
1469: select PVS.vendor_site_id,PVS.country,PVS.state,PVS.city,PVS.zip,nvl(HL.language,userenv('LANG')) lang
1470: from AP_SUPPLIER_SITES_ALL PVS ,HZ_LOCATIONS HL
1471: where PVS.last_update_date >= p_date
1472: AND PVS.LOCATION_ID = HL.LOCATION_ID(+);
1473:
1474: TYPE VendorSiteTblTyp IS TABLE OF AP_SUPPLIER_SITES_ALL.VENDOR_SITE_ID%TYPE;

Line 1479: TYPE langTblTyp IS TABLE OF HZ_LOCATIONS.LANGUAGE%TYPE;

1475: TYPE CountryTblTyp IS TABLE OF AP_SUPPLIER_SITES_ALL.COUNTRY%TYPE;
1476: TYPE StateTblTyp IS TABLE OF AP_SUPPLIER_SITES_ALL.STATE%TYPE;
1477: TYPE CityTblTyp IS TABLE OF AP_SUPPLIER_SITES_ALL.CITY%TYPE;
1478: TYPE ZipTblTyp IS TABLE OF AP_SUPPLIER_SITES_ALL.ZIP%TYPE;
1479: TYPE langTblTyp IS TABLE OF HZ_LOCATIONS.LANGUAGE%TYPE;
1480: TYPE NumTblTyp IS TABLE OF NUMBER;
1481:
1482: l_vendor_site_tab VendorSiteTblTyp ;
1483: l_vendor_site_tab1 VendorSiteTblTyp ;