APPS.OKL_QA_DATA_INTEGRITY dependencies on HZ_PARTY_SITE_USES

Line 4751: FROM hz_party_site_uses

4747: -- bug 6795295 changed name of cursor
4748: --CURSOR intall_location_csr (p_party_site_use_id NUMBER) IS
4749: CURSOR party_site_id_csr (p_party_site_use_id NUMBER) IS
4750: SELECT party_site_id
4751: FROM hz_party_site_uses
4752: WHERE party_site_use_id = p_party_site_use_id;
4753:
4754: -- bug 6795295 changed name of cursor
4755: -- CURSOR location_csr (p_party_site_id NUMBER) IS

Line 4803: l_party_site_id hz_party_site_uses.party_site_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;
4805: l_okl_location_name VARCHAR2(160);
4806: l_ib_location_name VARCHAR2(160);
4807: l_contract_start_date okc_k_headers_b.start_date%TYPE;

Line 9613: FROM HZ_PARTY_SITE_USES A,

9609: SELECT 'Y' isThere
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