PAY Dynamic Triggers missing from Database

Description
Categories: BI Publisher
Application: Payroll
Source: Dynamic Triggers missing from Database (XML)
Short Name: PAYRPTMD_XML
DB package: PAY_PAYRPTMD_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  short_name, table_name, generated_flag
from pay_trigger_events 
where enabled_flag = :P_enabled_flag_1
and NOT EXISTS (select 'A'
from hr_trigger_status_v
where to_char(event_id) = RTRIM(SUBSTR(trigger_name,(INSTR(trigger_name,'_')+1)),'UID_DYT'))
ORDER BY table_name
Parameter Name SQL text Validation
Dynamic Trigger Enabled Flag
 
LOV Oracle