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
48
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!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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