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!

how can i get the name of payroll

edited Jul 12, 2016 4:18PM in Payroll and OTL - EBS (MOSC) 4 commentsAnswered

Dear ,

in order to get the name of the payroll, I found this:

select
PAY_PAYROLL_ACTIONS_PKG.V_NAME(ppa.PAYROLL_ACTION_ID, ppa.ACTION_TYPE, ppa.CONSOLIDATION_SET_ID, ppa.DISPLAY_RUN_NUMBER, ppa.ELEMENT_SET_ID, ppa.ASSIGNMENT_SET_ID, ppa.EFFECTIVE_DATE) NAME

from
pay_payroll_actions        ppa

how can I do this & get the same result easily

regards

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