APPS.OKE_DTS_WORKFLOW dependencies on OKC_K_LINES_B

Line 58: select sts_code from okc_k_lines_b

54: l_sts_code varchar2(80);
55: l_value varchar2(1);
56:
57: cursor c(p_id Number) IS
58: select sts_code from okc_k_lines_b
59: where id = p_id;
60:
61: cursor opn_csr(p_sts_code varchar2) is
62: select 'x' from okc_assents

Line 111: , OKC_K_LINES_B S

107: FROM OKE_K_DELIVERABLES_VL D
108: , OKE_WORKFLOWS W
109: , OKC_K_HEADERS_B B
110: , OKE_K_HEADERS_FULL_V H
111: , OKC_K_LINES_B S
112: , OKE_SYSTEM_ITEMS_V I
113: WHERE D.DELIVERABLE_ID = P_DELIVERABLE_ID
114: AND W.SOURCE_CODE = 'DTS'
115: AND W.USAGE_CODE =

Line 1469: , okc_k_lines_b s

1465: , pa_tasks t
1466: , oke_system_items_v i
1467: , oke_k_headers h
1468: , okc_k_headers_b b
1469: , okc_k_lines_b s
1470: Where D.Deliverable_Id = P_Id
1471: And B.Id = D.K_Header_Id
1472: And H.K_Header_Id = B.Id
1473: And D.Project_Id = P.Project_Id(+)

Line 1675: , okc_k_lines_b s

1671: , pa_tasks t
1672: , oke_system_items_v i
1673: , oke_k_headers h
1674: , okc_k_headers_b b
1675: , okc_k_lines_b s
1676: Where D.Deliverable_Id = P_Id
1677: And B.Id = D.K_Header_Id
1678: And H.K_Header_Id = B.Id
1679: And D.Project_Id = P.Project_Id(+)

Line 1879: , okc_k_lines_b s

1875: , pa_tasks t
1876: , oke_system_items_v i
1877: , oke_k_headers h
1878: , okc_k_headers_b b
1879: , okc_k_lines_b s
1880: Where D.Deliverable_Id = P_Id
1881: And B.Id = D.K_Header_Id
1882: And H.K_Header_Id = B.Id
1883: And D.Project_Id = P.Project_Id(+)