APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_STRM_TYPE_B

Line 7057: okl_strm_type_b sty,

7053: orig_stm.id orig_stm_id,
7054: orig_stm.sty_id,
7055: orig_stm.kle_id
7056: FROM okl_streams new_stm,
7057: okl_strm_type_b sty,
7058: okl_streams orig_stm,
7059: okl_party_payment_hdr pph
7060: WHERE new_stm.khr_id = p_khr_id
7061: AND new_stm.say_code = 'CURR'

Line 7098: okl_strm_type_b sty,

7094: orig_stm.sty_id,
7095: orig_stm.kle_id,
7096: cle.lse_id
7097: FROM okl_streams orig_stm,
7098: okl_strm_type_b sty,
7099: okc_k_lines_b cle,
7100: okl_party_payment_hdr pph
7101: WHERE orig_stm.khr_id = p_orig_khr_id
7102: AND orig_stm.say_code = 'CURR'

Line 7414: okl_strm_type_b sty,

7410: orig_stm.id orig_stm_id,
7411: orig_stm.sty_id,
7412: orig_stm.kle_id
7413: FROM okl_streams new_stm,
7414: okl_strm_type_b sty,
7415: okl_streams orig_stm
7416: WHERE new_stm.khr_id = p_khr_id
7417: AND new_stm.say_code = 'CURR'
7418: AND new_stm.sty_id = sty.id

Line 7450: okl_strm_type_b sty,

7446: orig_stm.sty_id,
7447: orig_stm.kle_id,
7448: cle.lse_id
7449: FROM okl_streams orig_stm,
7450: okl_strm_type_b sty,
7451: okc_k_lines_b cle
7452: WHERE orig_stm.khr_id = p_orig_khr_id
7453: AND orig_stm.say_code = 'CURR'
7454: AND orig_stm.sty_id = sty.id

Line 8570: okl_strm_type_b sty,

8566: new_stm.id new_stm_id,
8567: orig_stm.id orig_stm_id
8568: FROM okl_pools pol,
8569: okl_pool_contents pcn,
8570: okl_strm_type_b sty,
8571: okl_streams new_stm,
8572: okl_streams orig_stm
8573: WHERE pcn.sty_id = sty.id
8574: AND pcn.pol_id = pol.id

Line 8644: okl_strm_type_b sty

8640: p_kle_id NUMBER)
8641: IS
8642: SELECT stm.id stm_id
8643: FROM okl_streams stm,
8644: okl_strm_type_b sty
8645: WHERE stm.khr_id = p_chr_id
8646: AND stm.kle_id = p_kle_id
8647: AND stm.sty_id = sty.id
8648: AND stm.say_code = 'CURR'

Line 8672: l_disb_adj_sty_id OKL_STRM_TYPE_B.id%TYPE;

8668: AND sel.date_billed IS NULL;
8669:
8670: l_undisb_adj_exists VARCHAR2(30);
8671:
8672: l_disb_adj_sty_id OKL_STRM_TYPE_B.id%TYPE;
8673: l_inv_agreement_id OKC_K_HEADERS_B.id%TYPE;
8674:
8675: BEGIN
8676: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 9063: okl_strm_type_b sty

9059: CURSOR curr_streams_csr(p_khr_id IN NUMBER) IS
9060: SELECT new_stm.id new_stm_id,
9061: new_stm.kle_id
9062: FROM okl_streams new_stm,
9063: okl_strm_type_b sty
9064: WHERE new_stm.khr_id = p_khr_id
9065: AND new_stm.say_code = 'WORK'
9066: AND new_stm.sty_id = sty.id
9067: AND sty.stream_type_purpose IN