CREATE OR REPLACE VIEW core.bonus_slab_detail_scrud_view
AS
SELECT bonus_slab_details.bonus_slab_detail_id,
bonus_slab_details.bonus_slab_id,
bonus_slabs.bonus_slab_name AS slab_name,
bonus_slab_details.amount_from,
bonus_slab_details.amount_to,
bonus_slab_details.bonus_rate
FROM core.bonus_slab_details,
core.bonus_slabs
WHERE bonus_slab_details.bonus_slab_id = bonus_slabs.bonus_slab_id;