PAY Database Triggers Status

Description
Categories: BI Publisher, Human Resources
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
Parameter Name SQL text Validation
Display Trigger Body
 
LOV Oracle
Trigger Status
 
LOV Oracle
Ask a question