APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_K_LINES_FULL_V

Line 3289: FROM okl_k_Lines_full_v line,

3285: ) IS
3286:
3287: CURSOR fee_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3288: SELECT line.*
3289: FROM okl_k_Lines_full_v line,
3290: okc_line_styles_v style
3291: WHERE line.sts_code = 'BOOKED'
3292: AND style.lty_code = 'FEE'
3293: AND line.dnz_chr_id = p_chr_id

Line 3305: FROM okl_k_Lines_full_v line,

3301: AND sts_code = 'BOOKED';
3302:
3303: CURSOR rbk_new_fee_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
3304: SELECT line.*
3305: FROM okl_k_Lines_full_v line,
3306: okc_line_styles_v style
3307: WHERE style.lty_code = 'FEE'
3308: AND line.dnz_chr_id = p_chr_id
3309: AND line.lse_id = style.id

Line 5539: FROM okl_k_lines_full_v

5535:
5536: -- Sync only Financial Asset and child lines
5537: CURSOR rebook_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5538: SELECT *
5539: FROM okl_k_lines_full_v
5540: WHERE dnz_chr_id = p_chr_id
5541: AND orig_system_id1 IS NOT NULL
5542: AND lse_id in (33,34,42,43,44,45,70)
5543: --Bug# 8766336

Line 5548: FROM okl_k_lines_full_v line,

5544: AND sts_code <> 'ABANDONED';
5545:
5546: CURSOR rebook_new_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5547: SELECT line.*
5548: FROM okl_k_lines_full_v line,
5549: okc_line_styles_v style
5550: WHERE line.dnz_chr_id = p_chr_id
5551: AND line.lse_id = style.id
5552: AND style.lty_code = 'FREE_FORM1'

Line 5562: FROM okl_k_lines_full_v line,

5558: CURSOR rebook_new_ib_line_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5559: SELECT line.*,
5560: parent_cle.orig_system_id1 parent_orig_system_id1,
5561: parent_cle.start_date parent_orig_start_date
5562: FROM okl_k_lines_full_v line,
5563: okc_line_styles_v style,
5564: okc_k_lines_b parent_cle
5565: WHERE line.dnz_chr_id = p_chr_id
5566: AND line.lse_id = style.id

Line 5671: FROM okl_k_lines_full_v line,

5667: CURSOR rebook_new_addon_line_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5668: SELECT line.*,
5669: parent_cle.orig_system_id1 parent_orig_system_id1,
5670: parent_cle.start_date parent_orig_start_date
5671: FROM okl_k_lines_full_v line,
5672: okc_line_styles_v style,
5673: okc_k_lines_b parent_cle
5674: WHERE line.dnz_chr_id = p_chr_id
5675: AND line.lse_id = style.id