APPS.OKL_MASS_REBOOK_PVT dependencies on OKC_LINE_STYLES_V

Line 397: l_query := l_query || ' AND LINE.LSE_ID = (SELECT ID FROM OKC_LINE_STYLES_V ';

393: --------
394:
395: l_query := l_query || ' AND CON.ID = LINE.DNZ_CHR_ID ';
396: l_query := l_query || ' AND LINE.STS_CODE = '||''''||'BOOKED'||'''';
397: l_query := l_query || ' AND LINE.LSE_ID = (SELECT ID FROM OKC_LINE_STYLES_V ';
398: l_query := l_query || ' WHERE LTY_CODE = '||''''||'FIXED_ASSET'||''''||')';
399:
400: --
401: -- Add authoring org restriction

Line 1407: okc_line_styles_v style

1403: CURSOR fa_line_csr (p_chr_id OKL_K_HEADERS_V.ID%TYPE,
1404: p_kle_id OKC_K_LINES_V.ID%TYPE) IS
1405: SELECT line.id
1406: FROM okc_k_lines_v line,
1407: okc_line_styles_v style
1408: WHERE line.lse_id = style.id
1409: AND style.lty_code = 'FIXED_ASSET'
1410: AND dnz_chr_id = p_chr_id
1411: AND cle_id = p_kle_id;