APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_LINE_STYLES_B

Line 1100: FROM okc_line_styles_b lse,

1096: --cursor to fetch line style of sub line and parent line id.
1097: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
1098: SELECT lse.lty_code lty_code,
1099: lines.id fee_line_id
1100: FROM okc_line_styles_b lse,
1101: okc_k_lines_b subline,
1102: okc_k_lines_b lines
1103: WHERE subline.id = p_line_id
1104: AND lines.id = subline.cle_id

Line 1107: l_lty_code okc_line_styles_b.lty_code%TYPE;

1103: WHERE subline.id = p_line_id
1104: AND lines.id = subline.cle_id
1105: AND lse.id = subline.lse_id;
1106:
1107: l_lty_code okc_line_styles_b.lty_code%TYPE;
1108: l_parent_line_id okc_k_lines_b.id%TYPE;
1109: l_parameter_list wf_parameter_list_t;
1110: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
1111: l_business_event_name WF_EVENTS.NAME%TYPE := NULL;

Line 4424: okc_line_styles_b style

4420:
4421: CURSOR get_line_style (p_line_id okc_k_lines_b.id%TYPE) IS
4422: SELECT lty_code
4423: FROM okc_k_lines_b line,
4424: okc_line_styles_b style
4425: WHERE line.lse_id = style.id
4426: AND line.id = p_line_id;
4427:
4428: l_line_style okc_line_styles_b.lty_code%TYPE;

Line 4428: l_line_style okc_line_styles_b.lty_code%TYPE;

4424: okc_line_styles_b style
4425: WHERE line.lse_id = style.id
4426: AND line.id = p_line_id;
4427:
4428: l_line_style okc_line_styles_b.lty_code%TYPE;
4429:
4430: CURSOR get_serv_chr_from_serv(p_chr_id okc_k_headers_b.id%TYPE,
4431: p_line_id okc_k_lines_b.id%TYPE) IS
4432: SELECT rlobj.object1_id1