APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 334: WHERE EXISTS (SELECT 1 FROM okc_k_party_roles_b rle

330:
331: Cursor bankrupt_csr(p_contract_id NUMBER) IS
332: SELECT DECODE(disposition_code, 'NEGOTIATION', 'Y', 'GRANTED', 'Y', NULL, 'Y', 'N') bankruptcy_status
333: FROM iex_bankruptcies ban
334: WHERE EXISTS (SELECT 1 FROM okc_k_party_roles_b rle
335: WHERE rle.dnz_chr_id = p_contract_id
336: AND rle.rle_code = 'LESSEE'
337: AND TO_NUMBER(rle.object1_id1) = ban.party_id);
338: