PAY Functional Area
Description
Categories: BI Publisher
Application: Payroll
Source: Functional Area Report (XML)
Short Name: PAYRPFAR_XML
DB package: PAY_PAYRPFAR_XMLP_PKG
Source: Functional Area Report (XML)
Short Name: PAYRPFAR_XML
DB package: PAY_PAYRPFAR_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 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 | |
---|---|---|---|
Status |
|
LOV Oracle | |
Dynamic Trigger Enabled Flag |
|
LOV Oracle |