DBA Data[Home] [Help]

APPS.OKS_RENCON_PVT dependencies on OKS_K_HEADERS_B

Line 3025: UPDATE oks_k_headers_b h

3021: h.program_id = l_prog_id,
3022: h.program_update_date = l_update_date
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