APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_STATUSES_V

Line 825: FROM okc_statuses_v a, okc_k_headers_b b, okl_k_headers c

821: l_failstatus VARCHAR2 (256);
822:
823: CURSOR tmp_csr (chrid NUMBER) IS
824: SELECT NVL (b.template_yn, 'N') template_yn
825: FROM okc_statuses_v a, okc_k_headers_b b, okl_k_headers c
826: WHERE a.code = b.sts_code AND b.ID = c.ID AND b.ID = chrid;
827:
828: tmp_rec tmp_csr%ROWTYPE;
829:

Line 4517: FROM okc_k_headers_b chrb, okc_statuses_v stsv

4513: CURSOR l_chr_csr (p_chr_id IN NUMBER) IS
4514: SELECT chrb.qcl_id,
4515: stsv.ste_code,
4516: stsv.meaning
4517: FROM okc_k_headers_b chrb, okc_statuses_v stsv
4518: WHERE chrb.ID = p_chr_id
4519: AND chrb.sts_code = stsv.code
4520: AND chrb.scs_code = 'LEASE';
4521: