APPS.OKL_QA_DATA_INTEGRITY dependencies on HZ_PARTY_SITES

Line 4758: FROM hz_party_sites

4754: -- bug 6795295 changed name of cursor
4755: -- CURSOR location_csr (p_party_site_id NUMBER) IS
4756: CURSOR location_id_csr (p_party_site_id NUMBER) IS
4757: SELECT location_id
4758: FROM hz_party_sites
4759: WHERE PARTY_SITE_ID = p_party_site_id;
4760:
4761:
4762: CURSOR asset_num_csr(p_cle_id NUMBER) IS

Line 4785: hz_party_sites site

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

Line 4800: l_location_id hz_party_sites.location_id%TYPE;

4796:
4797: l_instance_id csi_item_instances.instance_id%TYPE;
4798: l_install_location_id csi_item_instances.install_location_id%TYPE;
4799: l_install_location_type_code csi_item_instances.install_location_type_code%TYPE;
4800: l_location_id hz_party_sites.location_id%TYPE;
4801: l_serial_number_control_code VARCHAR2(3);
4802: l_trx_line_type_book VARCHAR2(10);
4803: l_party_site_id hz_party_site_uses.party_site_id%TYPE;
4804: l_asset_num okc_k_lines_tl.name%TYPE;

Line 4872: ELSIF l_install_location_type_code = 'HZ_PARTY_SITES' THEN

4868:
4869: IF (l_instance_id IS NULL) THEN
4870: NULL; -- no ib instance
4871:
4872: ELSIF l_install_location_type_code = 'HZ_PARTY_SITES' THEN
4873: l_party_site_id := NULL;
4874: OPEN party_site_id_csr (okl_iipv_rec.object_id1_new);
4875: FETCH party_site_id_csr INTO l_party_site_id;
4876: CLOSE party_site_id_csr;

Line 9614: HZ_PARTY_SITES B

9610: FROM dual
9611: WHERE EXISTS(
9612: SELECT A.party_site_use_id
9613: FROM HZ_PARTY_SITE_USES A,
9614: HZ_PARTY_SITES B
9615: WHERE b.party_site_id = a.party_site_id
9616: AND a.party_site_use_id = instId
9617: AND a.site_use_type = rleCode
9618: AND b.party_id = ptyId);