ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2FC3869E053B46B63588994 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 Y PAY PAYRPFAR_XML AR PAY تقرير المنطقة الأساسية (بتنسيق XML) Application: كشوف الرواتب Source: تقرير المنطقة الأساسية (بتنسيق XML) Short Name: PAYRPFAR_XML DB package: PAY_PAYRPFAR_XMLP_PKG D PAY Funktionsbereiche Application: Lohn und Gehalt Source: Funktionsbereiche (XML) Short Name: PAYRPFAR_XML DB package: PAY_PAYRPFAR_XMLP_PKG F PAY Etat Activités fonctionnelles Application: Payroll Source: Etat Activités fonctionnelles (XML) Short Name: PAYRPFAR_XML DB package: PAY_PAYRPFAR_XMLP_PKG US PAY Functional Area Application: Payroll Source: Functional Area Report (XML) Short Name: PAYRPFAR_XML DB package: PAY_PAYRPFAR_XMLP_PKG ZHS PAY 功能区报表 Application: 工资单 Source: 功能区报表 (XML) Short Name: PAYRPFAR_XML DB package: PAY_PAYRPFAR_XMLP_PKG BI Publisher :cp_count_short_name :cp_enabled_flag :cp_status :p_conc_request_id :p_enabled_flag :p_status 1 10 :p_status LOV Oracle PAY_SRS_TRIGGER_STATUS_TSR Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='TRIGGER_STATUS' order by value,description select meaning from hr_lookups where lookup_type = 'TRIGGER_STATUS' and lookup_code = 'DISABLED' Y AR الحالة F Statut US Status ZHS 状态 2 20 :p_enabled_flag LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR علامة تمكين الزناد الديناميكي D Dynamischer Trigger aktiviert F Indicateur Déclencheur dynamique activé US Dynamic Trigger Enabled Flag ZHS 动态触发器启用标志