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
Run PAY Database Triggers Status and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Trigger Status
 
LOV Oracle
Display Trigger Body
 
LOV Oracle