ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEEF3869E053B46B63588994Y select a.person_id, pgm.name dd_pgm_name, pl.name dd_pl_name, opt.name dd_opt_name, b.full_name dd_dpnt_name, a.enrt_cvg_strt_dt dd_dpnt_strt_dt, a.enrt_cvg_thru_dt dd_dpnt_thru_dt, pgm.name || ' - ' || pl.name || ' - ' || opt.name comp_name from ben_batch_dpnt_info a, per_people_f b, ben_benefit_actions c, ben_pgm_f pgm, ben_pl_f pl, ben_oipl_f oipl, ben_opt_f opt where c.request_id = :P_CONCURRENT_REQUEST_ID and c.benefit_action_id = a.benefit_action_id and a.dpnt_person_id = b.person_id and c.process_date between b.effective_start_date and b.effective_end_date and a.pgm_id = pgm.pgm_id(+) and c.process_date between nvl(pgm.effective_start_date, c.process_date) and nvl(pgm.effective_end_date,c.process_date) and a.pl_id = pl.pl_id(+) and c.process_date between nvl(pl.effective_start_date, c.process_date) and nvl(pl.effective_end_date,c.process_date) and a.oipl_id = oipl.oipl_id(+) and c.process_date between nvl(oipl.effective_start_date, c.process_date) and nvl(oipl.effective_end_date,c.process_date) and oipl.opt_id = opt.opt_id(+) and c.process_date between nvl(opt.effective_start_date, c.process_date) and nvl(opt.effective_end_date,c.process_date) and a.actn_cd = 'DEL' and a.person_id=:person_id5 and pgm.name || ' - ' || pl.name || ' - ' || opt.name=:comp_name_M2 BEN BENDFAUD_XML AR BEN أرشيف مراجعة التسجيل الافتراضي (بتنسيق XML) Application: المزايا المتقدمة Source: أرشيف مراجعة التسجيل الافتراضي (بتنسيق XML) Short Name: BENDFAUD_XML DB package: BEN_BENDFAUD_XMLP_PKG D BEN Prüfprotokoll "Standardanmeldungen" Application: Advanced Benefits Source: Prüfprotokoll "Standardanmeldungen" (XML) Short Name: BENDFAUD_XML DB package: BEN_BENDFAUD_XMLP_PKG F BEN Journal d'audit des souscriptions par défaut Application: Advanced Benefits Source: Journal d'audit des souscriptions par défaut (XML) Short Name: BENDFAUD_XML DB package: BEN_BENDFAUD_XMLP_PKG US BEN Default Enrollment Audit Log Application: Advanced Benefits Source: Default Enrollment Audit Log (XML) Short Name: BENDFAUD_XML DB package: BEN_BENDFAUD_XMLP_PKG ZHS BEN 默认登记跟踪日志 Application: 高级福利 Source: 默认登记跟踪日志 (XML) Short Name: BENDFAUD_XML DB package: BEN_BENDFAUD_XMLP_PKG BI Publisher :comp_name_m2 :cp_audit_log :cp_benefit_group :cp_business_group :cp_concurrent_program_name :cp_elapsed_time :cp_end_date :cp_end_time :cp_enrollment_type_cycle :cp_legal_entity :cp_location :cp_organization :cp_payroll :cp_person :cp_person_selection_rule :cp_person_type :cp_persons_errored :cp_persons_processed :cp_persons_processed_succ :cp_persons_selected :cp_persons_unprocessed :cp_process_date :cp_start_date :cp_start_time :cp_status :cp_validate :p_conc_request_id :p_concurrent_request_id :person_id5 1 10 :p_concurrent_request_id LOV Oracle BEN_BATCH_REQUESTS Y select request_id id, request_id value, null description from ben_benefit_actions where business_group_id= fnd_global.per_business_group_id order by request_id Y AR معرف طلب التزامن D Hintergrundprozess-Nr. F Numéro du traitement simultané US Concurrent Request ID ZHS 并发请求编号