APPS.OKL_MASS_REBOOK_PVT dependencies on OKC_K_LINES_V

Line 1282: CURSOR oec_csr (p_top_line_id OKC_K_LINES_V.ID%TYPE) IS

1278: l_api_name VARCHAR2(35) := 'update_residual_value';
1279: l_proc_name VARCHAR2(35) := 'UPDATE_RESIDUAL_VALUE';
1280: l_api_version NUMBER := 1.0;
1281:
1282: CURSOR oec_csr (p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
1283: SELECT oec
1284: FROM okl_k_lines_full_v
1285: WHERE id = p_top_line_id;
1286:

Line 1404: p_kle_id OKC_K_LINES_V.ID%TYPE) IS

1400: FROM okc_k_items_v
1401: WHERE cle_id = p_fa_line_id;
1402:
1403: CURSOR fa_line_csr (p_chr_id OKL_K_HEADERS_V.ID%TYPE,
1404: p_kle_id OKC_K_LINES_V.ID%TYPE) IS
1405: SELECT line.id
1406: FROM okc_k_lines_v line,
1407: okc_line_styles_v style
1408: WHERE line.lse_id = style.id

Line 1406: FROM okc_k_lines_v line,

1402:
1403: CURSOR fa_line_csr (p_chr_id OKL_K_HEADERS_V.ID%TYPE,
1404: p_kle_id OKC_K_LINES_V.ID%TYPE) IS
1405: SELECT line.id
1406: FROM okc_k_lines_v line,
1407: okc_line_styles_v style
1408: WHERE line.lse_id = style.id
1409: AND style.lty_code = 'FIXED_ASSET'
1410: AND dnz_chr_id = p_chr_id

Line 1689: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

1685: l_proc_name VARCHAR2(35) := 'UPDATE_SLH_SLL';
1686: l_api_version NUMBER := 1.0;
1687:
1688: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1689: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1690: SELECT ID
1691: FROM okc_rule_groups_v
1692: WHERE dnz_chr_id = p_chr_id
1693: AND cle_id = p_cle_id

Line 2013: p_cle_id OKC_K_LINES_V.ID%TYPE) IS

2009: l_proc_name VARCHAR2(35) := 'UPDATE_PPD_AMOUNT';
2010: l_api_version NUMBER := 1.0;
2011:
2012: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2013: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
2014: SELECT ID
2015: FROM okc_rule_groups_v
2016: WHERE dnz_chr_id = p_chr_id
2017: AND cle_id = p_cle_id