APPS.OKS_RENCON_PVT dependencies on OKS_K_LINES_B

Line 2923: FROM okc_k_lines_b c, oks_k_lines_b s

2919: l_error_text VARCHAR2(512);
2920:
2921: CURSOR c_top_lines(cp_chr_id IN NUMBER) IS
2922: SELECT c.cle_id, SUM(nvl(c.price_negotiated, 0)), SUM(nvl(s.tax_amount, 0))
2923: FROM okc_k_lines_b c, oks_k_lines_b s
2924: WHERE c.dnz_chr_id = cp_chr_id
2925: --get only sublines for 1,12,19 (14:no renewal, 46:no sublines)
2926: AND c.lse_id IN (7, 8, 9, 10, 11, 35, 13, 25)
2927: AND s.cle_id = c.id

Line 2987: UPDATE oks_k_lines_b

2983: program_update_date = l_update_date
2984: WHERE id = l_id_tbl(i);
2985:
2986: FORALL i IN l_id_tbl.first..l_id_tbl.last
2987: UPDATE oks_k_lines_b
2988: SET tax_amount = l_tax_tbl(i),
2989: object_version_number = object_version_number + 1,
2990: last_updated_by = l_user_id,
2991: last_update_date = l_update_date,

Line 3027: (SELECT SUM(stl.tax_amount) FROM okc_k_lines_b ctl, oks_k_lines_b stl

3023: WHERE h.id = p_header_id;
3024:
3025: UPDATE oks_k_headers_b h
3026: SET h.tax_amount =
3027: (SELECT SUM(stl.tax_amount) FROM okc_k_lines_b ctl, oks_k_lines_b stl
3028: WHERE ctl.dnz_chr_id = p_header_id AND ctl.cle_id IS NULL
3029: AND ctl.lse_id IN (1, 12, 19, 46) AND stl.cle_id = ctl.id
3030: /* Added by sjanakir for Bug# 8287971 */
3031: AND ctl.date_cancelled IS NULL),