TAAS

SELECT
        spd.pk_supp_doc_no_id,
    htlm.vhr_hotel_code,
    htlm.vhr_hotel_name,
    htlm.vhr_display_name,

    htl.sin_record_type,

    hfd.dbl_supplier_amount, 
    hfd.dbl_normal_profit

FROM service.tbl_supp_doc_no AS spd
LEFT JOIN hotel.tbl_hotel_gen_data hotgen
    ON spd.pk_supp_doc_no_id = hotgen.fk_supp_doc_no_id 
LEFT JOIN hotel.tbl_hotel AS htl
    ON spd.pk_supp_doc_no_id = htl.fk_supp_doc_no_id
LEFT JOIN service.tbl_supp_doc_fare AS hfd
        ON spd.fk_issue_base_fare_id = hfd.pk_supp_doc_fare_id -- Currecy inputbase Choose the field
LEFT JOIN hotel.tbl_hotel_master AS htlm
    ON hotgen.fk_hotel_master_id = htlm.pk_hotel_master_id 

WHERE spd.sin_supp_doc_category = 2 
AND spd.sin_last_action != -1
    AND ((sin_record_type = 1 AND spd.dat_issue BETWEEN '2023-07-01' AND '2023-07-31' --Sales side
            AND spd.sin_sys_sale_side_status = 1
             -- ...
         ) 
       OR (sin_record_type = 2 AND spd.dat_cancel BETWEEN '2023-07-01' AND '2023-07-31' --Refund side where
            AND spd.sin_sys_refund_side_status IN (1,2)
             --  ...
          ))

AND htl.fk_branch_id = ANY('{1,2}'::BIGINT[])
AND htl.fk_department_id = ANY('{1,2}'::BIGINT[])
AND hfd.vhr_currency = 'QAR'
AND htl.fk_supplier_ac_id = ?

Consider where condition Refer -> Any SaleAndRefund Cs query code

TESTING DONE