Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Make EFT Payments - Payroll Flow — 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

Make EFT Payments - Payroll Flow

Received Response
49
Views
4
Comments
edited Sep 11, 2020 7:23AM in Payroll and Global Payroll Interface (GPI) 4 comments

Summary

Looking for the query behind the Smart LOV for "Report Category" parameter

Content

Hi Team,

I am looking for the query behind the Smart LOV - "Report Category|ReportCategoryPVO" which is one of the parameter(Report Category) when we run the "Make EFT Payments" process.

I am aware of the tables, PAY_REPORT_CATEGORIES_VL and PAY_REPORT_GROUPS where I can get the values from the SQL. But I am looking for the actual SQL by Oracle for the Smart LOV.

any leads on this will be helpful. Thanks in advance!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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