PAY Dynamic Triggers Status

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: Dynamic Triggers Status Report (XML)
Short Name: PAYRPDTR_XML
DB package: PAY_PAYRPDTR_XMLP_PKG
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 NameSQL textValidation
Database Trigger Status
 
LOV Oracle
Dynamic Trigger Enabled Flag
 
LOV Oracle
Download
Related Blitz Reports
PAY Functional Area PAY Dynamic Triggers missing from Database CE General Ledger Reconciliation PON Solicitation data template PAY Database Triggers Status QA Collection Plan Upload ORB Report Execution History AP Supplier Upload AR Customer Upload
Blitz Report™