APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKC_K_LINES_TL

Line 709: from okc_k_lines_tl clet

705:
706: --cursor to fetch asset number for exception
707: cursor l_clet_csr (p_cle_id in number) is
708: select clet.name
709: from okc_k_lines_tl clet
710: where clet.id = p_cle_id
711: and clet.language = userenv('LANG');
712:
713: l_asset_number okc_k_lines_tl.name%TYPE;

Line 713: l_asset_number okc_k_lines_tl.name%TYPE;

709: from okc_k_lines_tl clet
710: where clet.id = p_cle_id
711: and clet.language = userenv('LANG');
712:
713: l_asset_number okc_k_lines_tl.name%TYPE;
714:
715: begin
716:
717: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3876: okc_k_lines_tl clet,

3872: select 'Y',
3873: clet.name subsidy_name,
3874: clet_asst.name asset_number
3875: from okl_k_lines kle,
3876: okc_k_lines_tl clet,
3877: okc_k_lines_b cleb,
3878: okc_line_styles_b lseb,
3879: okc_k_lines_tl clet_asst
3880: where kle.id = cleb.id

Line 3879: okc_k_lines_tl clet_asst

3875: from okl_k_lines kle,
3876: okc_k_lines_tl clet,
3877: okc_k_lines_b cleb,
3878: okc_line_styles_b lseb,
3879: okc_k_lines_tl clet_asst
3880: where kle.id = cleb.id
3881: and kle.subsidy_id = p_subsidy_id
3882: and clet.id = cleb.id
3883: and clet.language = userenv('LANG')

Line 3915: -- l_subsidy_name okc_k_lines_tl.name%TYPE;

3911: */
3912:
3913: l_exists varchar2(1) default 'N';
3914:
3915: -- l_subsidy_name okc_k_lines_tl.name%TYPE;
3916: -- l_asset_number okc_k_lines_tl.name%TYPE;
3917:
3918:
3919: BEGIN

Line 3916: -- l_asset_number okc_k_lines_tl.name%TYPE;

3912:
3913: l_exists varchar2(1) default 'N';
3914:
3915: -- l_subsidy_name okc_k_lines_tl.name%TYPE;
3916: -- l_asset_number okc_k_lines_tl.name%TYPE;
3917:
3918:
3919: BEGIN
3920: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4062: okc_k_lines_tl clet,

4058: select 'Y',
4059: clet.name subsidy_name,
4060: clet_asst.name asset_number
4061: from okl_k_lines kle,
4062: okc_k_lines_tl clet,
4063: okc_k_lines_b cleb,
4064: okc_line_styles_b lseb,
4065: okc_k_lines_tl clet_asst
4066: where kle.id = cleb.id

Line 4065: okc_k_lines_tl clet_asst

4061: from okl_k_lines kle,
4062: okc_k_lines_tl clet,
4063: okc_k_lines_b cleb,
4064: okc_line_styles_b lseb,
4065: okc_k_lines_tl clet_asst
4066: where kle.id = cleb.id
4067: and kle.subsidy_id = p_subsidy_id
4068: and clet.id = cleb.id
4069: and clet.language = userenv('LANG')

Line 4137: l_subsidy_name okc_k_lines_tl.name%TYPE;

4133:
4134: l_exists varchar2(1) default 'N';
4135: l_count number := 0;
4136:
4137: l_subsidy_name okc_k_lines_tl.name%TYPE;
4138: l_asset_number okc_k_lines_tl.name%TYPE;
4139:
4140:
4141: BEGIN

Line 4138: l_asset_number okc_k_lines_tl.name%TYPE;

4134: l_exists varchar2(1) default 'N';
4135: l_count number := 0;
4136:
4137: l_subsidy_name okc_k_lines_tl.name%TYPE;
4138: l_asset_number okc_k_lines_tl.name%TYPE;
4139:
4140:
4141: BEGIN
4142: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4270: from okc_k_lines_tl clet

4266: l_applicable VARCHAR2(1);
4267:
4268: cursor l_clet_csr(p_cle_id in number) is
4269: select clet.name
4270: from okc_k_lines_tl clet
4271: where clet.id = p_cle_id
4272: and clet.language = userenv('LANG');
4273:
4274: l_asset_number okc_k_lines_tl.name%TYPE;

Line 4274: l_asset_number okc_k_lines_tl.name%TYPE;

4270: from okc_k_lines_tl clet
4271: where clet.id = p_cle_id
4272: and clet.language = userenv('LANG');
4273:
4274: l_asset_number okc_k_lines_tl.name%TYPE;
4275:
4276: cursor l_sub_csr(p_subsidy_id in number) is
4277: select subb.name
4278: from okl_subsidies_b subb