APPS.OKL_QA_DATA_INTEGRITY dependencies on HZ_LOCATIONS

Line 4390: FROM hz_locations l

4386: CURSOR location_name_csr (p_location_id NUMBER) IS
4387: SELECT
4388: substr(arp_addr_label_pkg.format_address(null,l.address1,l.address2,l.address3,l.address4,l.city,l.county,
4389: l.state,l.province,l.postal_code,null,l.country,null,null,null,null,null,null,null,'n','n',80,1,1),1,80)
4390: FROM hz_locations l
4391: WHERE l.location_id = p_location_id;
4392:
4393: CURSOR location_for_party_csr (p_party_site_id NUMBER) IS
4394: SELECT

Line 4397: FROM hz_locations l,

4393: CURSOR location_for_party_csr (p_party_site_id NUMBER) IS
4394: SELECT
4395: substr(arp_addr_label_pkg.format_address(null,l.address1,l.address2,l.address3,l.address4,l.city,l.county,
4396: l.state,l.province,l.postal_code,null,l.country,null,null,null,null,null,null,null,'n','n',80,1,1),1,80)
4397: FROM hz_locations l,
4398: hz_party_sites site
4399: WHERE site.party_site_id = p_party_site_id
4400: AND l.location_id = site.location_id;
4401:

Line 4522: ELSIF l_install_location_type_code = 'HZ_LOCATIONS' THEN

4518: );
4519: x_return_status := Okl_Api.G_RET_STS_ERROR;
4520: END IF;
4521:
4522: ELSIF l_install_location_type_code = 'HZ_LOCATIONS' THEN
4523: l_party_site_id := NULL;
4524: l_location_id := NULL;
4525: OPEN party_site_id_csr (okl_iipv_rec.object_id1_new);
4526: FETCH party_site_id_csr INTO l_party_site_id;