Post date: Nov 26, 2012 9:58:27 AM
-- parameter
-- GEI : kode area --> 140
-- ps 23 : kode pajak --> 40303
delete pgn_hutang_pajak_lines
where hp_line_id in (
select hp_line_id from pgn_hutang_pajak_lines
where je_header_id in (
select distinct pptv.je_header_id
from pgn_hutang_pajak_v pptv
where kode_org = :kode_area and status is null and kode_pajak = :kode_pajak)
);
Script untuk menghapus data "kotor" di Hutang Pajak.