APPS.HZ_ELOCATION_PKG dependencies on AR_LOOKUPS

Line 1807: FROM AR_LOOKUPS

1803: l_party_site_status VARCHAR2(100) := 'NULL ';
1804:
1805: CURSOR c_accuracy_mapping IS
1806: SELECT lookup_code,description,decode(lookup_code,0,2,1)
1807: FROM AR_LOOKUPS
1808: WHERE LOOKUP_TYPE = 'HZ_SPATIAL_ACCURACY_MAPPING'
1809: ORDER BY decode(lookup_code,0,2,1),TO_NUMBER(lookup_code);
1810:
1811: r_accuracy_mapping c_accuracy_mapping%ROWTYPE;

Line 1818: FROM AR_LOOKUPS

1814:
1815: IF p_site_use_type IS NOT NULL THEN
1816: SELECT meaning
1817: INTO l_site_use_type
1818: FROM AR_LOOKUPS
1819: WHERE LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
1820: AND LOOKUP_CODE = p_site_use_type;
1821: END IF;
1822:

Line 1826: FROM AR_LOOKUPS

1822:
1823: IF p_loc_type IS NOT NULL THEN
1824: SELECT meaning
1825: INTO l_loc_type
1826: FROM AR_LOOKUPS
1827: WHERE LOOKUP_TYPE = 'HZ_ELOCATION_TYPE'
1828: AND LOOKUP_CODE = p_loc_type;
1829: END IF;
1830:

Line 1834: FROM AR_LOOKUPS

1830:
1831: IF p_country IS NOT NULL THEN
1832: SELECT meaning
1833: INTO l_country
1834: FROM AR_LOOKUPS
1835: WHERE LOOKUP_TYPE = 'HZ_SPATIAL_VALID_COUNTRIES'
1836: AND LOOKUP_CODE = p_country;
1837: END IF;
1838:

Line 1842: FROM AR_LOOKUPS

1838:
1839: IF p_geometry_source IS NOT NULL THEN
1840: SELECT meaning
1841: INTO l_geometry_source
1842: FROM AR_LOOKUPS
1843: WHERE LOOKUP_TYPE = 'HZ_GEOMETRY_SOURCE'
1844: AND LOOKUP_CODE = p_geometry_source;
1845: END IF;
1846:

Line 1850: FROM AR_LOOKUPS

1846:
1847: IF p_geometry_accuracy IS NOT NULL THEN
1848: SELECT meaning
1849: INTO l_geometry_accuracy
1850: FROM AR_LOOKUPS
1851: WHERE LOOKUP_TYPE = 'HZ_SPATIAL_ACCURACY_MAPPING'
1852: AND LOOKUP_CODE = p_geometry_accuracy;
1853: END IF;
1854:

Line 1858: FROM AR_LOOKUPS

1854:
1855: IF p_party_site_status IS NOT NULL THEN
1856: SELECT meaning
1857: INTO l_party_site_status
1858: FROM AR_LOOKUPS
1859: WHERE LOOKUP_TYPE = 'HZ_LOC_STATUS'
1860: AND LOOKUP_CODE = p_party_site_status;
1861: END IF;
1862:

Line 2167: l_qry_str := l_qry_str ||'FROM hz_locations hl ,ar_lookups arl ';

2163:
2164: -- Dynamic SQL statement
2165: l_qry_str := 'SELECT hl.location_id, hl.address1, hl.address2, hl.address3, hl.address4, hl.city, ';
2166: l_qry_str := l_qry_str ||'hl.postal_code, hl.state, hl.country, hl.county, hl.province ';
2167: l_qry_str := l_qry_str ||'FROM hz_locations hl ,ar_lookups arl ';
2168: l_qry_str := l_qry_str ||'WHERE arl.lookup_type = '|| '''' ||'HZ_SPATIAL_VALID_COUNTRIES'|| '''' ;
2169: l_qry_str := l_qry_str ||' AND hl.country = arl.lookup_code ';
2170:
2171: