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
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
Download
 
Related Blitz Reports
PAY Dynamic Triggers missing from Database PAY Functional Area CE General Ledger Reconciliation PON Solicitation data template PAY Database Triggers Status ECC Projects, Projects Costing: Transactions, SQL1 GL Account Analysis (Distributions) QA Collection Element Action Rules QA Collection Plan Action Rules
Blitz Report™

Blitz Report™ provides multiple benefits: