PAY SARS Codes

select distinct b.element_name, e. full_balance_name, e.code
from
pay_balance_feeds_f d,
pay_balance_types c,
pay_input_values_f a,
pay_element_types_f b,
pay_za_irp5_bal_codes e
where
a. element_type_id = b.element_type_id
and d.balance_type_id = d. balance_type_id
and a.input_value_id = d.input_value_id
and e.balance_type_id = d.balance_type_id

select distinct b.element_name, e. full_balance_name, e.code from pay_balance_feeds_f d, pay_balance_types c, pay_input_values_f a, pay_element_types_f b, pay_za_irp5_bal_codes e where a. element_type_id = b.element_type_id and d.balance_type_id = d. balance_type_id and a.input_value_id = d.input_value_id and e.balance_type_id = d.balance_type_id