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
SQL 6 lines
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 |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Database Trigger Status | LOV Oracle | |
| Dynamic Trigger Enabled Flag | LOV Oracle |