APPS.OKL_STREAM_BILLING_PVT dependencies on IEX_BANKRUPTCIES

Line 399: FROM iex_bankruptcies ban

395:
396: CURSOR l_bankrupt_csr(cp_khr_id NUMBER) IS
397: SELECT DECODE(disposition_code, 'NEGOTIATION', 'Y', 'GRANTED', 'Y', NULL, 'Y', 'N') bankruptcy_status
398: , disposition_code
399: FROM iex_bankruptcies ban
400: WHERE EXISTS (SELECT 1 FROM okc_k_party_roles_b rle
401: WHERE rle.dnz_chr_id = cp_khr_id
402: AND rle.rle_code = 'LESSEE'
403: AND TO_NUMBER(rle.object1_id1) = ban.party_id);

Line 1470: l_disposition_code iex_bankruptcies.disposition_code%TYPE;

1466: C.avl_id = A.id;
1467:
1468: --added variables for bankruptcy hold
1469: l_turnoff_inv_on_bankruptcy VARCHAR2(1) := 'N';
1470: l_disposition_code iex_bankruptcies.disposition_code%TYPE;
1471: l_bankruptcy_flag VARCHAR2(1) := 'N';
1472: l_previous_khr OKL_K_HEADERS.khr_id%TYPE;
1473:
1474: -- -------------------------------------------