APPS.OKC_AST_PVT dependencies on OKC_K_LINES_B

Line 2561: from okc_k_lines_b L,

2557: l_return_status Varchar2(1);
2558: l_lse_id okc_k_lines_v.lse_id%TYPE;
2559: cursor c1(p_allowed_yn okc_assents_v.allowed_yn%TYPE) is
2560: select 'x'
2561: from okc_k_lines_b L,
2562: --NPALEPU for Bug # 4597099 on 13-AUG-2005
2563: /* okc_k_headers_b K, */
2564: OKC_K_HEADERS_ALL_B K,
2565: --END NPALEPU

Line 2575: from okc_k_lines_b

2571: and A.OPN_CODE = p_opn_code
2572: and A.ALLOWED_YN = p_allowed_yn;
2573: cursor c2 is
2574: select lse_id
2575: from okc_k_lines_b
2576: where id = p_line_id
2577: and chr_id is not null;
2578: cursor c3 is
2579: select a.lse_id

Line 2580: from okc_k_lines_b a,

2576: where id = p_line_id
2577: and chr_id is not null;
2578: cursor c3 is
2579: select a.lse_id
2580: from okc_k_lines_b a,
2581: okc_ancestrys b
2582: where b.cle_id = p_line_id
2583: and b.level_sequence = 1
2584: and a.id = b.cle_id_ascendant;