When i run select * from per_all_people_f;
it is returning records from single Table but not when we run SQL Script which is executing from others PC(my Team members) with same network same version of Software's we are using.
SELECT
papf.full_name,
papf.employee_number,
to_char(aba.creation_date, 'DD-MON-RRRR') absence_creation_date,
abt.name absence_type,
aba.date_start,
aba.date_end,
aba.absence_days
FROM
per_absence_attendances aba,
per_abs_attendance_types_vl abt,
per_abs_attendance_reasons abr,
pay_input_values_f_tl ivtl,
pay_input_values_f iv,
per_all_people_f pep,
per_all_people_f pep2,
ssp_maternities hm,
hr_lookups hrl,
hr_lookups l,
per_all_people_f papf
WHERE
aba.absence_attendance_type_id = abt.absence_attendance_type_id
AND abt.input_value_id = iv.input_value_id (+)
AND aba.authorising_person_id = pep.person_id (+)
AND aba.replacement_person_id = pep2.person_id (+)
AND aba.abs_attendance_reason_id = abr.abs_attendance_reason_id (+)
AND abt.absence_category = hrl.lookup_code (+)
AND hrl.lookup_type (+) = 'ABSENCE_CATEGORY'
AND abr.name = l.lookup_code (+)
AND l.lookup_type (+) = 'ABSENCE_REASON'
AND aba.maternity_id = hm.maternity_id (+)
AND nvl(aba.date_notification, sysdate) BETWEEN nvl(iv.effective_start_date, nvl(aba.date_notification, sysdate)) AND nvl(iv.
effective_end_date, nvl(aba.date_notification, sysdate))
AND nvl(aba.date_start, nvl(date_projected_start, sysdate)) BETWEEN nvl(pep.effective_start_date, nvl(aba.date_start, nvl(date_projected_start,
sysdate))) AND nvl(pep.effective_end_date, nvl(aba.date_start, nvl(date_projected_start, sysdate)))
AND nvl(aba.date_start, nvl(date_projected_start, sysdate)) BETWEEN nvl(pep2.effective_start_date, nvl(aba.date_start, nvl(date_projected_start,
sysdate))) AND nvl(pep2.effective_end_date, nvl(aba.date_start, nvl(date_projected_start, sysdate)))
AND iv.input_value_id = ivtl.input_value_id (+)
AND decode(ivtl.input_value_id, NULL, '1', ivtl.language) = decode(ivtl.input_value_id, NULL, '1', userenv('LANG'))
AND aba.person_id = papf.person_id
AND sysdate BETWEEN papf.effective_start_date AND papf.effective_end_date
AND to_date(aba.date_start) between '01-jul-2022' and '31-jul-2022' ;