----  02523 - DWI KURNIAWAN  dari tanggal 17 okt 2020 sampe 20 oktober 2020 dong
----  P02029 - ANDRIES HERMANTO  ---> Tolong hapus absen tanggal 27, 28 Agustus dan 1 September 2020

--SELECT * FROM SPG_REPORT_ABSENSI WHERE NIP = '02523' AND TANGGAL_ABSEN IN ('20201019', '20201020')
--SELECT * FROM SPG_REPORT_ABSENSI_DETAIL WHERE ID IN (SELECT ID FROM SPG_REPORT_ABSENSI WHERE NIP = '02523' AND TANGGAL_ABSEN IN ('20201019', '20201020'))


----DELETE FROM SPG_REPORT_ABSENSI_DETAIL WHERE ID IN (SELECT ID FROM SPG_REPORT_ABSENSI WHERE NIP = '02523' AND TANGGAL_ABSEN IN ('20201019', '20201020'))
----DELETE FROM SPG_REPORT_ABSENSI WHERE NIP = '02523' AND TANGGAL_ABSEN IN ('20201019', '20201020')


----DELETE FROM SPG_REPORT_ABSENSI WHERE NIP = 'P02029' AND TANGGAL_ABSEN IN ('20200827', '20200828', '20200901')
----DELETE FROM SPG_REPORT_ABSENSI_DETAIL WHERE ID IN (SELECT ID FROM SPG_REPORT_ABSENSI WHERE NIP = 'P02029' AND TANGGAL_ABSEN IN ('20200827', '20200828', '20200901'))

--SELECT * FROM SPG_REPORT_ABSENSI_DETAIL WHERE I
03795
select * from SPG_REPORT_ABSENSI WHERE NIP = '03795' AND TIPE = '60'
select * from SPG_REPORT_ABSENSI WHERE NIP = 'H02933' AND TANGGAL_ABSEN = '20210122'
20160329
20160328
-- cek 
select * from SPG_REPORT_ABSENSI WHERE NIP = '03795' AND TANGGAL_ABSEN IN ('20160328','20160329')
select * from SPG_REPORT_ABSENSI_DETAIL WHERE ID IN (select ID from SPG_REPORT_ABSENSI WHERE NIP = '03795' AND TANGGAL_ABSEN IN ('20160328','20160329'))

--delete from SPG_REPORT_ABSENSI_DETAIL WHERE ID IN (select ID from SPG_REPORT_ABSENSI WHERE NIP = '03795' AND TANGGAL_ABSEN IN ('20160328','20160329'))
--delete from SPG_REPORT_ABSENSI WHERE NIP = '03795' AND TANGGAL_ABSEN IN ('20160328','20160329')

03307 
select * from SPG_REPORT_ABSENSI WHERE NIP = '03307' AND TANGGAL_ABSEN >= '20210312' AND TIPE = '60'
select * from SPG_REPORT_ABSENSI_DETAIL WHERE ID IN (select ID from SPG_REPORT_ABSENSI WHERE NIP = '03307' AND TANGGAL_ABSEN >= '20210312' AND TIPE = '60')

--delete from SPG_REPORT_ABSENSI_DETAIL WHERE ID IN (select ID from SPG_REPORT_ABSENSI WHERE NIP = '03307' AND TANGGAL_ABSEN >= '20210312' AND TIPE = '60')
--delete from SPG_REPORT_ABSENSI WHERE NIP = '03307' AND TANGGAL_ABSEN >= '20210312' AND TIPE = '60'