Payroll and OTL - EBS (MOSC)

MOSC Banner

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: Help with column source_action_id in table pay_assignment_actions

edited Feb 5, 2011 4:05AM in Payroll and OTL - EBS (MOSC) 7 commentsAnswered
 I've searched all over and cannot find the true meaning of column source_action_id in table pay_assignment_actions. More to the point, I've inherited code that runs a relatively simple query to retrieve all specific payroll dates from pay_payroll_actions based on effective_date being between a date range. These dates are then used to pull 401k balances for the effective date. In this query, pay_payroll_actions is joined onto pay_assignment_actions solely to verify that for a given payroll, source_action_id is NOT null. If it is null, the query will not consider it for the 401k query.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center