ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 15B2E2DBB73FE8CCE0630100007F9602 Costing Process Y select pcs.consolidation_set_name||' :'||to_char(ppa.payroll_action_id) value, null description from pay_consolidation_sets pcs,pay_payroll_actions ppa,pay_payrolls_f pay where decode(:$flex$.Costing_Effective_Date_Begin,NULL,'1','') ='1' and decode(:$flex$.Costing_Effective_Date_End,NULL,'1','') ='1' and pcs.consolidation_set_id=ppa.consolidation_set_id and ppa.action_type in ('C','S') and ppa.business_group_id=:$flex$.Business_Group_Id and ppa.action_status='C' and ppa.payroll_id=pay.payroll_id(+) and ppa.effective_date between pay.effective_start_date(+) and pay.effective_end_date(+) and ((pay.payroll_id is null and ppa.payroll_id is null) or (pay.payroll_id=ppa.payroll_id) ) order by ppa.effective_date desc, ppa.start_date, pcs.consolidation_set_name, pay.payroll_name US 073C5DB683DD1171E06362FB0905F0D4 select x.consolidation_set_name, x.payroll_name, x.gre, x.last_name, x.first_name, x.middle_names, x.effective_date, x.element_name, x.input_value, x.uom, x.cost_allocation_segments, x.credit_amount, x.debit_amount, &lp_cost_alloc_segments x.organization_name, x.location_name, &lp_ni_number x.employee_number, x.assignment_number, x.element_classification, x.employment_category from (select pcd.cost_type, pcd.consolidation_set_name, pcd.payroll_name, pcd.gre_name gre, pcd.organization_name, pcd.location_code location_name, pcd.last_name, pcd.first_name, pcd.middle_names, pcd.employee_number, pcd.national_identifier, (select pec.classification_name from pay_element_classifications pec where pcd.classification_id = pec.classification_id ) element_classification, (SELECT hrl.meaning from hr_lookups hrl, per_all_assignments_f paf where hrl.lookup_type = 'EMP_CAT' and hrl.lookup_code = paf.employment_category and paf.assignment_id = pcd.assignment_id and pcd.effective_date between paf.effective_start_date and paf.effective_end_date ) employment_category, pcd.assignment_number, pcd.assignment_id, nvl(pcd.reporting_name,pcd.element_name) element_name, pcd.input_value_name input_value, pcd.uom, pcd.credit_amount, pcd.debit_amount, pcd.effective_date, pcd.concatenated_segments cost_allocation_segments, pcd.segment1, pcd.segment2, pcd.segment3, pcd.segment4, pcd.segment5, pcd.segment6, pcd.segment7, pcd.segment8, pcd.segment9, pcd.segment10, pcd.segment11, pcd.segment12, pcd.segment13, pcd.segment14, pcd.segment15, pcd.segment16, pcd.segment17, pcd.segment18, pcd.segment19, pcd.segment20, pcd.segment21, pcd.segment22, pcd.segment23, pcd.segment24, pcd.segment25, pcd.segment26, pcd.segment27, pcd.segment28, pcd.segment29, pcd.segment30, pcd.run_result_id from pay_costing_details_v pcd where nvl(:p_selection_criteria,'?') = nvl(:p_selection_criteria,'?') and nvl(:p_eff_date_begin,sysdate) = nvl(:p_eff_date_begin,sysdate) and nvl(:p_eff_date_end,sysdate) = nvl(:p_eff_date_end,sysdate) and pcd.effective_date between :p_start_date and :p_end_date and pcd.business_group_id = :p_business_group_id and ( (:p_cost_type = 'EST_MODE_COST' and pcd.cost_type in ('COST_TMP','EST_COST')) or (:p_cost_type = 'EST_MODE_ALL' and pcd.cost_type in ('COST_TMP','EST_COST','EST_REVERSAL')) or (:p_cost_type is null and pcd.cost_type = 'COST_TMP') ) and 1=1 ) x order by x.cost_type, x.last_name, x.first_name, x.middle_names, x.effective_date, x.cost_type Y (:Costing_Effective_Date_Begin is not null or :Costing_Process is not null) AR PAY تقرير تفاصيل حساب التكلفة Imported from Concurrent Program Application: كشوف الرواتب Source: تقرير تفاصيل حساب التكلفة Short Name: PAYRPCDR D PAY Auswertung "Kostenrechnungsdetails" Imported from Concurrent Program Application: Lohn und Gehalt Source: Auswertung "Kostenrechnungsdetails" Short Name: PAYRPCDR E PAY Detalle de Costes Imported from Concurrent Program Description: Informe Detalle de Costes Application: Payroll Source: Detalle de Costes Short Name: PAYRPCDR F PAY Etat détaillé de la gestion des coûts Imported from Concurrent Program Application: Payroll Source: Etat détaillé de la gestion des coûts Short Name: PAYRPCDR I PAY Rapporto Dettagli determinazione costi Imported from Concurrent Program Application: Payroll Source: Rapporto Dettagli determinazione costi Short Name: PAYRPCDR JA PAY 原価計算詳細レポート Imported from Concurrent Program Application: Payroll Source: 原価計算詳細レポート Short Name: PAYRPCDR KO PAY 원가계산 상세 보고서 Imported from Concurrent Program Application: Payroll Source: 원가계산 상세 보고서 Short Name: PAYRPCDR PTB PAY Relatório Detalhado de Cálculo de Custo Imported from Concurrent Program Application: Folha de Pagto. Source: Relatório Detalhado de Cálculo de Custo Short Name: PAYRPCDR RU PAY Подробный отчет о калькуляции затрат Imported from Concurrent Program Application: Заработная плата Source: Подробный отчет о калькуляции затрат Short Name: PAYRPCDR S PAY Detaljrapport för kontering Imported from Concurrent Program Application: Payroll Source: Detaljrapport för kontering Short Name: PAYRPCDR TR PAY Maliyetlendirme Detayı Raporu Imported from Concurrent Program Application: Bordro Source: Maliyetlendirme Detayı Raporu Short Name: PAYRPCDR US PAY Costing Detail Imported from Concurrent Program Application: Payroll Source: Costing Detail Report Short Name: PAYRPCDR Please specify either a Costing Effective Date Range or a Costing Process ZHS PAY 成本计算明细报表 Imported from Concurrent Program Application: 工资单 Source: 成本计算明细报表 Short Name: PAYRPCDR Enginatics &lp_cost_alloc_segments &lp_ni_number 1=1 :p_business_group_id :p_cost_type :p_eff_date_begin :p_eff_date_end :p_end_date :p_selection_criteria :p_start_date 1 -40 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') AR معرف مجموعة العمل معرف مجموعة العمل D Kennung Unternehmensgruppe Kennung Unternehmensgruppe E Id Grupo de Trabajo Id Grupo de Trabajo F ID entité professionnelle ID entité professionnelle I ID business group ID business group JA ビジネス・グループID ビジネス・グループID KO 업무 그룹 ID 업무 그룹 ID PTB Id do Grupo Funcional Id do Grupo Funcional RU Идент. бизнес-группы Идент. бизнес-группы S Id för verksamhetsgrupp Id för verksamhetsgrupp TR İş Grup No İş Grup No US Business Group ID Business Group ID ZHS 业务组标识 业务组标识 2 &lp_cost_alloc_segments select ' x.' || lower(fifs.application_column_name) || ' "' || substr(fifs.segment_name,1,xxen_report.max_column_length) || '",' from per_business_groups pbg, fnd_id_flex_segments fifs where pbg.business_group_id = :p_business_group_id and fifs.application_id = 801 and fifs.id_flex_code = 'COST' and fifs.id_flex_num = pbg.cost_allocation_structure and fifs.enabled_flag = 'Y' and fifs.display_flag = 'Y' US Business Group ID 3 &lp_ni_number select 'x.national_identifier "' || substr(nvl( (select fnm.message_text from per_business_groups pbg, fnd_new_messages fnm where pbg.business_group_id = :p_business_group_id and fnm.application_id = 800 and fnm.message_name = 'HR_NATIONAL_ID_NUMBER_'||pbg.legislation_code and fnm.language_code = userenv('lang') ),'National Identifier'), 1,xxen_report.max_column_length) || '",' from dual where 'Y' = nvl( (select nvl(plfi.rule_mode,'Y') from per_business_groups pbg, pay_legislative_field_info plfi where pbg.business_group_id = :p_business_group_id and plfi.field_name = 'NATIONAL_IDENTIFIER_PRT' and plfi.rule_type = 'DISPLAY' and plfi.legislation_code = pbg.legislation_code ),'Y') US Business Group ID 4 -30 :p_start_date Date select nvl( (select ppa.effective_date from pay_payroll_actions ppa where ppa.payroll_action_id = to_number(substr(:$flex$.Costing_Process,instr(:$flex$.Costing_Process,':',-1,1)+1,length(:$flex$.Costing_Process))) ), :$flex$.costing_effective_date_begin ) from dual US Start Date Derived Start Date 5 -20 :p_end_date Date select coalesce( (select ppa.effective_date from pay_payroll_actions ppa where ppa.payroll_action_id = to_number(substr(:$flex$.Costing_Process,instr(:$flex$.Costing_Process,':',-1,1)+1,length(:$flex$.Costing_Process))) ), :$flex$.costing_effective_date_end, to_date('31-12-4712','DD-MM-YYYY') ) from dual US End Date Derived End Date 6 10 :p_eff_date_begin Date AR بداية تاريخ فعالية حساب التكلفة بداية تاريخ فعالية حساب التكلفة D Kostenrechnung gültig von Kostenrechnung gültig von E Fecha de Inicio en Vigor del Cálculo de Costes Fecha de Inicio en Vigor del Cálculo de Costes F Date de début de validité de la gestion des coûts Date de début de validité de la gestion des coûts I Data di inizio validità determinazione dei costi Data di inizio validità determinazione dei costi JA 原価計算有効開始日 原価計算有効開始日 KO 원가계산 유효 시작 일자 원가계산 유효 시작 일자 PTB Data Inicial da Efetivação do Cálculo de Custo Data Inicial da Efetivação do Cálculo de Custo RU Дата действия калькуляции с Дата действия калькуляции с S Första giltighetsdatum för kontering Första giltighetsdatum för kontering TR Maliyetlendirme Geçerlilik Tarihi Başlangıcı Maliyetlendirme Geçerlilik Tarihi Başlangıcı US Costing Effective Date Begin Costing Effective Date Begin ZHS 成本计算有效起始日期 成本计算有效起始日期 7 20 :p_eff_date_end Date AR نهاية تاريخ فعالية حساب التكلفة نهاية تاريخ فعالية حساب التكلفة D Kostenrechnung gültig bis Kostenrechnung gültig bis E Fecha de Finalización en Vigor del Cálculo de Costes Fecha de Finalización en Vigor del Cálculo de Costes F Date de fin de validité de la gestion des coûts Date de fin de validité de la gestion des coûts I Data di fine validità determinazione dei costi Data di fine validità determinazione dei costi JA 原価計算有効終了日 原価計算有効終了日 KO 원가계산 유효 종료 일자 원가계산 유효 종료 일자 PTB Data Final da Efetivação do Cálculo de Custo Data Final da Efetivação do Cálculo de Custo RU Дата действия калькуляции по Дата действия калькуляции по S Sista giltighetsdatum för kontering Sista giltighetsdatum för kontering TR Maliyetlendirme Geçerlilik Tarihi Bitişi Maliyetlendirme Geçerlilik Tarihi Bitişi US Costing Effective Date End Costing Effective Date End ZHS 成本计算有效终止日期 成本计算有效终止日期 8 25 1=1 pcd.payroll_action_id = to_number(substr(:p_costing_name,instr(:p_costing_name,':',-1,1)+1,length(:p_costing_name))) LOV Costing Process 15B2E2DBB73FE8CCE0630100007F9602 Y select pcs.consolidation_set_name||' :'||to_char(ppa.payroll_action_id) value, null description from pay_consolidation_sets pcs,pay_payroll_actions ppa,pay_payrolls_f pay where decode(:$flex$.Costing_Effective_Date_Begin,NULL,'1','') ='1' and decode(:$flex$.Costing_Effective_Date_End,NULL,'1','') ='1' and pcs.consolidation_set_id=ppa.consolidation_set_id and ppa.action_type in ('C','S') and ppa.business_group_id=:$flex$.Business_Group_Id and ppa.action_status='C' and ppa.payroll_id=pay.payroll_id(+) and ppa.effective_date between pay.effective_start_date(+) and pay.effective_end_date(+) and ((pay.payroll_id is null and ppa.payroll_id is null) or (pay.payroll_id=ppa.payroll_id) ) order by ppa.effective_date desc, ppa.start_date, pcs.consolidation_set_name, pay.payroll_name AR عملية تحديد التكلفة عملية تحديد التكلفة D Kostenrechnungsprozess Kostenrechnungsprozess E Procesos de Costes Procesos de Costes F Traitement de gestion des coûts Traitement de gestion des coûts I Processo determinazione costi Processo di determinazione dei costi JA 原価計算プロセス 原価計算プロセス KO 비용계정 프로세스 비용계정 프로세스 PTB Processo de Cálculo de Custo Processo de Cálculo de Custo RU Процесс калькуляции затрат Процесс калькуляции затрат S Konteringsbearbetning Konteringsbearbetning TR Maliyetlendirme İşlemi Maliyetlendirme İşlemi US Costing Process Costing Process ZHS 成本计算流程 成本计算流程 9 30 :p_selection_criteria Char AR معيار الاختيار معيار الاختيار D Auswahlkriterium Auswahlkriterium E Criterio de Selección Criterio de Selección F Critère de sélection Critère de sélection I Criteri di selezione Criteri di selezione JA 選択基準 選択基準 KO 선택 기준 선택 기준 PTB Critério de Seleção Critério de Seleção RU Условие отбора Условие отбора S Urvalsvillkor Urvalsvillkor TR Seçim Ölçütü Seçim Ölçütü US Selection Criterion Selection Criterion ZHS 选择标准 选择标准 10 40 1=1 exists ( select pes.element_set_id from pay_element_sets pes, pay_element_sets_tl pestl where (pes.business_group_id=fnd_global.per_business_group_id or (pes.business_group_id is null and pes.legislation_code= (select legislation_code from per_business_groups where business_group_id= fnd_global.per_business_group_id ) ) ) and pes.element_set_type='C' and pestl.element_set_id=pes.element_set_id and pestl.language=userenv('LANG') and pestl.element_set_name = :p_element_set_name and exists (select 'x' from pay_element_type_rules petr where petr.element_set_id = pes.element_set_id and petr.element_type_id = pcd.element_type_id and petr.include_or_exclude = 'I' union all select 'x' from pay_element_types_f pet1 where pet1.classification_id in (select classification_id from pay_ele_classification_rules where element_set_id = pes.element_set_id ) and pet1.element_type_id = pcd.element_type_id minus select 'x' from pay_element_type_rules petr where petr.element_set_id = pes.element_set_id and petr.element_type_id = pcd.element_type_id and petr.include_or_exclude = 'E' ) ) LOV custom Y select estl.element_set_name value, null description from pay_element_sets es, pay_element_sets_tl estl where (es.business_group_id=fnd_global.per_business_group_id or (es.business_group_id is null and es.legislation_code= (select legislation_code from per_business_groups where business_group_id=fnd_global.per_business_group_id ) ) ) and es.element_set_type='C' and estl.element_set_id=es.element_set_id and estl.language=userenv('LANG') and :$flex$.selection_criterion = (select hl.meaning from hr_lookups hl where hl.lookup_type = 'REPORT_SELECT_SORT_CODE' and hl.enabled_flag = 'Y' and hl.lookup_code = '09') order by estl.element_set_name AR مجموعة العناصر مجموعة العناصر D ElementSet ElementSet E Juego de Elementos Juego de Elementos F Jeu d'éléments Jeu d'éléments I Serie di elementi Serie di elementi JA エレメント・セット 2 エレメント・セット KO 항목 세트 2 항목 세트 PTB Conjunto de Elementos Conjunto de Elementos RU Набор элементов 2 Набор элементов S Löneartsgrupp Löneartsgrupp TR Kalem Kümesi 2 Kalem Kümesi US Element Set Element Set ZHS 要素集 要素集 11 50 1=1 pcd.classification_id in ( select pec.classification_id from pay_element_classifications pec where nvl(pec.business_group_id,:p_business_group_id) = :p_business_group_id and ( pec.legislation_code is null or pec.legislation_code in (select hoi.org_information9 from hr_organization_information hoi where hoi.organization_id = :p_business_group_id and hoi.org_information_context='Business Group Information' ) ) and pec.classification_name = :p_classification_name ) LOV custom Y select classification_name value, null description from pay_element_classifications where nvl(business_group_id,fnd_global.per_business_group_id) =fnd_global.per_business_group_id and (legislation_code is null or legislation_code in (select org_information9 from hr_organization_information where organization_id=fnd_global.per_business_group_id and org_information_context='Business Group Information' ) ) and :$flex$.selection_criterion = (select hl.meaning from hr_lookups hl where hl.lookup_type = 'REPORT_SELECT_SORT_CODE' and hl.enabled_flag = 'Y' and hl.lookup_code = '13') order by classification_name AR تصنيف العنصر تصنيف العنصر D Elementklassifizierung Elementklassifizierung E Clasificación de Elementos Clasificación de Elementos F Classification d'élément Classification d'élément I Classificazione elemento 2 Classificazione elemento JA 分類 2 分類 KO 항목 분류 2 항목 분류 PTB Classificação do Elemento Classificação do Elemento RU Классификация элементов 2 Классификация элементов S Löneartsklassificering Löneartsklassificering TR Kalem Sınıflandırması 2 Kalem Sınıflandırması US Element Classification Element Classification ZHS 要素分类 要素分类 12 60 1=1 pcd.element_type_id in ( select el.element_type_id from fnd_sessions fd, pay_element_types_f_tl tl, pay_element_types_f el where nvl(el.business_group_id,fnd_global.per_business_group_id) =fnd_global.per_business_group_id and (el.legislation_code is null or el.legislation_code= (select legislation_code from per_business_groups b where b.business_group_id=fnd_global.per_business_group_id ) ) and tl.language=userenv('LANG') and el.element_type_id=tl.element_type_id and fd.session_id=userenv('sessionid') and fd.effective_date between el.effective_start_date and el.effective_end_date and tl.element_name = :p_element_name ) LOV custom Y select tl.element_name value, null description from fnd_sessions fd, pay_element_types_f_tl tl, pay_element_types_f el where nvl(el.business_group_id,fnd_global.per_business_group_id) =fnd_global.per_business_group_id and (el.legislation_code is null or el.legislation_code= (select legislation_code from per_business_groups b where b.business_group_id=fnd_global.per_business_group_id ) ) and tl.language=userenv('LANG') and el.element_type_id=tl.element_type_id and fd.session_id=userenv('sessionid') and fd.effective_date between el.effective_start_date and el.effective_end_date and :$flex$.selection_criterion = (select hl.meaning from hr_lookups hl where hl.lookup_type = 'REPORT_SELECT_SORT_CODE' and hl.enabled_flag = 'Y' and hl.lookup_code = '14') order by value,description AR العنصر العنصر E Elemento Elemento F Elément Elément I Elemento Elemento JA エレメント エレメント KO 항목 항목 PTB Elemento Elemento RU Элемент Элемент S Löneart Löneart TR Kalem Kalem US Element Element ZHS 要素 要素 13 70 1=1 pcd.payroll_id in ( select ppf.payroll_id from pay_payrolls_f ppf, fnd_sessions fnd where ppf.business_group_id=:p_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between ppf.effective_start_date and ppf.effective_end_date and ppf.payroll_name = :p_payroll_name ) LOV custom Y select ppf.payroll_name value, null description from pay_payrolls_f ppf,fnd_sessions fnd where decode(:$flex$.Costing_Process,null,'X',null)='X' and ppf.business_group_id=fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between ppf.effective_start_date and ppf.effective_end_date order by ppf.payroll_name AR كشف الرواتب كشف الرواتب D Lohn- und Gehaltsabrechnung Lohn- und Gehaltsabrechnung E Nómina Nómina F Paie Paie I Ciclo paghe Ciclo paghe JA 給与 給与 KO 급여 급여 PTB Folha de Pagto. Folha de Pagto. RU Ведомость Ведомость S Lönegrupp Lönegrupp TR Bordro Bordro US Payroll Payroll ZHS 工资单 工资单 14 80 1=1 pcd.consolidation_set_name = :p_consolidation_set_name LOV custom Y select pcs.consolidation_set_name value, null description from pay_consolidation_sets pcs where decode(:$flex$.Costing_Process,null,'X',null)='X' and pcs.business_group_id=fnd_global.per_business_group_id order by pcs.consolidation_set_name select pcs.consolidation_set_name from pay_consolidation_sets pcs, pay_payrolls pp, pay_payrolls_f ppf where pcs.consolidation_set_id = pp.consolidation_set_id and pp.payroll_id = ppf.payroll_id and ppf.payroll_name = :$flex$.payroll AR مجموعة التجميع مجموعة التجميع D KonsolidierungSet KonsolidierungSet E Juego de Consolidación Juego de Consolidación F Jeu de consolidation Jeu de consolidation I Gruppo di consolidamento Gruppo di consolidamento JA 連結セット 連結セット KO 급여 통합 세트 급여 통합 세트 PTB Conjunto de Consolidações Conjunto de Consolidações RU Консолидированный набор Консолидированный набор S Konsolideringsgrupp Konsolideringsgrupp TR Konsolidasyon Kümesi Konsolidasyon Kümesi US Consolidation Set Consolidation Set ZHS 合并集 合并集 15 90 1=1 pcd.tax_unit_id =:p_tax_unit_id LOV Oracle HR_US_TAX_UNIT Y select txu.tax_unit_id id, txu.name value, null description from hr_tax_units_v txu where txu.business_group_id= fnd_global.per_business_group_id order by value,description AR كيان رسمي مطالب بتقارير حكومية كيان رسمي مطالب بتقارير حكومية D Meldepflichtiges Unternehmen Meldepflichtiges Unternehmen E Entidad Legal Administrativa Entidad Legal Administrativa F Administration déclarante (GRE) Administration déclarante (GRE) I Entità fiscale governativa (US) Entità fiscale governativa (US) JA 政府レポート・エンティティ 政府レポート・エンティティ KO 법인 법인 PTB Estabelecimento Contribuinte - Governo Estabelecimento Contribuinte - Governo RU Юридическое лицо Юридическое лицо S Statlig rapporteringsenhet Statlig rapporteringsenhet TR Resmi Raporlama Kurumu Resmi Raporlama Kurumu US Government Reporting Entity Government Reporting Entity ZHS 政府申报实体 政府申报实体 16 100 1=1 pcd.organization_id = :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 Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 17 110 1=1 pcd.location_id = :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 Standort E Ubicación Ubicación F Lieu Lieu I Ubicazione Ubicazione JA 事業所 事業所 KO 위치 위치 PTB Local Local RU Расположение Расположение S Placering Placering TR Yerleşim Yerleşim US Location Location ZHS 地点 地点 18 120 1=1 pcd.person_id = :p_person_id LOV Oracle HR_US_PERSON Y Y select ppf.person_id id, ppf.full_name||' (Person ID='||ppf.person_id||')' value, null description from per_people_f ppf,per_person_types ppt where ppf.business_group_id+0= fnd_global.per_business_group_id and ppt.person_type_id=ppf.person_type_id+0 and ppt.system_person_type in ('EMP','EMP_APL','EX_EMP','EX_EMP_APL') and ppf.effective_start_date= (select max(effective_start_date) from per_people_f ppf1 where ppf1.person_id=ppf.person_id) order by nvl(ppf.order_name,ppf.full_name) AR الموظف الموظف D Mitarbeiter Mitarbeiter E Empleado Empleado F Employé Employé I Dipendente Dipendente JA 従業員 従業員 KO 사원 사원 PTB Funcionário Funcionário RU Работник Работник S Anställd Anställd TR Çalışan Çalışan US Employee Employee ZHS 员工 员工 19 130 1=1 exists (select 1 from hr_assignment_sets aset where aset.assignment_set_id = :p_assignment_set_id and nvl(aset.payroll_id,pcd.payroll_id) = pcd.payroll_id and (not exists (select 1 from hr_assignment_set_amendments hasa where hasa.assignment_set_id = aset.assignment_set_id and hasa.include_or_exclude = 'I') or exists (select 1 from hr_assignment_set_amendments hasa where hasa.assignment_set_id = aset.assignment_set_id and hasa.assignment_id = pcd.assignment_id and hasa.include_or_exclude = 'I')) and not exists (select 1 from hr_assignment_set_amendments hasa where hasa.assignment_set_id = aset.assignment_set_id and hasa.assignment_id = pcd.assignment_id and hasa.include_or_exclude = 'E' ) ) LOV Oracle PAY_REPORT_ASSIGNMENT_SETS Y select assignment_set_id id, assignment_set_name value, null description from hr_assignment_sets where business_group_id=fnd_global.per_business_group_id order by assignment_set_name AR مجموعة التعيين مجموعة التعيين D StellenSet StellenSet E Juego de Asignaciones Juego de Asignaciones F Jeu d'affectations Jeu d'affectations I Serie di assegnazioni Serie di assegnazioni JA アサイメント・セット アサイメント・セット KO 대상자 세트 대상자 세트 PTB Conjunto de Atribuições Conjunto de Atribuições RU Набор назнач. Набор назнач. S Anst.uppdragsgrupp Anst.uppdragsgrupp TR Görev Kümesi Görev Kümesi US Assignment Set Assignment Set ZHS 分配集 分配集 20 140 :p_cost_type LOV Oracle PAY_PAYRPCBR_EST_MODES Y select lookup_code id, meaning value, null description from hr_lookups hlk where lookup_type='PAY_PAYRPCBR' and lookup_code in ('EST_MODE_COST','EST_MODE_ALL') order by lookup_code AR تضمين الاستحقاقات تضمين الاستحقاقات D Mit Rückstellungen Mit Rückstellungen E Incluir Acumulaciones Incluir Acumulaciones F Inclure les provisions Inclure les provisions I Includi accantonamenti Includi accantonamenti JA 見越し額を含む 見越し額を含む KO 적치휴가 포함 적치휴가 포함 PTB Incluir Provisões Incluir Provisões RU Включить начисления Включить начисления S Inkludera upplupet Inkludera upplupet TR Tahakkukları Dahil Et Tahakkukları Dahil Et US Include Accruals Include Accruals ZHS 包括应计 包括应计 21 170 1=1 (select hrl.meaning from hr_lookups hrl, per_all_assignments_f paf where hrl.lookup_type = 'EMP_CAT' and hrl.lookup_code = paf.employment_category and paf.assignment_id = pcd.assignment_id and pcd.effective_date between paf.effective_start_date and paf.effective_end_date ) = :p_emp_cat LOV custom Y select hrl.meaning value, hrl.description from hr_lookups hrl where hrl.lookup_type = 'EMP_CAT' order by value US Employment Category :$flex$.Business_Group_Id Business Group ID Costing Process :$flex$.Costing_Effective_Date_Begin Costing Effective Date Begin Y Costing Process :$flex$.Costing_Effective_Date_End Costing Effective Date End Y Costing Process :$flex$.Costing_Process Costing Process Consolidation Set :$flex$.Costing_Process Costing Process End Date :$flex$.Costing_Process Costing Process Payroll :$flex$.Costing_Process Costing Process Start Date :$flex$.costing_effective_date_begin Costing Effective Date Begin Y Start Date :$flex$.costing_effective_date_end Costing Effective Date End Y End Date :$flex$.payroll Payroll Consolidation Set :$flex$.selection_criterion Selection Criterion Element :$flex$.selection_criterion Selection Criterion Element Classification :$flex$.selection_criterion Selection Criterion Element Set