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 278: , okc_k_lines_b s

274: , pa_tasks t
275: , oke_system_items_v i
276: , oke_k_headers h
277: , okc_k_headers_b b
278: , okc_k_lines_b s
279: Where D.K_Line_Id = P_Id
280: And B.Id = D.K_Header_Id
281: And H.K_Header_Id = B.Id
282: And D.Project_Id = P.Project_Id(+)

Line 332: , okc_k_lines_b s

328: , pa_tasks t
329: , oke_system_items_v i
330: , oke_k_headers h
331: , okc_k_headers_b b
332: , okc_k_lines_b s
333: Where D.Deliverable_Id = P_Id
334: And B.Id = D.K_Header_Id
335: And H.K_Header_Id = B.Id
336: And D.Project_Id = P.Project_Id(+)

Line 378: , okc_k_lines_b s

374: , pa_tasks t
375: , oke_system_items_v i
376: , oke_k_headers h
377: , okc_k_headers_b b
378: , okc_k_lines_b s
379: Where D.K_Header_Id = P_Id
380: And B.Id = D.K_Header_Id
381: And H.K_Header_Id = B.Id
382: And D.Project_Id = P.Project_Id(+)

Line 429: , okc_k_lines_b s

425: , pa_tasks t
426: , oke_system_items_v i
427: , oke_k_headers h
428: , okc_k_headers_b b
429: , okc_k_lines_b s
430: Where D.K_Line_Id = P_Id
431: And B.Id = D.K_Header_Id
432: And H.K_Header_Id = B.Id
433: And D.Project_Id = P.Project_Id(+)

Line 480: , okc_k_lines_b s

476: , pa_tasks t
477: , oke_system_items_v i
478: , oke_k_headers h
479: , okc_k_headers_b b
480: , okc_k_lines_b s
481: Where D.Deliverable_Id = P_Id
482: And B.Id = D.K_Header_Id
483: And H.K_Header_Id = B.Id
484: And D.Project_Id = P.Project_Id(+)

Line 526: , okc_k_lines_b s

522: , pa_tasks t
523: , oke_system_items_v i
524: , oke_k_headers h
525: , okc_k_headers_b b
526: , okc_k_lines_b s
527: Where D.K_Header_Id = P_Id
528: And B.Id = D.K_Header_Id
529: And H.K_Header_Id = B.Id
530: And D.Project_Id = P.Project_Id(+)

Line 573: , okc_k_lines_b s

569: , pa_tasks t
570: , oke_system_items_v i
571: , oke_k_headers h
572: , okc_k_headers_b b
573: , okc_k_lines_b s
574: Where D.K_Line_Id = P_Id
575: And B.Id = D.K_Header_Id
576: And H.K_Header_Id = B.Id
577: And D.Project_Id = P.Project_Id(+)

Line 620: , okc_k_lines_b s

616: , pa_tasks t
617: , oke_system_items_v i
618: , oke_k_headers h
619: , okc_k_headers_b b
620: , okc_k_lines_b s
621: Where D.Deliverable_Id = P_Id
622: And B.Id = D.K_Header_Id
623: And H.K_Header_Id = B.Id
624: And D.Project_Id = P.Project_Id(+)

Line 638: From okc_k_lines_b

634: Where Organization_Id = P_Id;
635:
636: Cursor Line_C(P_Id Number) Is
637: Select Line_Number
638: From okc_k_lines_b
639: Where Id = P_Id;
640:
641:
642: Begin