APPS.OKL_LA_STREAM_PVT dependencies on OKC_K_LINES_B

Line 414: okc_k_lines_b cle_ib

410: hz_party_sites hps,
411: hz_party_site_uses hpsu,
412: okl_txl_itm_insts iti,
413: okc_line_styles_b lse_ib,
414: okc_k_lines_b cle_ib
415: WHERE cle_ib.dnz_chr_id = chrId
416: AND cle_ib.lse_id = lse_ib.id
417: AND lse_ib.lty_code = 'INST_ITEM'
418: AND iti.kle_id = cle_ib.id

Line 482: (SELECT /*+ index(KLE OKC_K_LINES_B_U1 )*/ KLE.ID

478: AND NVL(STR.PURPOSE_CODE,'ORIGIN') = pp
479: AND STR.KHR_ID = chrId
480: AND (
481: STR.KLE_ID IN
482: (SELECT /*+ index(KLE OKC_K_LINES_B_U1 )*/ KLE.ID
483: FROM OKC_K_LINES_B KLE,
484: OKC_LINE_STYLES_B LSE,
485: OKC_STATUSES_B STS
486: WHERE KLE.LSE_ID = LSE.ID

Line 483: FROM OKC_K_LINES_B KLE,

479: AND STR.KHR_ID = chrId
480: AND (
481: STR.KLE_ID IN
482: (SELECT /*+ index(KLE OKC_K_LINES_B_U1 )*/ KLE.ID
483: FROM OKC_K_LINES_B KLE,
484: OKC_LINE_STYLES_B LSE,
485: OKC_STATUSES_B STS
486: WHERE KLE.LSE_ID = LSE.ID
487: AND KLE.DNZ_CHR_ID = chrId

Line 661: p_cle_id IN OKC_K_LINES_B.ID%TYPE,

657: PROCEDURE extract_params_so(
658: p_api_version IN NUMBER,
659: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
660: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
661: p_cle_id IN OKC_K_LINES_B.ID%TYPE,
662: x_return_status OUT NOCOPY VARCHAR2,
663: x_msg_count OUT NOCOPY NUMBER,
664: x_msg_data OUT NOCOPY VARCHAR2,
665: x_csm_lease_header OUT NOCOPY okl_create_streams_pub.csm_lease_rec_type,