DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PVT dependencies on OKL_K_HEADERS_V

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

3502: ln_dummy NUMBER := 0;
3503: ln1_dummy NUMBER := 0;
3504: ln2_dummy NUMBER := 0;
3505: ln3_dummy NUMBER := p_units;
3506: lv_deal_type OKL_K_HEADERS_V.DEAL_TYPE%TYPE := null;
3507: lv_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := null;
3508: --Bug# 4419339
3509: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%TYPE;
3510: CURSOR get_deal_type(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)

Line 3516: FROM OKL_K_HEADERS_V khr,

3512: SELECT khr.deal_type,
3513: chr.scs_code,
3514: --Bug# 4419339
3515: chr.orig_system_source_code
3516: FROM OKL_K_HEADERS_V khr,
3517: OKC_K_HEADERS_B chr
3518: WHERE khr.id = p_dnz_chr_id
3519: AND chr.id = khr.id;
3520: BEGIN