ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F5851A9E05362FB09050512Y SELECT plan_name ,pay_perd ,notapplicable ,ptip_ordr_num ,plip_ordr_num ,pl_ordr_num ,oipl_ordr_num ,pretax ,aftertax ,nontaxable ,taxable ,uom ,meaning ,cmcd_val ,bnft_amt ,to_char(enrt_cvg_strt_dt, :P_DATE_MASK) enrt_cvg_strt_dt ,pgm_id pgm_id1 ,pl_id ,oipl_id ,enrt_mthd_cd ,person_id person_id2 ,pl_ordr_num ,oipl_ordr_num ,plip_ordr_num ,ptip_ordr_num FROM ( SELECT pln.name plan_name ,enrt.bnft_amt ,enrt.enrt_cvg_strt_dt ,decode (rt.dsply_on_enrt_flag ,'Y' ,tax_typ.meaning ,'') meaning ,decode (rt.dsply_on_enrt_flag ,'Y' ,rt.cmcd_val ,0) cmcd_val ,enrt.pl_id ,enrt.oipl_id ,enrt.enrt_mthd_cd ,enrt.pgm_id ,enrt.person_id ,enrt.ptip_ordr_num ,enrt.plip_ordr_num ,enrt.pl_ordr_num ,enrt.oipl_ordr_num ,enrt.uom ,ref_perd.meaning pay_perd ,decode (rt.tx_typ_cd ,'PRETAX' ,decode (rt.dsply_on_enrt_flag ,'Y' ,rt.cmcd_val ,0) ,0) pretax ,decode (rt.tx_typ_cd ,'AFTERTAX' ,decode (rt.dsply_on_enrt_flag ,'Y' ,rt.cmcd_val ,0) ,0) aftertax ,decode (rt.tx_typ_cd ,'NONTAXABLE' ,decode (rt.dsply_on_enrt_flag ,'Y' ,rt.cmcd_val ,0) ,0) nontaxable ,decode (rt.tx_typ_cd ,'TAXABLE' ,decode (rt.dsply_on_enrt_flag ,'Y' ,rt.cmcd_val ,0) ,0) taxable ,decode (rt.tx_typ_cd ,'NOTAPPLICABLE' ,decode (rt.dsply_on_enrt_flag ,'Y' ,rt.cmcd_val ,0) ,0) notapplicable ,enrt.ptip_ordr_num ptip ,enrt.plip_ordr_num plip ,enrt.pl_ordr_num pl ,enrt.oipl_ordr_num oipl FROM ben_prtt_enrt_rslt_f enrt ,ben_prtt_enrt_rt_val_v rt ,ben_pl_f pln ,hr_lookups tax_typ ,ben_pl_typ_f pt ,hr_lookups ref_perd ,ben_per_in_ler pil ,ben_ler_f ler WHERE ( enrt.business_group_id = :CP_BUSINESS_GROUP_ID AND enrt.per_in_ler_id = pil.per_in_ler_id AND enrt.person_id = :PERSON_ID1 AND enrt.pgm_id = :PGM_ID AND pil.ler_id = ler.ler_id AND :P_PROCESS_DATE BETWEEN ler.effective_start_date AND ler.effective_end_date AND ler.typ_cd <> 'SCHEDDU' AND rt.business_group_id = enrt.business_group_id AND enrt.prtt_enrt_rslt_id = rt.prtt_enrt_rslt_id AND :P_PROCESS_DATE BETWEEN enrt.enrt_cvg_strt_dt AND enrt.enrt_cvg_thru_dt AND rt.dsply_on_enrt_flag = 'Y' AND :P_PROCESS_DATE BETWEEN pln.effective_start_date AND pln.effective_end_date AND enrt.enrt_cvg_thru_dt <= enrt.effective_end_date AND enrt.prtt_enrt_rslt_stat_cd IS NULL AND enrt.sspndd_flag = 'N' AND pln.pl_id = enrt.pl_id AND rt.rt_strt_dt <= rt.rt_end_dt AND tax_typ.lookup_type = 'BEN_TX_TYP' AND tax_typ.lookup_code = rt.tx_typ_cd AND ref_perd.lookup_type = 'BEN_ENRT_INFO_RT_FREQ' AND ref_perd.lookup_code = rt.cmcd_ref_perd AND pt.pl_typ_id = enrt.pl_typ_id AND pt.opt_typ_cd NOT IN ('CWB','COMP','GSP') AND pt.business_group_id = :CP_BUSINESS_GROUP_ID AND :P_PROCESS_DATE BETWEEN pt.effective_start_date AND pt.effective_end_date ) AND EXISTS ( SELECT 1 FROM ben_acty_base_rt_f abr WHERE rt.acty_base_rt_id = abr.acty_base_rt_id AND :P_PROCESS_DATE BETWEEN abr.effective_start_date AND abr.effective_end_date AND ( ( nvl (abr.rcrrg_cd ,'RCRRG') = 'RCRRG' AND :P_PROCESS_DATE BETWEEN rt.rt_strt_dt AND rt.rt_end_dt ) OR ( abr.rcrrg_cd = 'ONCE' AND rt.rt_end_dt = rt.rt_strt_dt ) ) ) UNION SELECT pln.name plan_name ,enrt.bnft_amt ,enrt.enrt_cvg_strt_dt ,'' meaning ,0 cmcd_val ,enrt.pl_id ,enrt.oipl_id ,enrt.enrt_mthd_cd ,enrt.pgm_id ,enrt.person_id ,enrt.ptip_ordr_num ,enrt.plip_ordr_num ,enrt.pl_ordr_num ,enrt.oipl_ordr_num ,enrt.uom ,NULL pay_perd ,0 pretax ,0 aftertax ,0 nontaxable ,0 taxable ,0 notapplicable ,enrt.ptip_ordr_num ptip ,enrt.plip_ordr_num plip ,enrt.pl_ordr_num pl ,enrt.oipl_ordr_num oipl FROM ben_prtt_enrt_rslt_f enrt ,ben_pl_f pln ,ben_pl_typ_f pt WHERE enrt.business_group_id = :CP_BUSINESS_GROUP_ID AND enrt.person_id = :PERSON_ID1 AND enrt.pgm_id = :PGM_ID AND :P_PROCESS_DATE BETWEEN enrt.enrt_cvg_strt_dt AND enrt.enrt_cvg_thru_dt AND :P_PROCESS_DATE BETWEEN pln.effective_start_date AND pln.effective_end_date AND enrt.enrt_cvg_thru_dt <= enrt.effective_end_date AND enrt.prtt_enrt_rslt_stat_cd IS NULL AND enrt.sspndd_flag = 'N' AND pln.pl_id = enrt.pl_id AND NOT EXISTS ( SELECT prv.prtt_enrt_rslt_id FROM ben_prtt_rt_val prv WHERE prv.business_group_id = enrt.business_group_id AND prv.prtt_enrt_rslt_id = enrt.prtt_enrt_rslt_id AND prv.rt_end_dt >= prv.rt_strt_dt AND prv.prtt_rt_val_stat_cd IS NULL ) AND pt.pl_typ_id = enrt.pl_typ_id AND pt.opt_typ_cd NOT IN ('CWB','COMP','GSP') AND pt.business_group_id = :CP_BUSINESS_GROUP_ID AND :P_PROCESS_DATE BETWEEN pt.effective_start_date AND pt.effective_end_date UNION SELECT pln.name plan_name ,pen.bnft_amt ,pen.enrt_cvg_strt_dt ,tax_typ.meaning meaning ,prv.cmcd_rt_val cmcd_val ,pen.pl_id ,pen.oipl_id ,pen.enrt_mthd_cd ,pen.pgm_id ,pen.person_id ,pen.ptip_ordr_num ,pen.plip_ordr_num ,pen.pl_ordr_num ,pen.oipl_ordr_num ,pen.uom ,ref_perd.meaning pay_perd ,decode (prv.tx_typ_cd ,'PRETAX' ,decode (prv.dsply_on_enrt_flag ,'Y' ,prv.cmcd_rt_val ,0) ,0) pretax ,decode (prv.tx_typ_cd ,'AFTERTAX' ,decode (prv.dsply_on_enrt_flag ,'Y' ,prv.cmcd_rt_val ,0) ,0) aftertax ,decode (prv.tx_typ_cd ,'NONTAXABLE' ,decode (prv.dsply_on_enrt_flag ,'Y' ,prv.cmcd_rt_val ,0) ,0) nontaxable ,decode (prv.tx_typ_cd ,'TAXABLE' ,decode (prv.dsply_on_enrt_flag ,'Y' ,prv.cmcd_rt_val ,0) ,0) taxable ,decode (prv.tx_typ_cd ,'NOTAPPLICABLE' ,decode (prv.dsply_on_enrt_flag ,'Y' ,prv.cmcd_rt_val ,0) ,0) notapplicable ,pen.ptip_ordr_num ptip ,pen.plip_ordr_num plip ,pen.pl_ordr_num pl ,pen.oipl_ordr_num oipl FROM ben_prtt_enrt_rslt_f pen ,ben_pl_f pln ,ben_pl_typ_f pt ,ben_ler_f ler ,ben_per_in_ler pil ,ben_prtt_rt_val prv ,hr_lookups tax_typ ,hr_lookups ref_perd ,ben_acty_base_rt_f abr WHERE pen.per_in_ler_id = pil.per_in_ler_id AND pen.person_id = :PERSON_ID1 AND pen.pgm_id = :PGM_ID AND pil.ler_id = ler.ler_id AND pil.per_in_ler_stat_cd = 'STRTD' AND ler.typ_cd = 'SCHEDDU' AND pen.business_group_id = :CP_BUSINESS_GROUP_ID AND prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id AND :P_PROCESS_DATE BETWEEN prv.rt_strt_dt AND prv.rt_end_dt AND pln.pl_id = pen.pl_id AND :P_PROCESS_DATE BETWEEN pen.enrt_cvg_strt_dt AND pen.enrt_cvg_thru_dt AND :P_PROCESS_DATE BETWEEN pen.effective_start_date AND pen.effective_end_date AND prv.acty_base_rt_id = abr.acty_base_rt_id AND prv.dsply_on_enrt_flag = 'Y' AND :P_PROCESS_DATE BETWEEN abr.effective_start_date AND abr.effective_end_date AND ( ( nvl (abr.rcrrg_cd ,'RCRRG') = 'RCRRG' AND :P_PROCESS_DATE BETWEEN prv.rt_strt_dt AND prv.rt_end_dt ) OR ( abr.rcrrg_cd = 'ONCE' AND prv.rt_strt_dt = prv.rt_strt_dt ) ) AND :P_PROCESS_DATE BETWEEN pln.effective_start_date AND pln.effective_end_date AND pen.prtt_enrt_rslt_stat_cd IS NULL AND pen.sspndd_flag = 'N' AND pt.pl_typ_id = pen.pl_typ_id AND pt.opt_typ_cd NOT IN ('CWB','COMP','GSP') AND pt.business_group_id = :CP_BUSINESS_GROUP_ID AND :P_PROCESS_DATE BETWEEN pt.effective_start_date AND pt.effective_end_date AND tax_typ.lookup_type = 'BEN_TX_TYP' AND tax_typ.lookup_code = prv.tx_typ_cd AND ref_perd.lookup_type = 'BEN_ENRT_INFO_RT_FREQ' AND ref_perd.lookup_code = prv.cmcd_ref_perd_cd ORDER BY ptip ,plip ,pl ,oipl ) BEN BENSMREP_XML AR BEN تقرير ملخص وتأكيد المزايا Imported from BI Publisher Application: المزايا المتقدمة Source: تقرير ملخص وتأكيد المزايا (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG D BEN Leistungen - Bestätigung und Übersicht Imported from BI Publisher Application: Advanced Benefits Source: Leistungen - Bestätigung und Übersicht (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG E BEN Informe Confirmación de Beneficios y Resumen Imported from BI Publisher Application: Advanced Benefits Source: Informe Confirmación de Beneficios y Resumen (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG F BEN Etat de confirmation et de synthèse des avantages Imported from BI Publisher Application: Advanced Benefits Source: Etat de confirmation et de synthèse des avantages (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG I BEN Rapporto Conferma e sintetico benefit Imported from BI Publisher Application: Advanced Benefits Source: Rapporto Conferma e sintetico benefit (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG JA BEN 福利厚生確認および要約レポート Imported from BI Publisher Application: Advanced Benefits Source: 福利厚生確認および要約レポート(XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG KO BEN 복리후생 확인 및 요약 보고서 Imported from BI Publisher Application: Advanced Benefits Source: 복리후생 확인 및 요약 보고서(XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG PTB BEN Relatório Sumariado e Confirmação de Benefícios Imported from BI Publisher Application: Advanced Benefits Source: Relatório Sumariado e Confirmação de Benefícios (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG RU BEN Сводный отчет о подтверждении пособий Imported from BI Publisher Application: Пособия Source: Сводный отчет о подтверждении пособий (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG S BEN Bekräftelse och översikt för förmåner Imported from BI Publisher Application: Advanced Benefits Source: Bekräftelse och översikt för förmåner (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG TR BEN Yan Hak Teyit ve Özet Raporu Imported from BI Publisher Application: Kazanç Yönetimi Source: Yan Hak Teyit ve Özet Raporu (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG US BEN Benefits Confirmation and Summary Imported from BI Publisher Application: Advanced Benefits Source: Benefits Confirmation and Summary Report (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG ZHS BEN 福利确认和汇总报表 Imported from BI Publisher Application: 高级福利 Source: 福利确认和汇总报表 (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG BI Publisher :cp_actn_items_flag :cp_assignment_type :cp_ben_sel_flag :cp_beneficiaries_flag :cp_benefit_action_id :cp_bnfcry_name :cp_bnfcry_rltn :cp_bnfcry_ssn :cp_business_group_id :cp_certifications_flag :cp_comp_selection_rule_id :cp_cov_dpnt_flag :cp_cvg_end_dt :cp_cvg_strt_dt :cp_flx_crdts :cp_flx_sum_flag :cp_interim_cvg :cp_intr_txt :cp_ler_id :cp_lf_evt_ocrd_dt :cp_location_id :cp_misc_opt_name :cp_org_addr1 :cp_org_info :cp_org_name :cp_org_rgn :cp_org_town_city :cp_org_zip :cp_organization_id :cp_person_id :cp_person_selection_rule_id :cp_person_type_id :cp_pgm_id :cp_pl_nip_id :cp_plan_in_pgm_flag :cp_prmy_care_flag :cp_process_date :cp_reporting_group_id :cp_rltp_name1 :cp_rltp_name3 :cp_svc_area_id :p_actn_items_flag :p_assignment_type :p_ben_sel_flag :p_beneficiaries_flag :p_benefit_action_id :p_business_group_id :p_certifications_flag :p_comp_selection_rule_id :p_cov_dpnt_flag :p_cvg_end_dt :p_cvg_strt_dt :p_date_mask :p_effective_date :p_flx_sum_flag :p_ler_id :p_lf_evt_ocrd_dt :p_location_id :p_organization_id :p_person_id :p_person_selection_rule_id :p_person_type_id :p_pgm_id :p_pl_nip_id :p_plan_in_pgm_flag :p_prmy_care_flag :p_process_date :p_reporting_group_id :p_svc_area_id :person_id1 :pgm_id 1 10 :p_effective_date Date select fnd_date.date_to_displaydate(sysdate) from sys.dual US PER_DATES 2 20 :p_benefit_action_id LOV Oracle BEN_BENEFIT_ACTIONS Y select benefit_action_id id, benefit_action_id value, null description from ben_benefit_actions where business_group_id= fnd_global.per_business_group_id order by benefit_action_id AR إجراءات المزايا D Leistungsvorgänge E Acciones de Beneficios F Actions sur les avantages I Azioni benefit JA 福利厚生処理 KO 복리후생 조치 PTB Ações de Benefícios RU Действия пособий S Förmånsåtgärder TR Yan Hak Eylemleri US Benefit Actions ZHS 福利操作 3 30 :p_pgm_id LOV Oracle BEN_PGM Y select pgm_id id, name value, null description from ben_pgm_f a where a.business_group_id= fnd_global.per_business_group_id and a.pgm_typ_cd<>'GSP' and a.effective_start_date=(select max(b.effective_start_date) from ben_pgm_f b where a.pgm_id=b.pgm_id) order by name AR البرنامج D Programm E Programa F Programme I Programma JA プログラム KO 프로그램 PTB Programa RU Программа US Program ZHS 方案 4 40 :p_pl_nip_id LOV Oracle BEN_PL Y select pl_id id, name value, null description from ben_pl_f a where a.business_group_id=fnd_global.per_business_group_id and a.pl_typ_id in (select pl_typ_id from ben_pl_typ_f where opt_typ_cd not in ('CWB','GSP','ABS','ICM')) and a.effective_start_date=(select max(effective_start_date) from ben_pl_f b where b.pl_id=a.pl_id) and not exists(select null from ben_plip_f cpp where cpp.pl_id=a.pl_id) order by name AR خطة ليست في البرنامج D Plan nicht in Programm E Plan Fuera de Programa F Plan hors programme I Piano non in programma JA プログラム外のプラン KO 프로그램에 포함되지 않은 제도 PTB Plano Não Incluso em um Programa RU План вне программы S Plan utanför program TR Programda Olmayan Plan US Plan Not In Program ZHS 计划不在方案中 5 50 :p_organization_id LOV Oracle HR_US_ORGANIZATIONS Y select hou.organization_id id, hou.name value, null description from hr_organization_units hou,hr_organization_information hoi where hou.business_group_id=fnd_global.per_business_group_id and hou.organization_id=hoi.organization_id and hoi.org_information_context='CLASS' and hoi.org_information1='HR_ORG' order by hou.name AR المنشأة D Organisation E Organización F Organisation I Organizzazione JA 組織 KO 조직 PTB Organização RU Организация S Organisation TR Organizasyon US Organization ZHS 组织 6 60 :p_location_id LOV Oracle HR_US_LOCATIONS Y select hl.location_id id, hl.location_code value, null description from hr_locations hl where location_use='HR' order by location_code AR الموقع D Standort E Ubicación F Lieu I Ubicazione JA 事業所 KO 위치 PTB Local RU Расположение S Plats TR Lokasyon US Location ZHS 地点 7 70 :p_person_id LOV Oracle BEN_US_PERSON Y Y select a.person_id id, a.full_name value, null description from per_people_f a where a.business_group_id= fnd_global.per_business_group_id and to_date(:$flex$.per_dates,'YYYY/MM/DD HH24:MI:SS') between a.effective_start_date and a.effective_end_date order by a.last_name,a.first_name AR الشخص E Persona F Personne I Persona JA 個人 KO 개인 PTB Pessoa RU Лицо TR Kişi US Person ZHS 人员 8 80 :p_ler_id LOV Oracle BEN_LER Y select ler_id id, name value, null description from ben_ler_f a where a.business_group_id=fnd_global.per_business_group_id and a.typ_cd not in ('GSP','ABS','COMP','IREC') and a.effective_start_date=(select max(b.effective_start_date) from ben_ler_f b where a.ler_id=b.ler_id) order by name AR سبب حدث العمر D Veränderungsgrund E Motivo de Evento Personal F Motif de l'événement personnel I Motivo evento vita JA ライフ・イベント理由 KO Life Event 발생 사유 PTB Motivo do Evento de Vida RU Основание жизненного события S Livshändelseorsak TR Önemli Kişisel Olay Nedeni US Life Event Reason ZHS 人生事件原因 9 90 :p_lf_evt_ocrd_dt Date US p_lf_evt_ocrd_dt 10 100 :p_person_selection_rule_id LOV Oracle BEN_PERSON_SELECTION_RULE Y select formula_id id, formula_name value, null description from ff_formulas_f a where a.business_group_id= fnd_global.per_business_group_id and a.formula_type_id=-214 and a.effective_start_date=(select max(b.effective_start_date) from ff_formulas_f b where a.formula_id=b.formula_id) order by formula_name AR قاعدة تحديد الشخص D Auswahlregel Person E Regla de Selección de Personas F Règle de sélection de personne I Regola selezione persona JA 個人選択ルール KO 개인 선택 규칙 PTB Regra de Seleção da Pessoa RU Правило выбора лица S Urvalsregel för person TR Kişi Seçim Kuralı US Person Selection Rule ZHS 人员选择规则 11 110 :p_comp_selection_rule_id LOV Oracle BEN_COMP_SELECTION_RULE Y select formula_id id, formula_name value, null description from ff_formulas_f a where a.business_group_id= fnd_global.per_business_group_id and a.effective_start_date=(select max(b.effective_start_date) from ff_formulas_f b where a.formula_id=b.formula_id) and a.formula_type_id=-213 order by formula_name AR قاعدة تحديد التعويضات D Auswahlregel Vergütung E Regla de Selección de Compensación F Règle de sélection de rémunération I Regola selezione retribuzione JA 報酬選択ルール KO 보상 선택 규칙 PTB Regra de Seleção de Remuneração RU Правило выбора компенсации S Urvalsregel för ersättning TR Teşviklendirme Seçim Kuralı US Compensation Selection Rule ZHS 报酬选择规则 12 120 :p_business_group_id Number AR مجموعة الأعمال D Unternehmensgruppe E Grupo de Trabajo F Entité professionnelle I Business group JA ビジネス・グループ KO 업무 그룹 PTB Grupo Funcional RU Бизнес-группа S Verksamhetsgrupp TR İş Grubu US Business Group ZHS 业务组 13 130 :p_plan_in_pgm_flag LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description AR الخطة في البرنامج D Plan in Programm E Plan en Programa F Plan du programme I Piano in programma JA プログラム内のプラン KO 프로그램에 포함된 제도 PTB Plano no Programa RU План в программе S Plan i program TR Programdaki Plan US Plan In Program ZHS 计划在方案中 14 140 :p_person_type_id LOV Oracle BEN_PERSON_TYPES Y select person_type_id id, user_person_type value, null description from per_person_types where business_group_id= fnd_global.per_business_group_id and active_flag='Y' order by user_person_type AR نوع الشخص D Personenart E Tipo de Persona F Type de personne I Tipo persona JA Personタイプ KO 개인 유형 PTB Tipo de Pessoa RU Тип лица S Persontyp TR Kişi Tipi US Person Type ZHS 人员类型 15 150 :p_reporting_group_id Number AR مجموعة إعداد التقارير D Auswertungsgruppe E Grupo de Informes F Groupe de reporting I Gruppo generazione rapporti JA レポート・グループ KO 보고 그룹 PTB Grupo de Geração de Relatório RU Группа отчетности S Rapporteringsgrupp TR Raporlama Grubu US Reporting Group ZHS 报告组 16 160 :p_svc_area_id Number AR منطقة الخدمة D Servicegebiet E Área de Servicio F Zone de service I Area di servizi JA サービス区域 KO 서비스 대상 지역 PTB Área de Serviço RU Район обслуживания S Tjänsteområde TR Hizmet Alanı US Service Area ZHS 服务区域 17 170 :p_assignment_type LOV Oracle PER_PRIMARY_ASG_STATUS_TYPES Y select a.assignment_status_type_id id, nvl(b.user_status,a.user_status) value, null description from per_assignment_status_types_v a,per_ass_status_type_amends b,per_business_groups c where b.assignment_status_type_id(+)= a.assignment_status_type_id and b.business_group_id(+)= fnd_global.per_business_group_id and nvl(a.business_group_id ,fnd_global.per_business_group_id) =fnd_global.per_business_group_id and nvl(a.legislation_code,c.legislation_code) =c.legislation_code and a.per_system_status in ('ACCEPTED','ACTIVE_APL','OFFER','TERM_ASSIGN', 'ACTIVE_ASSIGN','SUSP_ASSIGN') and c.business_group_id= fnd_global.per_business_group_id order by nvl(b.user_status,a.user_status) AR نوع التخصيص D Stellenart E Tipo de Asignación F Type d'affectation I Tipo assegnazione JA アサイメント・タイプ KO 발령 유형 PTB Tipo de Atribuição RU Тип назначения S Uppdragstyp TR Atama Tipi US Assignment Type ZHS 分配类型 18 180 :p_cvg_strt_dt Date AR تاريخ بداية التغطية D Deckungsbeginn E Fecha de Inicio de Cobertura F Date de début de la couverture I Data inizio copertura JA 補償範囲開始日 KO 수혜 범위 시작 일자 PTB Data Inicial da Cobertura RU Начальная дата обеспечения S Startdatum för försäkring TR Kapsam Başlangıç Tarihi US Coverage Start Date ZHS 保险起始日期 19 190 :p_cvg_end_dt Date AR تاريخ نهاية التغطية D Deckungsende E Fecha de Finalización de Cobertura F Date de fin de la couverture I Data fine copertura JA 補償範囲終了日 KO 수혜 범위 종료 일자 PTB Data Final da Cobertura RU Конечная дата обеспечения S Slutdatum för försäkring TR Kapsam Bitiş Tarihi US Coverage End Date ZHS 保险终止日期 20 200 :p_ben_sel_flag LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) AR تحديد المزايا D Leistungsauswahl E Selección de Beneficios F Sélection d'avantages I Selezione benefit JA 福利厚生選択 KO 복리후생 선택 PTB Seleção de Benefícios RU Выбор пособий S Förmånsurval TR Yan Hak Seçimi US Benefits Selection ZHS 福利选择 21 210 :p_flx_sum_flag LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) AR ملخص الائتمانات المرنة D FlexFeld-Übersicht E Resumen de Estructura F Synthèse des crédits variables I Sintetico crediti flessibili JA フレックス要約 KO 선택적 요약 PTB Sumário Flex RU Сводка гибких кредитов S Flexfältsöversikt TR Esnek Özet US Flex Summary ZHS 弹性汇总 22 220 :p_cov_dpnt_flag LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) AR المُعال ذو التغطية D Leistungsberechtigter Angehöriger E Dependiente Cubierto F Personne à charge couverte I Familiare coperto JA 補償扶養家族 KO 적용된 수혜대상가족 PTB Dependente Coberto RU Обеспечиваемый иждивенец S Medförsäkrad TR Kapsanan Bakmakla Yükümlü Olunan Kişiler US Covered Dependent ZHS 投保的受抚养者 23 230 :p_prmy_care_flag LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) AR الرعاية الأساسية D Erstbehandelnder Arzt E Atención Primaria F Principal prestataire de soins I Assistenza principale JA 主治医 KO 1차 의료 기관 PTB Assistência Médica Principal RU Основное лечебное S Primärvård TR Temel Sağlık Hizmeti US Primary Care ZHS 主要保健人员 24 240 :p_beneficiaries_flag LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) AR المستفيدون D Begünstigte E Beneficiarios F Bénéficiaires I Beneficiari JA 受取人 KO 수혜자 PTB Beneficiários RU Бенефициары S Förmånstagare TR Hak Sahipleri US Beneficiaries ZHS 受益人 25 250 :p_certifications_flag LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) AR الشهادات D Bescheinigungen E Certificaciones F Certificats I Certificazioni JA 証明 KO 증빙 PTB Certificações RU Сертификация S Intyg TR Sertifikasyonlar US Certifications ZHS 证明 26 260 :p_actn_items_flag LOV Oracle HR_US_YES_NO Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='YES_NO' order by value,description select meaning from hr_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) AR بنود الإجراءات D Angaben E Elementos de Acción F Eléments d'action I Elementi azione JA 処理項目 KO 조치 항목 PTB Itens da Ação RU Элементы действия S Åtgärdspunkter TR Eylem Öğeleri US Action Items ZHS 操作项 27 270 :debugflag Char N AR علامة معالجة الأخطاء D Debug-Kennzeichen E Depuración F Indicateur Diagnostic I Flag Debug JA デバッグ・フラグ KO 디버그 플래그 PTB Indicador de Depuração RU Флаг отладки S Felsökning TR Hata Ayıklama İşareti US Debug Flag ZHS 调试标志