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