APPS.OKL_QA_DATA_INTEGRITY dependencies on HZ_PARTY_SITES

Line 4371: FROM hz_party_sites

4367: -- bug 6795295 changed name of cursor
4368: -- CURSOR location_csr (p_party_site_id NUMBER) IS
4369: CURSOR location_id_csr (p_party_site_id NUMBER) IS
4370: SELECT location_id
4371: FROM hz_party_sites
4372: WHERE PARTY_SITE_ID = p_party_site_id;
4373:
4374:
4375: CURSOR asset_num_csr(p_cle_id NUMBER) IS

Line 4398: hz_party_sites site

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:
4402: CURSOR header_details_csr (p_chr_id NUMBER) IS

Line 4413: l_location_id hz_party_sites.location_id%TYPE;

4409:
4410: l_instance_id csi_item_instances.instance_id%TYPE;
4411: l_install_location_id csi_item_instances.install_location_id%TYPE;
4412: l_install_location_type_code csi_item_instances.install_location_type_code%TYPE;
4413: l_location_id hz_party_sites.location_id%TYPE;
4414: l_serial_number_control_code VARCHAR2(3);
4415: l_trx_line_type_book VARCHAR2(10);
4416: l_party_site_id hz_party_site_uses.party_site_id%TYPE;
4417: l_asset_num okc_k_lines_tl.name%TYPE;

Line 4485: ELSIF l_install_location_type_code = 'HZ_PARTY_SITES' THEN

4481:
4482: IF (l_instance_id IS NULL) THEN
4483: NULL; -- no ib instance
4484:
4485: ELSIF l_install_location_type_code = 'HZ_PARTY_SITES' THEN
4486: l_party_site_id := NULL;
4487: OPEN party_site_id_csr (okl_iipv_rec.object_id1_new);
4488: FETCH party_site_id_csr INTO l_party_site_id;
4489: CLOSE party_site_id_csr;

Line 9193: HZ_PARTY_SITES B

9189: FROM dual
9190: WHERE EXISTS(
9191: SELECT A.party_site_use_id
9192: FROM HZ_PARTY_SITE_USES A,
9193: HZ_PARTY_SITES B
9194: WHERE b.party_site_id = a.party_site_id
9195: AND a.party_site_use_id = instId
9196: AND a.site_use_type = rleCode
9197: AND b.party_id = ptyId);