PAY Dynamic Triggers Status

Description
Categories: BI Publisher
Application: Payroll
Source: Dynamic Triggers Status Report (XML)
Short Name: PAYRPDTR_XML
DB package: PAY_PAYRPDTR_XMLP_PKG
Run PAY Dynamic Triggers Status and other Oracle EBS reports with Blitz Report™ on our demo environment
select htsv.trigger_name, htsv.trigger_type, htsv.triggering_event, pte.short_name, pte.generated_flag
from hr_trigger_status_v htsv, pay_trigger_events pte
where htsv.status = :P_Status
and RTRIM(SUBSTR(trigger_name,(INSTR(trigger_name,'_')+1)),'UID_DYT') = to_char(event_id)
and enabled_flag = :P_Enabled_Flag
Parameter Name SQL text Validation
Database Trigger Status
 
LOV Oracle
Dynamic Trigger Enabled Flag
 
LOV Oracle