ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F5451A9E05362FB09050512 select count(*) LER_CLOSED_AMOUNT, ler.name LER_CLOSED_NAME from ben_batch_ler_info bli, ben_benefit_actions bft, ben_ler_f ler, ben_person_actions bpa where bft.benefit_action_id = bli.benefit_action_id and bft.request_id = :P_CONCURRENT_REQUEST_ID and bli.ler_id=ler.ler_id and bft.process_date between ler.effective_start_date and ler.effective_end_date and (bli.open_and_clsd_flag='Y' or bli.clsd_flag='Y') and bpa.benefit_action_id = bli.benefit_action_id and bpa.person_id = bli.person_id and bpa.action_status_cd <> 'E' group by ler.name union select null,null from dual Y BEN BENERRPA AR BEN مخرجات تقارير عملية المشاركة (بتنسيق XML) Imported from BI Publisher Application: المزايا المتقدمة Source: مخرجات تقارير عملية المشاركة (بتنسيق XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG D BEN Berechtigungsprüfungen - Ausgabe Imported from BI Publisher Application: Advanced Benefits Source: Berechtigungsprüfungen - Ausgabe (XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG E BEN Salida de Informes de Proceso de Participación Imported from BI Publisher Application: Advanced Benefits Source: Salida de Informes de Proceso de Participación (XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG F BEN Sortie des états des traitements de participation Imported from BI Publisher Application: Advanced Benefits Source: Sortie des états des traitements de participation (XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG I BEN Output rapporti processo partecipazione Imported from BI Publisher Application: Advanced Benefits Source: Output rapporti processo partecipazione (XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG JA BEN 加入プロセス・レポート出力 Imported from BI Publisher Application: Advanced Benefits Source: 加入プロセス・レポート出力(XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG KO BEN 가입 프로세스 보고서 출력 Imported from BI Publisher Application: Advanced Benefits Source: 가입 프로세스 보고서 출력(XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG PTB BEN Saída dos Relatórios do Processo de Participação Imported from BI Publisher Application: Advanced Benefits Source: Saída dos Relatórios do Processo de Participação (XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG RU BEN Выходные данные отчета о процессе участия Imported from BI Publisher Application: Пособия Source: Выходные данные отчета о процессе участия (XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG S BEN Utdata i rapporter för deltagandeprocess Imported from BI Publisher Application: Advanced Benefits Source: Utdata i rapporter för deltagandeprocess (XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG TR BEN Katılım İşlem Raporları Çıktısı Imported from BI Publisher Application: Kazanç Yönetimi Source: Katılım İşlem Raporları Çıktısı (XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG US BEN Participation Process Reports Output Imported from BI Publisher Application: Advanced Benefits Source: Participation Process Reports Output(XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG ZHS BEN 参与流程报表输出 Imported from BI Publisher Application: 高级福利 Source: 参与流程报表输出 (XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG BI Publisher :cp_age_changed :cp_audit_flag :cp_business_group :cp_comb_age_los_changed :cp_comp_lvl_changed :cp_comp_object_selection_rule :cp_concurrent_program_name :cp_cr_opn_cls :cp_derivable_factors :cp_elapsed_time :cp_eligibility_profile :cp_end_date :cp_end_time :cp_enrollment_type_cycle :cp_hrs_wkd_changed :cp_just_programs :cp_late_payment :cp_legal_entity :cp_life_event_choices :cp_life_event_closed :cp_life_event_collapsed :cp_life_event_collision :cp_life_event_created :cp_life_event_dsgn_only :cp_life_event_no_effect :cp_life_event_open_and_closed :cp_life_event_reason :cp_life_event_replaced :cp_life_event_rt_pr_chg :cp_life_event_still_active :cp_lmt_by_org_flag :cp_location :cp_los_changed :cp_loss_of_eligibility :cp_max_enrollment_rchd :cp_mode :cp_no_change_to_life :cp_no_life_event_created :cp_number_of_events_created :cp_option :cp_organization :cp_payroll :cp_period_enroll_changed :cp_person :cp_person_bnft_grp :cp_person_selection_rule :cp_person_type :cp_persons_errored :cp_persons_errored_temporal :cp_persons_no_potential :cp_persons_processed :cp_persons_processed_succ :cp_persons_processed_succ_t :cp_persons_selected :cp_persons_selected_temporal :cp_persons_unprocessed :cp_persons_unprocessed_temp :cp_persons_with_potential :cp_pft_changed :cp_plan :cp_plan_type :cp_plans_not_in_programs :cp_postal_zip_range :cp_process_date :cp_program :cp_reporting_group :cp_start_date :cp_start_time :cp_status :cp_temp_text :cp_tot_errors :cp_tot_warnings :cp_total_closed :cp_validate :cp_variable_rate_profile :cp_voulntary_end_cvg :cp_waiting_satisfied :cp_with_active_life_event :cp_without_active_life_event :p_benefit_action_id :p_concurrent_request_id :p_date_mask :run_mode 1 10 :p_concurrent_request_id Number AR معرف طلب التزامن D Hintergrundprozess-Nr. E Id Solicitud Simultánea F Numéro du traitement simultané I Id richiesta concorrente JA コンカレント要求ID KO 동시작업 요청 ID PTB ID da Solicitação Concorrente RU Идентификатор параллельного запроса S Begäran-id TR Eşzamanlı Talep no US Concurrent Request id ZHS 并发请求编号 2 20 :p_benefit_action_id Number AR معرف إجراء المزايا D Kennung Leistungsvorgang E Id Acción de Beneficio F ID action sur les avantages I Id azione benefit JA 福利厚生処理ID KO 복리후생 조치 ID PTB ID da Ação do Benefício RU Идентификатор действия пособия S Förmånsåtgärds-id TR Kazanç Eylemi no US Benefit Action id ZHS 福利活动标识