ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F5051A9E05362FB09050512 SELECT ppf.first_name ,ppf.last_name ,ppf.employee_number ,hr_person_type_usage_info.get_user_person_type(trunc(:P_EFFECTIVE_DATE),person_id) user_person_type FROM per_all_people_f ppf WHERE ppf.person_id IN ( SELECT person_id FROM ben_rep_archive rep WHERE rep_action_id = :P_REP_ACTION_ID AND ben_attribute_category = '1SERIES' AND NOT EXISTS ( SELECT 1 FROM ben_per_cm_f pcm WHERE rep.person_id = pcm.person_id AND pcm.cm_typ_id = :P_CM_TYP_ID AND rep.business_group_id = pcm.business_group_id AND trunc(:P_EFFECTIVE_DATE) BETWEEN pcm.effective_start_date AND pcm.effective_end_date ) ) AND trunc(:P_EFFECTIVE_DATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date order by ppf.person_id Y BEN BEN1095PRINTPRSNS AR BEN المزايا - قانون الرعاية الميسرة - النماذج المطبوعة لتقرير 1095C للأشخاص Imported from BI Publisher Application: المزايا المتقدمة Source: المزايا - قانون الرعاية الميسرة - النماذج المطبوعة لتقرير 1095C للأشخاص Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG D BEN Leistungen - Personen für gedruckte ACA-Formulare 1095C Imported from BI Publisher Application: Advanced Benefits Source: Leistungen - Personen für gedruckte ACA-Formulare 1095C Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG E BEN Informe de Personas de ACA de Beneficios para Impresión de Formularios 1095C Imported from BI Publisher Application: Advanced Benefits Source: Informe de Personas de ACA de Beneficios para Impresión de Formularios 1095C Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG F BEN Benefits - ACA - Etat des personnes pour les formulaires imprimés 1095C Imported from BI Publisher Application: Advanced Benefits Source: Benefits - ACA - Etat des personnes pour les formulaires imprimés 1095C Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG I BEN Rapporto persone benefit ACA per moduli stampati 1095C Imported from BI Publisher Application: Advanced Benefits Source: Rapporto persone benefit ACA per moduli stampati 1095C Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG JA BEN 福利厚生ACA 1095C印刷済フォームの個人レポート Imported from BI Publisher Application: Advanced Benefits Source: 福利厚生ACA 1095C印刷済フォームの個人レポート Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG KO BEN 1095C 인쇄 양식에 대한 복리후생 ACA 개인 보고서 Imported from BI Publisher Application: Advanced Benefits Source: 1095C 인쇄 양식에 대한 복리후생 ACA 개인 보고서 Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG PTB BEN Benefícios - Relatório de Pessoas ACA dos Forms Impressos 1095C Imported from BI Publisher Application: Advanced Benefits Source: Benefícios - Relatório de Pessoas ACA dos Forms Impressos 1095C Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG RU BEN Пособия (ACA): отчет о лицах для печатных форм 1095C Imported from BI Publisher Application: Пособия Source: Пособия (ACA): отчет о лицах для печатных форм 1095C Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG S BEN Personrapport för utskrivna 1095C-formulär Imported from BI Publisher Application: Advanced Benefits Source: ACA: Personrapport för utskrivna 1095C-formulär Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG TR BEN 1095C Basılı Formları İçin Kazançlar ACA Kişi Raporu Imported from BI Publisher Application: Kazanç Yönetimi Source: 1095C Basılı Formları İçin Kazançlar ACA Kişi Raporu Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG US BEN Benefits ACA Persons Report for 1095C Printed Forms Imported from BI Publisher Application: Advanced Benefits Source: Benefits ACA Persons Report for 1095C Printed Forms Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG ZHS BEN 1095C 打印表单的福利 ACA 人员报表 Imported from BI Publisher Application: 高级福利 Source: 1095C 打印表单的福利 ACA 人员报表 Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG BI Publisher :cp_business_group :cp_org_name :p_business_group_id :p_cm_typ_id :p_effective_date :p_gre_id :p_rep_action_id :p_year 1 -10 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR معرف مجموعة الأعمال معرف مجموعة الأعمال D Kennung Unternehmensgruppe Kennung Unternehmensgruppe E Id Grupo de Trabajo Id Grupo de Trabajo F ID entité professionnelle ID entité professionnelle I Id business group Id del business group JA ビジネス・グループID ビジネス・グループID KO 업무 그룹 ID 업무 그룹 ID PTB Id do Grupo Funcional Id do Grupo Funcional RU Идентификатор бизнес-группы Идентификатор бизнес-группы S Id för verksamhetsgrupp Id för verksamhetsgrupp TR İş Grubu No İş Grubu No US Business Group ID Business Group ID 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 Meldungsjahr Meldungsjahr E Año del Informe Año del Informe F Année de déclaration Année de déclaration I Anno generazione rapporto Anno di generazione rapporto JA レポート年度 レポート年度 KO 보고 연도 보고 연도 PTB Ano para Geração de Relatório Ano para Geração de Relatório RU Отчетный год Отчетный год S Rapportår Rapportår TR Raporlama Yılı Raporlama Yılı US Reporting Year Reporting 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 F Administration déclarante (GRE) Administration déclarante (GRE) I Entità fiscale governativa (US) Entità fiscale governativa (US) RU Юридическое лицо Юридическое лицо S Statlig rapp.enhet Statlig rapp.enhet US GRE GRE 4 30 :p_effective_date Date Y AR تاريخ الفعالية تاريخ الفعالية D Gültigkeitsdatum Gültigkeitsdatum E Fecha en Vigor Fecha en Vigor F Date de validité Date de validité I Data validità Data di validità JA 有効日 有効日 KO 유효 일자 유효 일자 PTB Data Efetivação Data Efetivação RU Дата действия Дата действия S Giltighetsdatum Giltighetsdatum TR Geçerli Tarih Geçerli Tarih US Effective Date Effective Date ZHS 有效日期 有效日期 :$flex$.ben_aca_print_year Reporting Year GRE