DBA Data[Home] [Help]

APPS.OKS_RENCON_PVT dependencies on OKS_K_HEADERS_B

Line 3019: UPDATE oks_k_headers_b h

3015: h.program_id = l_prog_id,
3016: h.program_update_date = l_update_date
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),