select count(1)
from ps_cib_apply_tbl cat
where cat.completed_dt>=trunc(next_day(sysdate-8,1)-6)
and cat.completed_dt<=trunc(next_day(sysdate-8,1))
and cat.cib_apply_type='empl'
and cat.comleted_id='ps'
select count(1)
from ps_cib_apply_tbl cat
where cat.completed_dt>=trunc(next_day(sysdate-8,1)-6)
and cat.completed_dt<=trunc(next_day(sysdate-8,1))
and cat.cib_apply_type='empl'
and cat.comleted_id='ps'