Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Unable to find Pension Calendar year to date column table — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to find Pension Calendar year to date column table

Received Response
1
Views
6
Comments

Summary:

I am unable to find pension Calendar Year to date column for Annual Pension Initial loaded data in only available in PAY_BAL_BATCH_LINES Table

Content (required):

Need Pension column for latest date. Calendar year to date data

Version (include the version you are using, if applicable):

Oracle fusion cloud Application

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT DISTINCT

ppnf.DISPLAY_NAME "Employee Name",

PAPF.person_number "Employee Number",

(SELECT national_identifier_number

 FROM  per_national_identifiers

 WHERE person_id = papf.person_id

 AND national_identifier_type = 'SSN')

SSN,




paaf.BARGAINING_UNIT_CODE "Bargaining Unit",

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!