PAY Database Triggers Status
Description
- Categories
- BI Publisher
- Application
- Payroll
- Source
- Database Triggers Status Report (XML)
- Short Name
- PAYRPHTS_XML
- DB package
- PAY_PAYRPHTS_XMLP_PKG
SQL 11 lines
SELECT * FROM hr_trigger_status_v WHERE :P_Detail = 'N' AND status = :P_Status UNION ALL SELECT * FROM hr_trigger_status_v WHERE :P_Detail = 'Y' AND status = :P_Status order by 1,5,11,2,3,7,9,6,13,8,10,12 |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Trigger Status | LOV Oracle | |
| Display Trigger Body | LOV Oracle |