DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PVT dependencies on OKL_K_HEADERS_V

Line 3547: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE := null;

3543: ln_dummy NUMBER := 0;
3544: ln1_dummy NUMBER := 0;
3545: ln2_dummy NUMBER := 0;
3546: ln3_dummy NUMBER := p_units;
3547: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE := null;
3548: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
3549: --Bug# 4419339
3550: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
3551: CURSOR get_deal_type(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)

Line 3557: FROM OKL_K_HEADERS_V khr,

3553: SELECT khr.deal_type,
3554: chr.scs_code,
3555: --Bug# 4419339
3556: chr.orig_system_source_code
3557: FROM OKL_K_HEADERS_V khr,
3558: OKC_K_HEADERS_B chr
3559: WHERE khr.id = p_dnz_chr_id
3560: AND chr.id = khr.id;
3561: BEGIN