APPS.OKL_CONTRACT_BOOK_PVT dependencies on OKC_STATUSES_B

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

1919:
1920: CURSOR l_svclne_csr (ltycode VARCHAR2, chrid okl_k_headers.khr_id%TYPE) IS
1921: SELECT cle.ID,
1922: cle.price_negotiated amount
1923: FROM okc_k_lines_b cle, okc_line_styles_b ls, okc_statuses_b sts
1924: WHERE cle.lse_id = ls.ID
1925: AND ls.lty_code = ltycode
1926: AND cle.dnz_chr_id = chrid
1927: AND sts.code = cle.sts_code

Line 3581: FROM okc_statuses_b okcsts

3577: AND kle.ID = cleb.ID
3578: AND kle.fee_type = 'ROLLOVER'
3579: AND NOT EXISTS (
3580: SELECT 'Y'
3581: FROM okc_statuses_b okcsts
3582: WHERE okcsts.code = cleb.sts_code
3583: AND okcsts.ste_code IN
3584: ('EXPIRED',
3585: 'HOLD',

Line 3609: FROM okc_statuses_b okcsts

3605: AND cleb.orig_system_id1 IS NULL
3606: --This means new Fee Line (top line)
3607: AND NOT EXISTS (
3608: SELECT 'Y'
3609: FROM okc_statuses_b okcsts
3610: WHERE okcsts.code = cleb.sts_code
3611: AND okcsts.ste_code IN
3612: ('EXPIRED',
3613: 'HOLD',

Line 3655: FROM okc_statuses_b okcsts

3651: AND kle.fee_type = 'ROLLOVER'
3652: AND TRUNC (khr.start_date) > SYSDATE
3653: AND NOT EXISTS (
3654: SELECT 'Y'
3655: FROM okc_statuses_b okcsts
3656: WHERE okcsts.code = cleb.sts_code
3657: AND okcsts.ste_code IN
3658: ('EXPIRED',
3659: 'HOLD',

Line 3680: FROM okc_statuses_b okcsts

3676: AND cleb.orig_system_id1 IS NULL
3677: --This means new Fee Line (top line)
3678: AND NOT EXISTS (
3679: SELECT 'Y'
3680: FROM okc_statuses_b okcsts
3681: WHERE okcsts.code = cleb.sts_code
3682: AND okcsts.ste_code IN
3683: ('EXPIRED',
3684: 'HOLD',