DBA Data[Home] [Help]

APPS.OKL_JTOT_EXTRACT dependencies on OKC_K_HEADERS_B

Line 672: from OKC_K_HEADERS_B

668: p_chr_id IN VARCHAR2,
669: x_rle_code_tbl OUT NOCOPY rle_code_tbl_type) is
670: Cursor chr_scs_curs is
671: select scs_code
672: from OKC_K_HEADERS_B
673: where id = p_chr_id;
674: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
675:
676: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 674: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;

670: Cursor chr_scs_curs is
671: select scs_code
672: from OKC_K_HEADERS_B
673: where id = p_chr_id;
674: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
675:
676: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
677: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_DEF_ROLES';
678: l_api_version CONSTANT NUMBER := 1.0;