APPS.OKL_EVERGREEN_BILLING_PVT dependencies on OKC_STATUSES_B

Line 36: okc_statuses_b khs,

32: okch.contract_number,
33: nvl(stm.kle_id, -99) kle_id
34: FROM okl_k_headers oklh,
35: okc_k_headers_b okch,
36: okc_statuses_b khs,
37: okl_streams stm
38: WHERE oklh.id = okch.id
39: AND okch.contract_number = NVL (p_contract_number, okch.contract_number)
40: AND okch.scs_code IN ('LEASE', 'LOAN')

Line 68: okc_statuses_b khs,

64: okch.contract_number,
65: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bkrpcy_sts
66: FROM okl_k_headers oklh,
67: okc_k_headers_b okch,
68: okc_statuses_b khs,
69: okl_streams stm,
70: hz_cust_accounts hca
71: WHERE oklh.id = okch.id
72: AND okch.contract_number = NVL (p_contract_number, okch.contract_number)

Line 1654: OKC_STATUSES_B sts

1650: ls.lty_code,
1651: kle.sts_code
1652: FROM OKL_K_LINES_FULL_V kle,
1653: OKC_LINE_STYLES_B ls,
1654: OKC_STATUSES_B sts
1655: WHERE kle.lse_id = ls.id
1656: AND ls.lty_code = 'FREE_FORM1'
1657: AND kle.dnz_chr_id = p_chr_id
1658: AND sts.code = kle.sts_code

Line 1667: OKC_STATUSES_B sts

1663: kle.id,
1664: kle.fee_type
1665: FROM OKL_K_LINES_FULL_V kle,
1666: OKC_LINE_STYLES_B ls,
1667: OKC_STATUSES_B sts
1668: WHERE kle.lse_id = ls.id
1669: AND ls.lty_code = 'FEE'
1670: AND kle.dnz_chr_id = p_chr_id
1671: AND sts.code = kle.sts_code