APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKC_LINE_STYLES_V

Line 3537: okc_line_styles_v style

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
3541: AND line.lse_id = style.id

Line 3553: okc_line_styles_v style

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
3557: AND line.orig_system_id1 IS NULL;

Line 4662: okc_line_styles_v style

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'
4666: AND orig_system_id1 IS NULL;

Line 4674: okc_line_styles_v style,

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
4678: AND style.lty_code = 'FREE_FORM2'