The Query is showing more duplicate records for single person
Hi all,
We have made only one change but in report it is showing more than 100 data which are not correct, we need to remove duplicate records in final output.
WITH pay_roll
AS (SELECT py.payroll_name,
pt.hr_term_id
FROM pay_payroll_terms pt,
pay_assigned_payrolls_dn apd,
pay_all_payrolls_f py
WHERE 1 = 1
AND pt.payroll_term_id = apd.payroll_term_id
AND pt.payroll_term_id = apd.payroll_term_id
AND py.payroll_id = apd.payroll_id)
SELECT DISTINCT PAPF.person_number,
ppnf.full_name,
To_char(asg.effective_start_date, 'DD-MON-YYYY')
START_DATE,