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
edited Sep 11, 2020 7:23AM in Payroll and Global Payroll Interface (GPI) 4 comments


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


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.


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