OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Last Payroll Run for employee (Oracle Payroll 11.5.10 fp:k)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Last Payroll Run for employee [message #379939]

Thu, 08 January 2009 09:52

rbertrand
Messages: 45
Registered: November 2005

Member

hello,
I am trying to find table or view that holds the last payroll run date for an employee. I see it on the People>Assignment>Salary web screen, but when I go to 'about page' and look at the queries behind the form, I can't find it. I also queried all the tables for that column and couldn't find it. Please help!

Report message to a moderator

Re: Last Payroll Run for employee [message #380127 is a reply to message #379939]

Fri, 09 January 2009 04:04

v.ram81
Messages: 50
Registered: April 2006
Location: pune

Member

Hi,

From metalink --

PAY_PAYROLL_ACTIONS this table holds general details about the execution of payroll processes, including their type and all the parameters passed to them.
PAY_PAYROLL_ACTIONS.EFFECTIVE_DATE this field indicates the payroll process date.
Hope this might be helpful.

Regards,
Ram.

Report message to a moderator

Re: Last Payroll Run for employee [message #380880 is a reply to message #380127]

Tue, 13 January 2009 14:36

rbertrand
Messages: 45
Registered: November 2005

Member

thanks Ram, thats what I ended up doing. I used the following tables: per_all_assignments_f paaf,
pay_assignment_actions paa,
pay_payroll_actions ppa,
per_all_people_f papf,
pay_action_information pai

We were looking for all emps who were termed but had received a check on our last payroll run. The pai table has gross amount, so I could check if the payment was actually > 0.

thanks for the help Ram, I appreciate it!

Report message to a moderator

Previous Topic:	cannot convert oracle apps report output file into excel file
Next Topic:	Connnecting to fornt end user while the instance is in maintainance mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 22:58:34 CDT 2024