APPS.OKC_LSS_PVT dependencies on OKC_LINE_STYLES_B

Line 493: FROM OKC_LINE_STYLES_B

489: l_excp_halt_validation EXCEPTION;
490: l_row_notfound BOOLEAN := TRUE;
491: CURSOR lse_pk_csr (p_lse_id IN number) IS
492: SELECT lty_code
493: FROM OKC_LINE_STYLES_B
494: WHERE id = p_lse_id;
495: l_lse_pk lse_pk_csr%ROWTYPE;
496: BEGIN
497: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 594: Select item_to_price_yn into l_item_to_price_yn from OKC_LINE_STYLES_B

590: OBJECT_CODE = p_lssv_rec.JTOT_OBJECT_CODE
591: AND OBJECT_USER_CODE = 'OKX_MTL_SYSTEM_ITEM';
592:
593: BEGIN
594: Select item_to_price_yn into l_item_to_price_yn from OKC_LINE_STYLES_B
595: where id = p_lssv_rec.lse_id;
596: IF sysdate between p_lssv_rec.START_DATE and nvl( p_lssv_rec.END_DATE,sysdate) THEN
597: IF l_item_to_price_yn = 'Y'
598: THEN