DBA Data[Home] [Help]

APPS.OKL_CREDIT_PUB dependencies on OKC_K_LINES_V

Line 4273: -- assign okc_k_lines_v

4269: x_clev_rec.sts_code := 'ENTERED';
4270: x_clev_rec.exception_yn := 'N';
4271:
4272: -------------------------------------------
4273: -- assign okc_k_lines_v
4274: -------------------------------------------
4275: x_clev_rec.start_date := NULLIF(p_clmv_rec.start_date, OKC_API.G_MISS_DATE);
4276: x_clev_rec.item_description := NULLIF(p_clmv_rec.item_description, OKC_API.G_MISS_CHAR);
4277: -------------------------------------------

Line 4583: FROM OKC_K_LINES_V

4579: -- cursor to fetch the okc_k_lines fields which are updatable by user
4580: CURSOR c_clev_csr IS
4581: SELECT ITEM_DESCRIPTION,
4582: START_DATE
4583: FROM OKC_K_LINES_V
4584: WHERE ID = p_clev_rec.ID;
4585: -- cursor to fetch the okl_k_lines fields which are updatable by user
4586: CURSOR c_klev_csr IS
4587: SELECT AMOUNT,

Line 5028: from OKC_K_LINES_V okc,

5024: okc.item_description,
5025: okc.start_date,
5026: okl.credit_nature,
5027: okl.amount
5028: from OKC_K_LINES_V okc,
5029: OKL_K_LINES okl
5030: where okc.id = okl.id
5031: and okc.dnz_chr_id = p_chr_id;
5032: