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
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 |