DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PUB dependencies on OKC_K_LINES_B

Line 350: FROM OKC_K_LINES_B cle1,

346: CURSOR Cur_covtmpl_id(p_cle_id IN NUMBER) Is
347: SELECT oxs.Coverage_template_Id,
348: cle1.start_date,
349: cle1.end_date
350: FROM OKC_K_LINES_B cle1,
351: OKC_K_ITEMS cim ,
352: OKX_SYSTEM_ITEMS_V oxs
353: WHERE cle1.Lse_Id IN (1,19,14)
354: AND cim.cle_Id=cle1.Id

Line 481: FROM OKC_K_LINES_B

477: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Coverage';
478:
479: CURSOR Cur_cov_Id IS
480: SELECT id
481: FROM OKC_K_LINES_B
482: WHERE CLE_ID = P_service_Line_Id
483: AND LSE_ID in ( 2,15,20);
484:
485: BEGIN