APPS.OKS_QA_DATA_INTEGRITY dependencies on HZ_PARTY_SITES

Line 2882: hz_party_sites c

2878: a.cust_account_id,
2879: a.org_id
2880: FROM hz_cust_acct_sites_all a,
2881: hz_cust_site_uses_all b,
2882: hz_party_sites c
2883: WHERE a.cust_acct_site_id = b.cust_acct_site_id
2884: AND c.party_site_id = a.party_site_id
2885: AND b.site_use_id = p_site_use_id;
2886:

Line 3697: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,

3693: IS
3694: SELECT prt.party_name
3695: FROM oe_hold_sources_all ohs,
3696: HZ_PARTIES prt,
3697: HZ_PARTY_SITES PS, HZ_CUST_ACCT_SITES_ALL CA, HZ_CUST_SITE_USES_ALL CS,
3698: okc_k_headers_all_b rl
3699: WHERE ohs.hold_entity_code = 'C'
3700: AND ohs.released_flag = 'N'
3701: AND ohs.org_id = okc_context.get_okc_org_id

Line 4308: FROM HZ_PARTY_SITES -- okx_party_sites_v

4304: -- Changed this cursor because object1_id1 will be holding the party_site_id
4305: -- not the customer site use id.
4306: CURSOR l_covsit_csr(partySiteId NUMBER) IS
4307: SELECT status
4308: FROM HZ_PARTY_SITES -- okx_party_sites_v
4309: WHERE party_site_id = partySiteId;
4310:
4311: --Changed cursor because ste_code does not have QA_HOLD
4312: CURSOR l_hdr_csr(l_chr_id NUMBER) IS