APPS.OKL_QA_DATA_INTEGRITY dependencies on HZ_PARTY_SITE_USES

Line 4364: FROM hz_party_site_uses

4360: -- bug 6795295 changed name of cursor
4361: --CURSOR intall_location_csr (p_party_site_use_id NUMBER) IS
4362: CURSOR party_site_id_csr (p_party_site_use_id NUMBER) IS
4363: SELECT party_site_id
4364: FROM hz_party_site_uses
4365: WHERE party_site_use_id = p_party_site_use_id;
4366:
4367: -- bug 6795295 changed name of cursor
4368: -- CURSOR location_csr (p_party_site_id NUMBER) IS

Line 4416: l_party_site_id hz_party_site_uses.party_site_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;
4418: l_okl_location_name VARCHAR2(160);
4419: l_ib_location_name VARCHAR2(160);
4420: l_contract_start_date okc_k_headers_b.start_date%TYPE;

Line 9192: FROM HZ_PARTY_SITE_USES A,

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