APPS.OKL_QA_DATA_INTEGRITY dependencies on HZ_LOCATIONS

Line 4777: FROM hz_locations l

4773: CURSOR location_name_csr (p_location_id NUMBER) IS
4774: SELECT
4775: substr(arp_addr_label_pkg.format_address(null,l.address1,l.address2,l.address3,l.address4,l.city,l.county,
4776: l.state,l.province,l.postal_code,null,l.country,null,null,null,null,null,null,null,'n','n',80,1,1),1,80)
4777: FROM hz_locations l
4778: WHERE l.location_id = p_location_id;
4779:
4780: CURSOR location_for_party_csr (p_party_site_id NUMBER) IS
4781: SELECT

Line 4784: FROM hz_locations l,

4780: CURSOR location_for_party_csr (p_party_site_id NUMBER) IS
4781: SELECT
4782: substr(arp_addr_label_pkg.format_address(null,l.address1,l.address2,l.address3,l.address4,l.city,l.county,
4783: l.state,l.province,l.postal_code,null,l.country,null,null,null,null,null,null,null,'n','n',80,1,1),1,80)
4784: FROM hz_locations l,
4785: hz_party_sites site
4786: WHERE site.party_site_id = p_party_site_id
4787: AND l.location_id = site.location_id;
4788:

Line 4909: ELSIF l_install_location_type_code = 'HZ_LOCATIONS' THEN

4905: );
4906: x_return_status := Okl_Api.G_RET_STS_ERROR;
4907: END IF;
4908:
4909: ELSIF l_install_location_type_code = 'HZ_LOCATIONS' THEN
4910: l_party_site_id := NULL;
4911: l_location_id := NULL;
4912: OPEN party_site_id_csr (okl_iipv_rec.object_id1_new);
4913: FETCH party_site_id_csr INTO l_party_site_id;