Query to get SARS code for IRP5 and IT3A files

Like in India we submit Form16 at the end of every financial year we submit either Form IRP5 or IT3A in South Africa. Post Oracle Tax Year End processing for SARS (South African Revenue Service) can give you more information about processing IRP5 and IT3A files for south Africa legislation.

Some time when you are creating any new element you may need to link the element with a specific sars code. Sometime you would also like to know what is the SARS code associated with an element. Following query will give you the SARS code linked with any element. In the query just pass the element you would like to check

SARS code for IRP5 and IT3A

SELECT element_name "Element Name",
pbt.balance_name "Balance Name",
irp5.CODE "SARS Code"
FROM apps.pay_balance_types pbt,
apps.pay_element_types_f petf,
apps.pay_input_values_f pivf,
apps.pay_balance_feeds_f pbff,
apps.pay_za_irp5_bal_codes irp5
WHERE petf.element_name = 'iavinash – oracle hcm and wordpress hub' /* Give your element name here*/ 
AND pbt.balance_type_id = pbff.balance_type_id
AND petf.element_type_id = pivf.element_type_id
AND pbff.input_value_id = pivf.input_value_id
AND SYSDATE BETWEEN petf.effective_start_date AND petf.effective_end_date
AND SYSDATE BETWEEN pivf.effective_start_date AND pivf.effective_end_date
AND SYSDATE BETWEEN pbff.effective_start_date AND pbff.effective_end_date
AND pbt.LEGISLATION_CODE = 'ZA'
AND pbt.BALANCE_TYPE_ID = irp5.BALANCE_TYPE_ID
AND petf.EFFECTIVE_END_DATE > sysdate
AND pbff.EFFECTIVE_END_DATE > sysdate
ORDER BY petf.element_name, pbt.balance_name

In the above query to get SARS code for IRP5 and IT3A files you can see that SARS code is actually linked to Balance and not element. An element may be feeding to more than one balance so apparently an element may also be linked with more than one SARS code.