Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
PAY: Displaying all serial numbers
Hi All,
I am developing a query to display serial Number(Check_Number) based on "Payroll Name" and "Period Name" for a particular employee.
I am expecting the result for the specified "Payroll Name" and "Period Name" but it is showing all serial numbers.
Pls find the query as below:
select paa.SERIAL_NUMBER
from pay_pre_payments ppp
,pay_assignment_actions paa
,pay_payroll_actions ppa
,per_time_periods ptp
,per_all_assignments_f paaf
where 1=1
and ppp.PRE_PAYMENT_ID = paa.PRE_PAYMENT_ID
and ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID
and ptp.payroll_id = ppa.payroll_id
0