APPS.OKC_TIME_RES_PVT dependencies on OKC_K_LINES_B

Line 23: from okc_k_lines_b

19: where id = p_chr_id;
20:
21: CURSOR cle_csr(p_cle_id IN NUMBER) is
22: select start_date, end_date
23: from okc_k_lines_b
24: where id = p_cle_id;
25:
26: l_row_not_found BOOLEAN := TRUE;
27: l_chr_rec chr_csr%ROWTYPE;

Line 1320: SELECT resolved_until from okc_k_headers_b h, okc_k_lines_b l

1316: where ise.id = p_tve_id;
1317:
1318:
1319: CURSOR resolved_until_csr(p_cle_id IN NUMBER) is
1320: SELECT resolved_until from okc_k_headers_b h, okc_k_lines_b l
1321: where h.id = l.chr_id
1322: and l.id = p_cle_id;
1323:
1324: l_list_of_rules VARCHAR2(4000);