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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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

Blitz Report™ provides multiple benefits: