APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_LINE_STYLES_B

Line 1153: FROM okc_line_styles_b lse,

1149: --cursor to fetch line style of sub line and parent line id.
1150: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
1151: SELECT lse.lty_code lty_code,
1152: lines.id fee_line_id
1153: FROM okc_line_styles_b lse,
1154: okc_k_lines_b subline,
1155: okc_k_lines_b lines
1156: WHERE subline.id = p_line_id
1157: AND lines.id = subline.cle_id

Line 1160: l_lty_code okc_line_styles_b.lty_code%TYPE;

1156: WHERE subline.id = p_line_id
1157: AND lines.id = subline.cle_id
1158: AND lse.id = subline.lse_id;
1159:
1160: l_lty_code okc_line_styles_b.lty_code%TYPE;
1161: l_parent_line_id okc_k_lines_b.id%TYPE;
1162: l_parameter_list wf_parameter_list_t;
1163: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
1164: l_business_event_name WF_EVENTS.NAME%TYPE := NULL;

Line 4477: okc_line_styles_b style

4473:
4474: CURSOR get_line_style (p_line_id okc_k_lines_b.id%TYPE) IS
4475: SELECT lty_code
4476: FROM okc_k_lines_b line,
4477: okc_line_styles_b style
4478: WHERE line.lse_id = style.id
4479: AND line.id = p_line_id;
4480:
4481: l_line_style okc_line_styles_b.lty_code%TYPE;

Line 4481: l_line_style okc_line_styles_b.lty_code%TYPE;

4477: okc_line_styles_b style
4478: WHERE line.lse_id = style.id
4479: AND line.id = p_line_id;
4480:
4481: l_line_style okc_line_styles_b.lty_code%TYPE;
4482:
4483: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,
4484: p_line_id okc_k_lines_b.id%TYPE) IS
4485: SELECT rlobj.object1_id1