APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_K_LINES

Line 3184: okl_k_lines okl

3180:
3181: CURSOR pth_csr (p_chr_id NUMBER) IS
3182: SELECT okc.id, okc.orig_system_id1, okc.lse_id
3183: FROM okc_k_lines_b okc,
3184: okl_k_lines okl
3185: WHERE dnz_chr_id = p_chr_id
3186: AND lse_id = 52 -- FEE top line
3187: AND okl.fee_type = 'PASSTHROUGH'
3188: AND okc.id = okl.id

Line 3536: FROM okl_k_Lines_full_v line,

3532: ) IS
3533:
3534: CURSOR fee_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3535: SELECT line.*
3536: FROM okl_k_Lines_full_v line,
3537: okc_line_styles_v style
3538: WHERE line.sts_code = 'BOOKED'
3539: AND style.lty_code = 'FEE'
3540: AND line.dnz_chr_id = p_chr_id

Line 3552: FROM okl_k_Lines_full_v line,

3548: AND sts_code = 'BOOKED';
3549:
3550: CURSOR rbk_new_fee_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3551: SELECT line.*
3552: FROM okl_k_Lines_full_v line,
3553: okc_line_styles_v style
3554: WHERE style.lty_code = 'FEE'
3555: AND line.dnz_chr_id = p_chr_id
3556: AND line.lse_id = style.id

Line 3660: ,okl_k_lines okl

3656: ,okl.attribute13
3657: ,okl.attribute14
3658: ,okl.attribute15
3659: FROM okc_k_lines_b okc
3660: ,okl_k_lines okl
3661: ,okc_k_items item
3662: ,okc_line_styles_b style
3663: --,okc_k_party_roles_b partyb -- change added for Rebook Change Control Enhancement
3664: WHERE okc.id = okl.id

Line 3717: okl_k_lines okl,

3713: okl.attribute13,
3714: okl.attribute14,
3715: okl.attribute15
3716: FROM okc_k_lines_b okc,
3717: okl_k_lines okl,
3718: okc_k_items item,
3719: okc_line_styles_b style
3720: --okc_k_party_roles_b partyb
3721: WHERE okc.id = okl.id

Line 3779: okl_k_lines okl,

3775: SELECT okc_cov_ast.orig_system_id1, okc_cov_ast.id line_id, okc_fin.name, SUBSTR(okc_fin.item_description,1,200) item_description,
3776: okl.capital_amount, okl.amount,
3777: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
3778: FROM okc_k_lines_b okc_cov_ast,
3779: okl_k_lines okl,
3780: okc_line_styles_b style,
3781: okc_k_items item,
3782: okc_k_lines_v okc_fin
3783: WHERE okc_cov_ast.cle_id = p_top_line_id

Line 3802: okl_k_lines okl,

3798: SELECT okc.orig_system_id1, okc.id line_id, okc.name, okc.item_description,
3799: okl.capital_amount,
3800: item.id item_id, item.object1_id1, item.object1_id2, item.jtot_object1_code
3801: FROM okc_k_lines_v okc,
3802: okl_k_lines okl,
3803: okc_line_styles_b style,
3804: okc_k_items item
3805: WHERE okc.id = p_sub_line_id
3806: AND okc.dnz_chr_id = p_chr_id

Line 3881: okl_k_lines okl,

3877: okl.attribute13,
3878: okl.attribute14,
3879: okl.attribute15
3880: FROM okc_k_lines_b okc,
3881: okl_k_lines okl,
3882: okc_line_styles_b style
3883: WHERE okc.id = okl.id
3884: AND okc.dnz_chr_id = p_rbk_chr_id
3885: AND okc.lse_id = style.id

Line 4655: FROM okl_k_lines_full_v

4651: sync_failed EXCEPTION;
4652:
4653: CURSOR rebook_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4654: SELECT *
4655: FROM okl_k_lines_full_v
4656: WHERE dnz_chr_id = p_chr_id
4657: AND orig_system_id1 IS NOT NULL;
4658:
4659: CURSOR rebook_new_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 4661: FROM okl_k_lines_full_v line,

4657: AND orig_system_id1 IS NOT NULL;
4658:
4659: CURSOR rebook_new_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4660: SELECT line.*
4661: FROM okl_k_lines_full_v line,
4662: okc_line_styles_v style
4663: WHERE line.dnz_chr_id = p_chr_id
4664: AND line.lse_id = style.id
4665: AND style.lty_code = 'FREE_FORM1'

Line 4673: FROM okl_k_lines_full_v line,

4669: CURSOR rebook_new_ib_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4670: SELECT line.*,
4671: parent_cle.orig_system_id1 parent_orig_system_id1,
4672: parent_cle.start_date parent_orig_start_date
4673: FROM okl_k_lines_full_v line,
4674: okc_line_styles_v style,
4675: okc_k_lines_b parent_cle
4676: WHERE line.dnz_chr_id = p_chr_id
4677: AND line.lse_id = style.id