PAY Dynamic Triggers missing from Database

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: Dynamic Triggers missing from Database (XML)
Short Name: PAYRPTMD_XML
DB package: PAY_PAYRPTMD_XMLP_PKG
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 NameSQL textValidation
Dynamic Trigger Enabled Flag
 
LOV Oracle
Download
Related Blitz Reports
PAY Functional Area PAY Dynamic Triggers Status CE General Ledger Reconciliation PON Solicitation data template PAY Database Triggers Status QA Collection Plan Upload ORB Report Execution History AP Supplier Upload AR Customer Upload
Blitz Report™