APPS.OKL_UBB_INTEGRATION_PVT dependencies on OKC_LINE_STYLES_V

Line 91: AND ib_line.lse_id = (select id from okc_line_styles_v where lty_code = 'INST_ITEM')

87: okl_k_lines_full_v inst_line,
88: okl_k_lines_full_v top_line
89: WHERE ib_line.cle_id = inst_line.id
90: AND inst_line.cle_id = top_line.id
91: AND ib_line.lse_id = (select id from okc_line_styles_v where lty_code = 'INST_ITEM')
92: AND inst_line.lse_id = (select id from okc_line_styles_v where lty_code = 'FREE_FORM2')
93: AND top_line.lse_id = (select id from okc_line_styles_v where lty_code = 'FREE_FORM1')
94: AND top_line.id = p_top_line_id
95: AND top_line.dnz_chr_id = p_chr_id;

Line 92: AND inst_line.lse_id = (select id from okc_line_styles_v where lty_code = 'FREE_FORM2')

88: okl_k_lines_full_v top_line
89: WHERE ib_line.cle_id = inst_line.id
90: AND inst_line.cle_id = top_line.id
91: AND ib_line.lse_id = (select id from okc_line_styles_v where lty_code = 'INST_ITEM')
92: AND inst_line.lse_id = (select id from okc_line_styles_v where lty_code = 'FREE_FORM2')
93: AND top_line.lse_id = (select id from okc_line_styles_v where lty_code = 'FREE_FORM1')
94: AND top_line.id = p_top_line_id
95: AND top_line.dnz_chr_id = p_chr_id;
96:

Line 93: AND top_line.lse_id = (select id from okc_line_styles_v where lty_code = 'FREE_FORM1')

89: WHERE ib_line.cle_id = inst_line.id
90: AND inst_line.cle_id = top_line.id
91: AND ib_line.lse_id = (select id from okc_line_styles_v where lty_code = 'INST_ITEM')
92: AND inst_line.lse_id = (select id from okc_line_styles_v where lty_code = 'FREE_FORM2')
93: AND top_line.lse_id = (select id from okc_line_styles_v where lty_code = 'FREE_FORM1')
94: AND top_line.id = p_top_line_id
95: AND top_line.dnz_chr_id = p_chr_id;
96:
97: CURSOR counter_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,