ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEED3869E053B46B63588994Y select a.person_id person_id1, pgm.name dpnt_pgm_name, pl.name dpnt_pl_name, opt.name dpnt_opt_name, b.full_name dpnt_name, a.enrt_cvg_strt_dt dpnt_strt_dt, a.enrt_cvg_thru_dt dpnt_thru_dt, b.date_of_birth date_of_birth, HR_GENERAL.DECODE_LOOKUP('CONTACT',a.contact_typ_cd) relationship, HR_GENERAL.DECODE_LOOKUP('STUDENT_STATUS',b.student_status) student_status, hrl3.meaning disability_status from per_all_people_f b, ben_pgm_f pgm, ben_pl_f pl, ben_oipl_f oipl, ben_opt_f opt, hr_lookups hrl3 , ben_batch_dpnt_info a where a.benefit_action_id = :cp_benefit_action_id and a.dpnt_person_id = b.person_id and :cp_process_date between b.effective_start_date and b.effective_end_date and a.pgm_id = pgm.pgm_id(+) and :cp_process_date between nvl(pgm.effective_start_date, :cp_process_date) and nvl(pgm.effective_end_date,:cp_process_date) and a.pl_id = pl.pl_id(+) and :cp_process_date between nvl(pl.effective_start_date, :cp_process_date) and nvl(pl.effective_end_date, :cp_process_date) and a.oipl_id = oipl.oipl_id(+) and :cp_process_date between nvl(oipl.effective_start_date, :cp_process_date) and nvl(oipl.effective_end_date, :cp_process_date) and oipl.opt_id = opt.opt_id(+) and :cp_process_date between nvl(opt.effective_start_date, :cp_process_date) and nvl(opt.effective_end_date,:cp_process_date) and a.actn_cd != 'DEL' and hrl3.lookup_type(+)='YES_NO' and hrl3.lookup_code(+)=b.registered_disabled_flag BEN BENDEAUD_XML AR BEN أرشيف مراجعة جدارة المختار للتعيين (بتنسيق XML) Application: المزايا المتقدمة Source: أرشيف مراجعة جدارة المختار للتعيين (بتنسيق XML) Short Name: BENDEAUD_XML DB package: BEN_BENDEAUD_XMLP_PKG D BEN Prüfprotokoll "Angehörigenberechtigungen" Application: Advanced Benefits Source: Prüfprotokoll "Angehörigenberechtigungen" (XML) Short Name: BENDEAUD_XML DB package: BEN_BENDEAUD_XMLP_PKG F BEN Journal d'audit de l'admissibilité des personnes à charge Application: Advanced Benefits Source: Journal d'audit de l'admissibilité des personnes à charge (XML) Short Name: BENDEAUD_XML DB package: BEN_BENDEAUD_XMLP_PKG US BEN Dependent Eligibility Audit Log Application: Advanced Benefits Source: Dependent Eligibility Audit Log (XML) Short Name: BENDEAUD_XML DB package: BEN_BENDEAUD_XMLP_PKG ZHS BEN 家属资格跟踪日志 Application: 高级福利 Source: 家属资格跟踪日志 (XML) Short Name: BENDEAUD_XML DB package: BEN_BENDEAUD_XMLP_PKG BI Publisher :cp_benefit_action_id :cp_benefit_group :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_location :cp_mode :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_plan :cp_process_date :cp_profile_value :cp_program :cp_start_date :cp_start_time :cp_status :cp_validate :p_conc_request_id :p_concurrent_request_id 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 并发请求编号