(Payroll) To get element wise details query

select distinct to_number(papf.employee_number) as employee_number, papf.full_name,
prrv.result_value as amount, '' as numbers, null cumulative, null as org,
null as attrib1, null as attrib2, null as attrib3, null as attrib4, to_number(rownum) as slno
from
apps.per_all_people_f papf,
apps.per_all_assignments_f paaf,
apps.pay_assignment_actions paa,
apps.pay_payroll_actions ppa,
apps.hr_all_organization_units haou,
apps.pay_consolidation_sets pcs,
apps.pay_run_results prr,
apps.pay_run_result_values prrv,
apps.pay_input_values_f pivf,
apps.pay_input_values_f_tl pivft,
apps.pay_element_types_f petf,
apps.pay_element_classifications_tl pect
where
papf.person_id = paaf.person_id
and papf.EFFECTIVE_END_DATE = paaf.EFFECTIVE_END_DATE
and paaf.ASSIGNMENT_ID = paa.ASSIGNMENT_ID
and ppa.payroll_action_id = paa.payroll_action_id
and paaf.ORGANIZATION_ID = haou.ORGANIZATION_ID
and ppa.CONSOLIDATION_SET_ID = pcs.CONSOLIDATION_SET_ID
and paa.ASSIGNMENT_ACTION_ID = prr.ASSIGNMENT_ACTION_ID
and prr.RUN_RESULT_ID = prrv.RUN_RESULT_ID
and prrv.INPUT_VALUE_ID = pivf.INPUT_VALUE_ID
and pivf.ELEMENT_TYPE_ID = petf.ELEMENT_TYPE_ID
and petf.CLASSIFICATION_ID = pect.CLASSIFICATION_ID
and petf.ELEMENT_TYPE_ID = prr.ELEMENT_TYPE_ID
and pivf.INPUT_VALUE_ID = pivft.INPUT_VALUE_ID
and upper(haou.name) like upper('%'||:p_organization||'%')
--and prrv.result_value <> '0'
and ppa.payroll_id in (61, 63)
and pivft.name = 'Pay Value'
AND pivf.uom in ('M')
and papf.employee_number = nvl(:p_employee_number, papf.employee_number)
and pcs.consolidation_set_name = NVL (:p_payroll_type, pcs.consolidation_set_name)
and to_char(ppa.effective_date, 'MON-YY') = :p_from_date  
and pect.classification_id = nvl(:p_classification_name, pect.classification_id)
and petf.element_type_id = nvl(:p_element_name,petf.element_type_id)
order by employee_number;