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
SQL 8 lines
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 |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Dynamic Trigger Enabled Flag | LOV Oracle |