Purge GSP Transactions in Staging Table
NAME: Purge GSP Transactions in Staging Table
SHORT CODE: PQHGSPUR
MODULE: Oracle Public Sector HR
Description: Purging GSP Transactions in Staging Area
Navigation: Oracle Public Sector HR Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.
Report Parameters:
- p_alias : Master Table alias name
- paramname1 : Short Name
- paramvalue1 : Value for Short Name
- paramname2 : Status
- paramvalue2 : Value for Status
- paramname3 : Start Action Date
- paramvalue3 : Value of Start Date
- paramname4 : End Action Date
- paramvalue4 : Value of End Date
- paramname5 :
- paramvalue5 :
- p_effective_date : Effective Date for Datetracked data