ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F5151A9E05362FB09050512Y SELECT rar.ben_attribute1||decode(rar.ben_attribute2,NULL,'',' '||rar.ben_attribute2)||' '||rar.ben_attribute3 person_name, rar.person_id, rpa.rep_file_id FROM ben_rep_person_actions rpa, ben_rep_actions ra, ben_rep_archive rar WHERE ra.gre_id = rpa.gre_id AND rar.rep_action_id = ra.rep_action_id AND ra.locking_rep_action_id = rpa.rep_action_id AND rpa.person_id = rar.person_id AND rpa.rec_submission_status = 'E' AND rar.ben_attribute_category = 'PERSONINFO1' AND rpa.gre_id = :P_GRE_ID AND rpa.rep_action_id = :L_REP_ACTION_ID ORDER BY person_name BEN BENACAERR AR BEN المزايا - تقرير أخطاء ACA Imported from BI Publisher Application: المزايا المتقدمة Source: المزايا - تقرير أخطاء ACA Short Name: BENACAERR DB package: D BEN Leistungen - ACA-Fehler Imported from BI Publisher Application: Advanced Benefits Source: Leistungen - ACA-Fehler Short Name: BENACAERR DB package: E BEN Informe Errores de ACA de Beneficios Imported from BI Publisher Application: Advanced Benefits Source: Informe Errores de ACA de Beneficios Short Name: BENACAERR DB package: F BEN Benefits - Etat des erreurs ACA Imported from BI Publisher Application: Advanced Benefits Source: Benefits - Etat des erreurs ACA Short Name: BENACAERR DB package: I BEN Rapporto Errori ACA Benefits Imported from BI Publisher Application: Advanced Benefits Source: Rapporto Errori ACA Benefits Short Name: BENACAERR DB package: JA BEN 福利厚生ACAエラー・レポート Imported from BI Publisher Application: Advanced Benefits Source: 福利厚生ACAエラー・レポート Short Name: BENACAERR DB package: KO BEN 복리후생 ACA 오류 보고서 Imported from BI Publisher Application: Advanced Benefits Source: 복리후생 ACA 오류 보고서 Short Name: BENACAERR DB package: PTB BEN Benefícios ACA - Relatório de Erros Imported from BI Publisher Application: Advanced Benefits Source: Benefícios ACA - Relatório de Erros Short Name: BENACAERR DB package: RU BEN Пособия (ACA): отчет об ошибках Imported from BI Publisher Application: Пособия Source: Пособия (ACA): отчет об ошибках Short Name: BENACAERR DB package: S BEN Felrapport Imported from BI Publisher Application: Advanced Benefits Source: ACA: Felrapport Short Name: BENACAERR DB package: TR BEN Kazançlar ACA Hatalar Raporu Imported from BI Publisher Application: Kazanç Yönetimi Source: Kazançlar ACA Hatalar Raporu Short Name: BENACAERR DB package: US BEN Benefits ACA Errors Imported from BI Publisher Application: Advanced Benefits Source: Benefits ACA Errors Report Short Name: BENACAERR DB package: ZHS BEN 福利 ACA 错误报表 Imported from BI Publisher Application: 高级福利 Source: 福利 ACA 错误报表 Short Name: BENACAERR DB package: BI Publisher :l_rep_action_id :p_gre_id 1 -10 :p_version Number select max(version) from ben_rep_actions ra, ben_rep_files rf where ra.gre_id = :$flex$.gre and ra.year = :$flex$.year and rf.rep_Action_id = ra.locking_rep_action_id and rf.RECEIPT_ID is not null Y AR نسخة الحفظ نسخة الحفظ D Archivversion Archivversion E Archivar Versión Archivar Versión F Version de l'archive Version de l'archive I Versione archivio Versione dell'archivio JA アーカイブ・バージョン アーカイブ・バージョン KO 아카이브 버전 아카이브 버전 PTB Versão do Arquivamento Versão do Arquivamento RU Архивная версия Архивная версия S Arkivversion Arkivversion TR Arşiv Sürümü Arşiv Sürümü US Archive Version Archive Version ZHS 存档版本 存档版本 2 10 :p_year LOV Oracle BEN_ACA_PRINT_YEAR Y select year id, year value, null description from ben_rep_actions bpa1 where bpa1.rowid in (select max(bpa2.rowid) from ben_rep_actions bpa2 where bpa1.year=bpa2.year and bpa1.business_group_id=bpa2.business_group_id) and bpa1.business_group_id=fnd_global.per_business_group_id order by value,description Y AR السنة السنة D Jahr Jahr E Año Año F Année Année I Anno Anno JA 年 年 KO 연도 연도 PTB Ano Ano RU Год Год S År År TR Yıl Yıl US Year Year ZHS 年度 年度 3 20 :p_gre_id LOV Oracle BEN_ACA_PRINT_GRE Y select hou.organization_id id, hou.name value, null description from hr_all_organization_units hou where hou.business_group_id=fnd_global.per_business_group_id and hou.organization_id in (select organization_id from hr_organization_information hoi where hoi.organization_id=hou.organization_id and hoi.org_information_context='CLASS' and hoi.org_information1='HR_LEGAL') and exists (select 1 from ben_rep_actions actn where actn.gre_id=hou.organization_id and actn.action_type='ARCHIVE' and actn.year=:$flex$.ben_aca_print_year) order by value,description Y AR الجهة الحكومية الجهة الحكومية D Meldepflichtiges Unternehmen Meldepflichtiges Unternehmen I Entità fiscale governativa (US) Entità fiscale governativa (US) RU Юридическое лицо Юридическое лицо S Statlig rapp.enhet Statlig rapp.enhet US GRE GRE