APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_K_LINES_FULL_V

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 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