PAY Functional Area

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: Functional Area Report (XML)
Short Name: PAYRPFAR_XML
DB package: PAY_PAYRPFAR_XMLP_PKG
SELECT DISTINCT pfa.short_name, htsv.trigger_name, pte.short_name short_name1
from hr_trigger_status_v htsv, pay_functional_triggers pft, pay_functional_areas pfa, pay_trigger_events pte
where htsv.status = :P_Status
and (RTRIM(SUBSTR(trigger_name,(INSTR(trigger_name,'_')+1)),'UID_DYT
'), pte.short_name) IN (select to_char(event_id), pte.short_name
from pay_trigger_events pte
where enabled_flag = :P_Enabled_Flag)
and RTRIM(SUBSTR(trigger_name,(INSTR(trigger_name,'_')+1)),'UID_DYT
') IN (select to_char(event_id)
from pay_functional_triggers)
Group by pft.area_id, pfa.short_name, htsv.trigger_name, pte.short_name
order by 1,2,3
Parameter Name SQL text Validation
Dynamic Trigger Enabled Flag
 
LOV Oracle
Status
 
LOV Oracle