ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F5751A9E05362FB09050512Y select pl_oraganization_name, pl_location_name, pl_payroll_name , pl_full_name, pl_national_identifier, pl_bnft_amount , pl_prem_val, pl_sql_uom, pl_period_type, sum(ee_ptax_rt_val) , sum(ee_atax_rt_val) , sum(er_rt_val ), sum(ee_ptax_rt_val + ee_atax_rt_val + er_rt_val) pay_perd_total1, sum(ee_ptax_elem_val) , sum(ee_atax_elem_val) , sum(er_elem_val ), sum(ee_ptax_elem_val + ee_atax_elem_val + er_elem_val) actual_total1, BEN_BENRECON_XMLP_PKG.cf_dsicrepencyformula(sum ( ee_ptax_rt_val + ee_atax_rt_val + er_rt_val ), sum ( ee_ptax_elem_val + ee_atax_elem_val + er_elem_val ), pl_prem_val, pl_sql_uom) CF_DSICREPENCY from ( select distinct pen.prtt_enrt_rslt_id , hr_general.decode_organization(asg.organization_id) pl_oraganization_name ,hr_general.decode_location(asg.location_id) pl_location_name ,pay.payroll_name pl_payroll_name ,decode(:p_emp_name_format,'JP',( per.last_name || ' ' || per.first_name || ' / ' || per.per_information18 || ' ' || per.per_information19) , per.full_name) pl_full_name ,per.national_identifier pl_national_identifier ,pen.bnft_amt pl_bnft_amount ,mpr.val pl_prem_val ,nvl(mpr.uom , pen.uom) pl_sql_uom ,pay.period_type pl_period_type ,pds.period_name pl_period_name ,to_char(pds.start_date,'MM/DD')|| ' - '|| to_char(pds.end_date,'MM/DD') pl_pay_prd ,ben_recn_rep.get_rate_val(pen.prtt_enrt_rslt_id,pds.end_date,:p_business_group_id,'PRETAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_ptax_rt_val ,ben_recn_rep.get_rate_val(pen.prtt_enrt_rslt_id,pds.end_date,:p_business_group_id,'AFTERTAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_atax_rt_val ,ben_recn_rep.get_rate_val(pen.prtt_enrt_rslt_id,pds.end_date,:p_business_group_id,null,'ERC',pen.per_in_ler_id, pds.end_date) er_rt_val ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,:p_business_group_id,'PRETAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_ptax_elem_val ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,:p_business_group_id,'AFTERTAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_atax_elem_val ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,:p_business_group_id,null,'ERC',pen.per_in_ler_id, pds.end_date) er_elem_val from ben_prtt_enrt_rslt_f pen ,ben_actl_prem_f acp ,ben_prtt_prem_f prm ,ben_prtt_prem_by_mo_f mpr ,ben_per_in_ler pil ,per_all_people_f per ,per_person_types ptp ,pay_all_payrolls_f pay ,per_time_periods pds ,per_all_assignments_f asg where :p_dsply_recn = 'Y' and pen.pl_id = :p_pl_id and (pen.pgm_id = :p_pgm_id or :p_pgm_id is null) and pen.prtt_enrt_rslt_stat_cd is null and pen.business_group_id = :p_business_group_id and pen.enrt_cvg_thru_dt >= pen.effective_end_date and (:p_report_start_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt or :p_report_end_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt or (:p_report_start_date >= pen.enrt_cvg_strt_dt and :p_report_end_date <= pen.enrt_cvg_thru_dt) or (:p_report_start_date <= pen.enrt_cvg_strt_dt and :p_report_end_date >= pen.enrt_cvg_thru_dt)) and ((pen.effective_end_date < pen.enrt_cvg_thru_dt and (:p_report_start_date between pen.effective_start_date and pen.effective_end_date or :p_report_end_date between pen.effective_start_date and pen.effective_end_date or (:p_report_start_date >= pen.effective_start_date and :p_report_end_date <= pen.effective_end_date) or (:p_report_start_date <= pen.effective_start_date and :p_report_end_date >= pen.effective_end_date))) or pen.effective_end_date >= pen.enrt_cvg_thru_dt ) and pen.sspndd_flag = 'N' and pen.per_in_ler_id = pil.per_in_ler_id and pil.per_in_ler_stat_cd not in ( 'VOIDD' , 'BCKDT') and pil.person_id = per.person_id and ptp.person_type_id = per.person_type_id and ptp.system_person_type IN ( 'EMP' ,'EX_EMP','EMP_APL','EX_EMP_APL', 'PRTN' ) and (:p_person_id is null or pen.person_id = :p_person_id) and (:p_per_sel_rule is null or pen.person_id in (select person_id from ben_person_actions pac where pac.benefit_action_id = :p_benefit_action_id) ) and (:p_ntl_identifier is null or per.national_identifier = :p_ntl_identifier) and pen.prtt_enrt_rslt_id = prm.prtt_enrt_rslt_id (+) and mpr.prtt_prem_id(+) = prm.prtt_prem_id and mpr.yr_num(+) = to_number(to_char(:p_report_start_date,'YYYY')) and mpr.mo_num(+) = to_number(to_char(:p_report_start_date,'MM')) and prm.per_in_ler_id (+) = pen.per_in_ler_id and acp.actl_prem_id (+) = prm.actl_prem_id and (:p_prem_type is null or acp.prsptv_r_rtsptv_cd = :p_prem_type ) and pen.person_id = asg.person_id and pen.business_group_id = :p_business_group_id and asg.business_group_id = :p_business_group_id and asg.primary_flag = 'Y' and (:p_payroll_id is null or asg.payroll_id = :p_payroll_id ) and asg.payroll_id = pay.payroll_id and pds.payroll_id = pay.payroll_id and pds.start_date >= :p_report_start_date and pds.end_date <= :p_report_end_date and per.business_group_id = :p_business_group_id and :p_run_date between per.effective_start_date and per.effective_end_date and :p_run_date between asg.effective_start_date and asg.effective_end_date and :p_run_date between pay.effective_start_date and pay.effective_end_date and :p_run_date between acp.effective_start_date (+) and acp.effective_end_date (+) and :p_run_date >= prm.effective_start_date (+) and :p_run_date <= prm.effective_end_date (+) and (:p_organization_id is null or asg.organization_id = :p_organization_id ) and (:p_location_id is null or asg.location_id = :p_location_id) and (:p_benfts_grp_id is null or per.benefit_group_id = :p_benfts_grp_id) and (:p_rptg_grp_id is null or exists (select null from ben_popl_rptg_grp_f prpg where ( pen.pl_id = prpg.pl_id or pen.pgm_id = prpg.pgm_id) and prpg.rptg_grp_id = :p_rptg_grp_id)) ) pl group by pl_oraganization_name, pl_location_name, pl_payroll_name , pl_full_name, pl_national_identifier, pl_bnft_amount , pl_prem_val, pl_sql_uom, pl_period_type order by 1,2,3,4 BEN BENRECON_XML AR BEN تقرير تسوية إسهامات الأقساط لإدخالات العناصر (بتنسيق XML) Imported from BI Publisher Description: تسوية إسهامات الأقساط لإدخالات العناصر Application: المزايا المتقدمة Source: تقرير تسوية إسهامات الأقساط لإدخالات العناصر (بتنسيق XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG D BEN Prämienbeiträge mit Elementeinträgen abstimmen Imported from BI Publisher Description: Auswertung "Prämienbeiträge mit Elementeinträgen abstimmen" Application: Advanced Benefits Source: Prämienbeiträge mit Elementeinträgen abstimmen (XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG E BEN Conciliación de Contribuciones de Primas en Registros de Elementos Imported from BI Publisher Description: Conciliación de contribuciones de primas en registros de elementos Application: Advanced Benefits Source: Conciliación de Contribuciones de Primas en Registros de Elementos (XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG F BEN Etat Rapprochement des cotisations de prime des saisies d'éléments Imported from BI Publisher Description: Rapprochement des cotisations de prime des saisies d'éléments Application: Advanced Benefits Source: Etat Rapprochement des cotisations de prime des saisies d'éléments (XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG I BEN Rapporto Quadratura contribuzioni premi a immissioni elemento Imported from BI Publisher Description: Rapporto di quadratura contribuzioni premi a immissioni elemento Application: Advanced Benefits Source: Rapporto Quadratura contribuzioni premi a immissioni elemento (XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG JA BEN エレメント・エントリへの掛金拠出消込レポート Imported from BI Publisher Description: エレメント・エントリへの掛金拠出消込 Application: Advanced Benefits Source: エレメント・エントリへの掛金拠出消込レポート(XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG KO BEN 항목 등록으로 프리미엄 지불 대사 보고서 Imported from BI Publisher Description: 항목 등록으로 프리미엄 지불 대사 Application: Advanced Benefits Source: 항목 등록으로 프리미엄 지불 대사 보고서(XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG PTB BEN Relatório de Reconciliação de Contribuições Adicionais para Entradas de Elemento Imported from BI Publisher Description: Reconciliação de Contribuições Adicionais para Entradas de Elemento Application: Advanced Benefits Source: Relatório de Reconciliação de Contribuições Adicionais para Entradas de Elemento (XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG RU BEN Отчет о выверке взносов по записям элементов Imported from BI Publisher Description: Выверка взносов по записям элементов Application: Пособия Source: Отчет о выверке взносов по записям элементов (XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG S BEN Avstämning av premieavgifter till lönetransaktioner - rapport Imported from BI Publisher Description: Avstämning av premieavgifter till lönetransaktioner Application: Advanced Benefits Source: Avstämning av premieavgifter till lönetransaktioner - rapport (XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG TR BEN Kalem Girişlerine Prim Katkıları Mutabakat Raporu Imported from BI Publisher Description: Kalem Girişlerine Prim Katkıları Mutabakatı Application: Kazanç Yönetimi Source: Kalem Girişlerine Prim Katkıları Mutabakat Raporu (XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG US BEN Reconciliation of Premium Contributions to Element Entries Imported from BI Publisher Description: Reconciliation of Premium Contributions to Element Entries Application: Advanced Benefits Source: Reconciliation of Premium Contributions to Element Entries Report (XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG ZHS BEN 要素项的保费缴费调节报表 Imported from BI Publisher Description: 要素项的保费缴费调节 Application: 高级福利 Source: 要素项的保费缴费调节报表 (XML) Short Name: BENRECON_XML DB package: BEN_BENRECON_XMLP_PKG BI Publisher :cp_benfts_grp :cp_business_group :cp_disc_prtt_count :cp_dsply_disc :cp_dsply_lfe :cp_dsply_pl_prtt :cp_dsply_recn :cp_emp_name_format :cp_lfe_prtt_count :cp_location :cp_ntl_identifier :cp_organization :cp_output_typ :cp_payroll :cp_per_sel_rule :cp_person :cp_pgm :cp_pl :cp_pl_prtt_count :cp_pl_recn_prtt_count :cp_prem_type :cp_rptg_grp :p_actual_tot :p_benefit_action_id :p_benfts_grp_id :p_business_group_id :p_conc_request_id :p_date_format :p_dsply_disc :p_dsply_lfe :p_dsply_lfe_rep :p_dsply_pl_disc_rep :p_dsply_pl_prtt :p_dsply_pl_prtt_rep :p_dsply_pl_recn_rep :p_dsply_prtt_reps :p_dsply_recn :p_emp_name_format :p_error :p_lfe_rep_header :p_location_id :p_mon_year :p_ntl_identifier :p_op_file_name :p_organization_id :p_output_typ :p_payroll_id :p_per_sel_rule :p_period_tot :p_person_id :p_pgm_id :p_pl_id :p_plan_disc_rep_header :p_plan_prtt_rep_header :p_plan_prtt_subtotal_name :p_plan_recn_rep_header :p_prem_type :p_rep_end_dt :p_rep_st_dt :p_report_end_date :p_report_start_date :p_rptg_grp_id :p_run_date :pl_uom :t_dsply_lfe_rep :t_dsply_pl_disc_rep :t_dsply_pl_prtt_rep :t_dsply_pl_recn_rep 1 -30 :p_business_group_id Char fnd_profile.value('PER_BUSINESS_GROUP_ID') Y 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 业务组 2 -20 :p_dsply_prtt_reps 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 Teilnehmerdetails anzeigen E Mostrar Detalles de Participante F Afficher les détails des participants I Visualizza dettagli partecipante JA 加入者詳細の表示 KO 가입자 상세내역 표시 PTB Exibir Detalhes do Participante RU Вывод сведений об участнике S Visa detaljer för deltagare TR Katılımcı Detaylarını Görüntüle US Display Participant Details ZHS 显示参与者详细信息 3 10 :p_report_start_date Date select fnd_date.date_to_displaydate(add_months(last_day(sysdate),-1)+1) from sys.dual Y AR تاريخ بداية التقرير D Startdatum Auswertung E Fecha de Inicio de Informe F Date de début du reporting I Data inizio generazione rapporti JA レポート開始日 KO 보고 시작 일자 PTB Data Inicial de Emissão de Relatórios RU Начальная дата отчетности S Startdatum för rapportering TR Raporlama Başlangıç Tarihi US Reporting Start Date ZHS 报告起始日期 4 20 :p_report_end_date Date select fnd_date.date_to_displaydate(last_day(sysdate)) from sys.dual Y US PER_DATES 5 30 :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 اسم الموظف D Mitarbeitername E Nombre de Empleado F Nom de l'employé I Nome dipendente JA 従業員名 KO 사원 이름 PTB Nome do Funcionário RU Имя работника S Anställd TR Çalışan Adı US Employee Name ZHS 员工姓名 6 40 :p_ntl_identifier LOV Oracle BEN_US_SSN Y select a.national_identifier id, a.national_identifier 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.national_identifier AR رقم البطاقة الشخصية D Nationale Kennnummer E N.I.F. F Identifiant national I Codice fiscale JA 国別識別子 KO 주민 등록 번호 PTB Identificador Nacional RU ИНН S Personnummer TR Sosyal Güvenlik Numarası US National Identifier ZHS 身份证 7 50 :p_emp_name_format LOV Oracle BEN_PER_NAME_FMT Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='BEN_PER_NAME_FMT' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) order by meaning select meaning from hr_lookups where lookup_type = 'BEN_PER_NAME_FMT' and lookup_code = 'OTH' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) Y AR صيغة اسم الموظف D Format Mitarbeitername E Formato de Nombre de Empleado F Format du nom de l'employé I Formato nome dipendente JA 従業員名書式 KO 사원 이름 형식 PTB Formato de Nome do Funcionário RU Формат имени работника S Format för anställds namn TR Çalışan Adı Formatı US Employee Name Format ZHS 员工姓名格式 8 60 :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 方案 9 70 :p_pl_id LOV Oracle BEN_PL_PLTYP_OPT Y select a.pl_id id, a.name value, null description from ben_pl_f a,hr_lookups hr,ben_pl_typ_f b where a.business_group_id=fnd_global.per_business_group_id and a.effective_start_date=(select max(effective_start_date) from ben_pl_f c where c.pl_id=a.pl_id) and b.pl_typ_id=a.pl_typ_id and b.effective_start_date=(select max(effective_start_date) from ben_pl_typ_f d where d.pl_typ_id=a.pl_typ_id) and b.opt_typ_cd not in ('CWB','GSP','ABS','ICM') and hr.lookup_code=b.opt_typ_cd and hr.lookup_type='BEN_OPT_TYP' order by hr.meaning,a.name Y AR الخطة I Piano JA プラン KO 제도 PTB Plano RU План US Plan ZHS 计划 10 80 :p_per_sel_rule 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 90 :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 组织 12 100 :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 Placering TR Yerleşim US Location ZHS 地点 13 110 :p_benfts_grp_id LOV Oracle BEN_BENEFITS_GROUP Y select benfts_grp_id id, name value, null description from ben_benfts_grp where business_group_id= fnd_global.per_business_group_id order by name AR المجموعة التابع لها D Leistungsgruppe E Grupo de Beneficios F Groupe d'avantages I Gruppo benefit JA 福利厚生グループ KO 복리후생 그룹 PTB Grupo de Benefícios RU Группа пособий S Förmånsgrupp TR Kazanç Grubu US Benefits Group ZHS 福利组 14 120 :p_rptg_grp_id LOV Oracle BEN_RPTG_GRP Y select rptg_grp_id id, name value, null description from ben_rptg_grp_v where nvl(business_group_id,fnd_global.per_business_group_id)= fnd_global.per_business_group_id order by name AR مجموعة التقارير D Auswertungsgruppe E Grupo de Informes F Groupe de reporting I Gruppo rapporti JA レポート・グループ KO 보고 그룹 PTB Grupo de Emissão de Relatórios RU Группа отчетности S Rapporteringsgrupp TR Raporlama Grubu US Reporting Group ZHS 报告组 15 130 :p_payroll_id LOV Oracle BEN_SRS_PAYROLL Y select payroll_id id, payroll_name value, null description from pay_all_payrolls_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 pay_all_payrolls_f b where a.payroll_id=b.payroll_id) order by payroll_name AR كشف الرواتب D Lohn- und Gehaltsabrechnung E Nómina F Paie I Ciclo paghe JA 給与 KO 급여 PTB Folha de Pagamento RU Ведомость S Lönegrupp TR Bordro US Payroll ZHS 工资单 16 140 :p_prem_type LOV Oracle BEN_PREM_TYP Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='BEN_PRSPCTV_R_RTSPCTV' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) order by meaning AR نوع القسط D Prämienart E Tipo de Prima F Type de prime I Tipo premio JA 掛金タイプ KO 프리미엄 유형 PTB Tipo de Adicional RU Тип премии S Premietyp TR Prim Tipi US Premium Type ZHS 保费类型 17 150 :p_output_typ LOV Oracle BEN_FILE_OP_TYP Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='BEN_FILE_OP_TYP' and enabled_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) order by meaning select meaning from hr_lookups where lookup_type = 'BEN_FILE_OP_TYP' and lookup_code = 'TXT' and enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) Y AR نوع المخرجات D Ausgabeart E Tipo de Salida F Type de sortie I Tipo di output JA 出力タイプ KO 결과 유형 PTB Tipo de Saída RU Тип результата S Utdatatyp TR Çıktı Tipi US Output Type ZHS 输出类型 18 160 :p_dsply_pl_recn_rep 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) Y AR عرض تقرير تسوية الخطة D Planabstimmung anzeigen E Mostrar Informe Conciliación de Plan F Afficher l'état de rapprochement de plan I Visualizza rapporto quadratura piano JA プラン消込レポートの表示 KO 제도 대사 보고서 표시 PTB Exibir Relatório de Reconciliação do Plano RU Вывод отчета о выверке плана S Visa avstämning för plan - rapport TR Plan Mutabakat Raporunu Görüntüle US Display Plan Reconciliation Report ZHS 显示计划调节报表 19 170 :p_dsply_pl_disc_rep 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) Y AR عرض تقرير تعارضات الخطط D Plandifferenzen anzeigen E Mostrar Informe Discrepancias de Plan F Afficher l'état des écarts de plan I Visualizza rapporto discrepanze piano JA プラン差異レポートの表示 KO 제도 차이 보고서 표시 PTB Exibir Relatório de Discrepâncias do Plano RU Вывод отчета о расхождении плана S Visa avvikelser från plan - rapport TR Plan Uyuşmazlıkları Raporunu Görüntüle US Display Plan Discrepancies Report ZHS 显示计划差异报表 20 180 :p_dsply_lfe_rep 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) Y AR عرض تقرير حدث العمر D Veränderung anzeigen E Mostrar Informe Evento Personal F Afficher l'état d'événement personnel I Visualizza rapporto evento vita JA ライフ・イベント・レポートの表示 KO Life Event 보고서 표시 PTB Exibir Relatório do Evento de Vida RU Вывод отчета о жизненном событии S Visa livshändelse - rapport TR Önemli Kişisel Olay Raporunu Görüntüle US Display Life Event Report ZHS 显示人生事件报表 21 190 :p_dsply_pl_prtt_rep 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) Y AR عرض تقرير تفاصيل المشارك في الخطة D Planteilnehmerdetails anzeigen E Mostrar Informe Detalles de Participante en Plan F Afficher l'état de détail des participants au plan I Visualizza rapporto dettagli partecipante piano JA プラン加入者詳細レポートの表示 KO 제도 가입자 상세 보고서 표시 PTB Exibir Relatório de Detalhes do Participante do Plano RU Вывод отчета о сведениях об участнике плана S Visa detaljer för deltagare i plan - rapport TR Plan Katılımcı Detayları Raporunu Görüntüle US Display Plan Participant Details Report ZHS 显示计划参与者详细信息报表