PAY Database Triggers Status

Description
Categories: BI Publisher
Columns: Owner, Trigger Name, Trigger Type, Triggering Event, Table Owner, Base Object Type, Table Name, Column Name, Referencing Names, When Clause ...
Application: Payroll
Source: Database Triggers Status Report (XML)
Short Name: PAYRPHTS_XML
DB package: PAY_PAYRPHTS_XMLP_PKG
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