APPS.OKE_DTS_ACTION_PKG dependencies on OKC_K_LINES_B

Line 224: , okc_k_lines_b s

220: , pa_tasks t
221: , oke_system_items_v i
222: , oke_k_headers h
223: , okc_k_headers_b b
224: , okc_k_lines_b s
225: Where D.K_Header_Id = P_Id
226: And B.Id = D.K_Header_Id
227: And H.K_Header_Id = B.Id
228: And D.Project_Id = P.Project_Id(+)

Line 270: , okc_k_lines_b s

266: , pa_tasks t
267: , oke_system_items_v i
268: , oke_k_headers h
269: , okc_k_headers_b b
270: , okc_k_lines_b s
271: Where D.K_Line_Id = P_Id
272: And B.Id = D.K_Header_Id
273: And H.K_Header_Id = B.Id
274: And D.Project_Id = P.Project_Id(+)

Line 316: , okc_k_lines_b s

312: , pa_tasks t
313: , oke_system_items_v i
314: , oke_k_headers h
315: , okc_k_headers_b b
316: , okc_k_lines_b s
317: Where D.Deliverable_Id = P_Id
318: And B.Id = D.K_Header_Id
319: And H.K_Header_Id = B.Id
320: And D.Project_Id = P.Project_Id(+)

Line 362: , okc_k_lines_b s

358: , pa_tasks t
359: , oke_system_items_v i
360: , oke_k_headers h
361: , okc_k_headers_b b
362: , okc_k_lines_b s
363: Where D.K_Header_Id = P_Id
364: And B.Id = D.K_Header_Id
365: And H.K_Header_Id = B.Id
366: And D.Project_Id = P.Project_Id(+)

Line 413: , okc_k_lines_b s

409: , pa_tasks t
410: , oke_system_items_v i
411: , oke_k_headers h
412: , okc_k_headers_b b
413: , okc_k_lines_b s
414: Where D.K_Line_Id = P_Id
415: And B.Id = D.K_Header_Id
416: And H.K_Header_Id = B.Id
417: And D.Project_Id = P.Project_Id(+)

Line 464: , okc_k_lines_b s

460: , pa_tasks t
461: , oke_system_items_v i
462: , oke_k_headers h
463: , okc_k_headers_b b
464: , okc_k_lines_b s
465: Where D.Deliverable_Id = P_Id
466: And B.Id = D.K_Header_Id
467: And H.K_Header_Id = B.Id
468: And D.Project_Id = P.Project_Id(+)

Line 510: , okc_k_lines_b s

506: , pa_tasks t
507: , oke_system_items_v i
508: , oke_k_headers h
509: , okc_k_headers_b b
510: , okc_k_lines_b s
511: Where D.K_Header_Id = P_Id
512: And B.Id = D.K_Header_Id
513: And H.K_Header_Id = B.Id
514: And D.Project_Id = P.Project_Id(+)

Line 557: , okc_k_lines_b s

553: , pa_tasks t
554: , oke_system_items_v i
555: , oke_k_headers h
556: , okc_k_headers_b b
557: , okc_k_lines_b s
558: Where D.K_Line_Id = P_Id
559: And B.Id = D.K_Header_Id
560: And H.K_Header_Id = B.Id
561: And D.Project_Id = P.Project_Id(+)

Line 604: , okc_k_lines_b s

600: , pa_tasks t
601: , oke_system_items_v i
602: , oke_k_headers h
603: , okc_k_headers_b b
604: , okc_k_lines_b s
605: Where D.Deliverable_Id = P_Id
606: And B.Id = D.K_Header_Id
607: And H.K_Header_Id = B.Id
608: And D.Project_Id = P.Project_Id(+)

Line 622: From okc_k_lines_b

618: Where Organization_Id = P_Id;
619:
620: Cursor Line_C(P_Id Number) Is
621: Select Line_Number
622: From okc_k_lines_b
623: Where Id = P_Id;
624:
625:
626: Begin