APPS.OKS_RENCON_PVT dependencies on OKS_K_LINES_B

Line 2921: FROM okc_k_lines_b c, oks_k_lines_b s

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

Line 2983: UPDATE oks_k_lines_b

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

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

3017: WHERE h.id = p_header_id;
3018:
3019: UPDATE oks_k_headers_b h
3020: SET h.tax_amount =
3021: (SELECT SUM(stl.tax_amount) FROM okc_k_lines_b ctl, oks_k_lines_b stl
3022: WHERE ctl.dnz_chr_id = p_header_id AND ctl.cle_id IS NULL
3023: AND ctl.lse_id IN (1, 12, 19, 46) AND stl.cle_id = ctl.id),
3024: h.object_version_number = h.object_version_number + 1,
3025: h.last_updated_by = l_user_id,