Need SQL to extract the amount and periodicity of worker element entries

Summary:

Hi Experts,

Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement.

Written this but it's giving me Amount not Periodicty, Really appreciate your help in Advance.

select pivf.*,
(SELECT pivf.RESERVED_INPUT_VALUE
FROM pay_element_entries_f peef
,pay_element_types_f petf
,pay_input_values_f pivf
,pay_element_entry_values_f peevf
,per_all_people_f per1
WHERE peef.element_type_id = petf.element_type_id
AND petf.element_type_id = pivf.element_type_id
AND peef.element_entry_id = peevf.element_entry_id