SELECT '01 - 02' AS qTempoh, (SELECT COUNT(distinct daftar_bayaran_seq ) FROM v_tempohPembayaranBil WHERE bil1<=2 AND statusbil<>7 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY'))  AS qBil1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE bil2<=2 AND statusbil<>7 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE bil3<=2 AND statusbil<>7 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE BB1<=2 AND statusbil<>7 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE BB2<=2 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY'))  AS qBB2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE BB3<=2 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY'))  AS qBB3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE sediaCek<=2 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qSediaCek FROM v_tempohPembayaranBil WHERE tahun=:PF_P_TAHUN AND ROWNUM = 1 
UNION
SELECT '03 - 04' AS qTempoh, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil1 >2 AND bil1<=4) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL<= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY'))  AS qBil1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil2 >2 AND bil2<=4) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil3 >2 AND bil3<=4) AND ( statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB1 >2 AND BB1<=4) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB2 >2 AND BB2<=4) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB3 >2 AND BB3<=4) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (sediaCek >2 AND sediaCek<=4) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qSediaCek FROM v_tempohPembayaranBil WHERE tahun=:PF_P_TAHUN AND ROWNUM = 1 
UNION
SELECT '05 - 07' AS qTempoh, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil1 >4 AND bil1<=7) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL<= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY'))  AS qBil1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil2 >4 AND bil2<=7) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil3 >4 AND bil3<=7) AND ( statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB1 >4 AND BB1<=7) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB2 >4 AND BB2<=7) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB3 >4 AND BB3<=7) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (sediaCek >4 AND sediaCek<=7) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qSediaCek FROM v_tempohPembayaranBil WHERE tahun=:PF_P_TAHUN AND ROWNUM = 1 
UNION
SELECT '08 - 10' AS qTempoh, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil1 >7 AND bil1<=10) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL<= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY'))  AS qBil1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil2 >7 AND bil2<=10) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil3 >7 AND bil3<=10) AND ( statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB1 >7 AND BB1<=10) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB2 >7 AND BB2<=10) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB3 >7 AND BB3<=10) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (sediaCek >7 AND sediaCek<=10) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qSediaCek FROM v_tempohPembayaranBil WHERE tahun=:PF_P_TAHUN AND ROWNUM = 1 
UNION 
SELECT '11 - 14' AS qTempoh, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil1 >10 AND bil1<=14) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil2 >10 AND bil2<=14) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY'))  AS qBil2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil3 >10 AND bil3<=14) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB1 >10 AND BB1<=14) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB2 >10 AND BB2<=14) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB3 >10 AND BB3<=14) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (sediaCek >10 AND sediaCek<=14) AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qSediaCek FROM v_tempohPembayaranBil WHERE tahun=:PF_P_TAHUN AND ROWNUM = 1 
UNION 
SELECT '15 - 30' as qTempoh, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil1 >14 AND bil1<=30) AND ((statusbb<>7 AND statusbb<>8) or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil2 >14 AND bil2<=30) AND ((statusbb<>7 AND statusbb<>8) or statusbb is null)  AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (bil3 >14 AND bil3<=30) AND ((statusbb<>7 AND statusbb<>8) or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB1 >14 AND BB1<=30) AND ((statusbb<>7 AND statusbb<>8) or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB2 >14 AND BB2<=30) AND ((statusbb<>7 AND statusbb<>8) or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (BB3 >14 AND BB3<=30) AND ((statusbb<>7 AND statusbb<>8) or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE (sediaCek >14 AND sediaCek<=30) AND ((statusbb<>7 AND statusbb<>8) or statusbb is null) AND  statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qSediaCek FROM v_tempohPembayaranBil WHERE tahun=:PF_P_TAHUN AND ROWNUM = 1
UNION 
SELECT '> 30' as qTempoh, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE bil1 >30 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE bil2 >30 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE bil3 >30 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBil3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE BB1 >30 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB1, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE BB2 >30 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB2, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE BB3 >30 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qBB3, (SELECT COUNT(distinct daftar_bayaran_seq) FROM v_tempohPembayaranBil WHERE sediaCek >30 AND (statusbb<>7 AND statusbb<>8 or statusbb is null) AND statusbil<>7 AND jab=:PF_P_KOD_JAB AND ptj=:PF_P_KOD_PTJ AND TAHUN=:PF_P_TAHUN AND TKH_TERIMA_BIL <= TO_DATE(:PF_P_TKH_MULA, 'DD/MM/YYYY')) AS qSediaCek FROM v_tempohPembayaranBil WHERE tahun=:PF_P_TAHUN AND ROWNUM = 1