ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEF83869E053B46B63588994 select DISTINCT rpt.person_id person_idm2, nvl(pgm.name, '-----') pgm_name, pl.name pl_name, opt.name opt_name, plt.name pl_typ_name, org.name provider_name, apr.organization_id provider_idm1, rpt.pl_id from ben_reporting rpt, ben_pgm_f pgm, ben_pl_f pl, ben_oipl_f oipl, ben_opt_f opt, ben_pl_typ_f plt, ben_actl_prem_f apr, hr_all_organization_units_vl org where rpt.benefit_action_id = :CP_BENEFIT_ACTION_ID and rpt.actl_prem_id = apr.actl_prem_id and :CP_REQ_PROCESS_DATE between apr.effective_start_date and apr.effective_end_date and apr.organization_id = org.organization_id(+) and :CP_REQ_PROCESS_DATE between nvl(pgm.effective_start_date, :CP_REQ_PROCESS_DATE) and nvl(pgm.effective_end_date, :CP_REQ_PROCESS_DATE) and rpt.pgm_id = pgm.pgm_id(+) and rpt.pl_id = pl.pl_id(+) and :CP_REQ_PROCESS_DATE between nvl(pl.effective_start_date, :CP_REQ_PROCESS_DATE) and nvl(pl.effective_end_date, :CP_REQ_PROCESS_DATE) and rpt.oipl_id = oipl.oipl_id(+) and :CP_REQ_PROCESS_DATE between nvl(oipl.effective_start_date, :CP_REQ_PROCESS_DATE) and nvl(oipl.effective_end_date,:CP_REQ_PROCESS_DATE) and rpt.pl_typ_id = plt.pl_typ_id(+) and :CP_REQ_PROCESS_DATE between nvl(plt.effective_start_date, :CP_REQ_PROCESS_DATE) and nvl(plt.effective_end_date,:CP_REQ_PROCESS_DATE) and oipl.opt_id = opt.opt_id(+) and :CP_REQ_PROCESS_DATE between nvl(opt.effective_start_date, :CP_REQ_PROCESS_DATE) and nvl(opt.effective_end_date,:CP_REQ_PROCESS_DATE) and rpt.person_id=:person_id1 Y BEN BENPRDEA_XML AR BEN أرشيف مراجعة احتساب القسط (بتنسيق XML) Application: المزايا المتقدمة Source: أرشيف مراجعة احتساب القسط (بتنسيق XML) Short Name: BENPRDEA_XML DB package: BEN_BENPRDEA_XMLP_PKG D BEN Prüfprotokoll "Prämienberechnung" Application: Advanced Benefits Source: Prüfprotokoll "Prämienberechnung" (XML) Short Name: BENPRDEA_XML DB package: BEN_BENPRDEA_XMLP_PKG F BEN Journal d'audit des calculs de prime Application: Advanced Benefits Source: Journal d'audit des calculs de prime (XML) Short Name: BENPRDEA_XML DB package: BEN_BENPRDEA_XMLP_PKG US BEN Premium Calculation Audit Log Application: Advanced Benefits Source: Premium Calculation Audit Log (XML) Short Name: BENPRDEA_XML DB package: BEN_BENPRDEA_XMLP_PKG ZHS BEN 计算保费跟踪日志 Application: 高级福利 Source: 计算保费跟踪日志 (XML) Short Name: BENPRDEA_XML DB package: BEN_BENPRDEA_XMLP_PKG BI Publisher :cp_benefit_action_id :cp_business_group :cp_comp_object_selection_rule :cp_concurrent_program_name :cp_elapsed_time :cp_end_date :cp_end_time :cp_legal_entity :cp_mode :cp_organization :cp_person :cp_person_selection_rule :cp_persons_errored :cp_persons_processed :cp_persons_processed_succ :cp_persons_selected :cp_persons_unprocessed :cp_plan :cp_plan_type :cp_process_date :cp_program :cp_req_process_date :cp_start_date :cp_start_time :cp_status :cp_validate :p_conc_request_id :p_concurrent_request_id :person_id1 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 并发请求编号