APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_STATUSES_B

Line 1619: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts

1615:
1616: CURSOR l_svclne_csr (ltycode VARCHAR2, chrid okl_k_headers.khr_id%TYPE) IS
1617: SELECT cle.ID,
1618: cle.price_negotiated amount
1619: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts
1620: WHERE cle.lse_id = ls.ID
1621: AND ls.lty_code = ltycode
1622: AND cle.dnz_chr_id = chrid
1623: AND sts.code = cle.sts_code

Line 3278: FROM okc_statuses_b okcsts

3274: AND kle.ID = cleb.ID
3275: AND kle.fee_type = 'ROLLOVER'
3276: AND NOT EXISTS (
3277: SELECT 'Y'
3278: FROM okc_statuses_b okcsts
3279: WHERE okcsts.code = cleb.sts_code
3280: AND okcsts.ste_code IN
3281: ('EXPIRED',
3282: 'HOLD',

Line 3306: FROM okc_statuses_b okcsts

3302: AND cleb.orig_system_id1 IS NULL
3303: --This means new Fee Line (top line)
3304: AND NOT EXISTS (
3305: SELECT 'Y'
3306: FROM okc_statuses_b okcsts
3307: WHERE okcsts.code = cleb.sts_code
3308: AND okcsts.ste_code IN
3309: ('EXPIRED',
3310: 'HOLD',

Line 3352: FROM okc_statuses_b okcsts

3348: AND kle.fee_type = 'ROLLOVER'
3349: AND TRUNC (khr.start_date) > SYSDATE
3350: AND NOT EXISTS (
3351: SELECT 'Y'
3352: FROM okc_statuses_b okcsts
3353: WHERE okcsts.code = cleb.sts_code
3354: AND okcsts.ste_code IN
3355: ('EXPIRED',
3356: 'HOLD',

Line 3377: FROM okc_statuses_b okcsts

3373: AND cleb.orig_system_id1 IS NULL
3374: --This means new Fee Line (top line)
3375: AND NOT EXISTS (
3376: SELECT 'Y'
3377: FROM okc_statuses_b okcsts
3378: WHERE okcsts.code = cleb.sts_code
3379: AND okcsts.ste_code IN
3380: ('EXPIRED',
3381: 'HOLD',