APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on IEX_BANKRUPTCIES
Line 37: FROM iex_bankruptcies ban
33: WHERE id = p_chr_id;
34:
35: Cursor bankrupt_csr(p_contract_id NUMBER) IS
36: SELECT DECODE(disposition_code, 'NEGOTIATION', 'Y', 'GRANTED', 'Y', NULL, 'Y', 'N') bankruptcy_status 37: FROM iex_bankruptcies ban 38: WHERE EXISTS (SELECT 1 FROM okc_k_party_roles_b rle
39: WHERE rle.dnz_chr_id = p_contract_id
40: AND rle.rle_code = 'LESSEE'
41: AND TO_NUMBER(rle.object1_id1) = ban.party_id);