ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471E251A9E05362FB09050512Y select element_name ELEMENT_NAME_A, element_type_id ELEMENT_TYPE_ID_A, entity_name position_name, budget_measurement_type, budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null, budgeted_entity_cd, entity_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, :p_currency_code ) budgeted_amt, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null, budgeted_entity_cd, entity_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, 'C', :p_currency_code ) committed_amt, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null, budgeted_entity_cd, entity_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, 'A', :p_currency_code ) actual_amt, PQH_PQHWSEES_XMLP_PKG.cf_act_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code )) CF_act_per, PQH_PQHWSEES_XMLP_PKG.cf_com_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) CF_com_per, PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) cf_projected_exp, PQH_PQHWSEES_XMLP_PKG.cf_proj_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) CF_proj_per, PQH_PQHWSEES_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) cf_def_ex_amt, PQH_PQHWSEES_XMLP_PKG.cf_def_ex_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )))) CF_def_ex_per, PQH_PQHWSEES_XMLP_PKG.cf_format_mask1(budget_unit_id) CF_Format_Mask1 from pqh_entity_element_types_v where element_type_id = :p_element_type_id And budgeted_entity_cd = :p_budgeted_entity_cd And pqh_mgmt_rpt_pkg.check_ent_type_and_variance ( null, :p_budgeted_entity_cd, entity_id, :p_start_date, :p_end_date, budget_unit_id , :p_entity_type, NVL(:p_variance_percent,0) , :p_currency_code ) = NVL(:p_entity_type,'A') order by 1,3,5 PQH PQHWSEES_XML AR PQH تقرير إجمالي عناصر الكيان (بتنسيق XML) Imported from BI Publisher Application: الموارد البشرية للقطاع العام Source: تقرير إجمالي عناصر الكيان (بتنسيق XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG D PQH Objekte - Elementübersicht Imported from BI Publisher Application: Public Sector HR Source: Objekte - Elementübersicht (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG E PQH Resumen de Elemento de Entidad Imported from BI Publisher Application: Public Sector HR Source: Resumen de Elemento de Entidad (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG F PQH Etat de synthèse des éléments d'entité Imported from BI Publisher Application: Public Sector HR Source: Etat de synthèse des éléments d'entité (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG I PQH Rapporto Sintetico elemento entità Imported from BI Publisher Application: Public Sector HR Source: Rapporto Sintetico elemento entità (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG JA PQH エンティティ・エレメント要約レポート Imported from BI Publisher Application: Public Sector HR Source: エンティティ・エレメント要約レポート(XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG KO PQH 개체 항목 요약 보고서 Imported from BI Publisher Application: Public Sector HR Source: 개체 항목 요약 보고서(XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG PTB PQH Relatório Sumariado do Elemento da Entidade Imported from BI Publisher Application: Public Sector HR Source: Relatório Sumariado do Elemento da Entidade (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG RU PQH Сводный отчет об элементах объекта Imported from BI Publisher Application: Государственный сектор: персонал Source: Сводный отчет об элементах объекта (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG S PQH Löneart för enhet - översiktsrapport Imported from BI Publisher Application: Public Sector HR Source: Löneart för enhet - översiktsrapport (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG TR PQH Tüzel Kişilik Kalemi Özet Raporu Imported from BI Publisher Application: Kamu Sektörü İnsan Kaynakları Yönetimi Source: Tüzel Kişilik Kalemi Özet Raporu (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG US PQH Entity Element Summary Imported from BI Publisher Application: Public Sector HR Source: Entity Element Summary Report (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG ZHS PQH 实体要素汇总报表 Imported from BI Publisher Application: Public Sector HR Source: 实体要素汇总报表 (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG BI Publisher :c_business_group_name :c_report_subtitle :cp_currency :cp_element_name :cp_entity_name :cp_position_type :cp_session_dt :p_budgeted_entity_cd :p_business_group_id :p_conc_request_id :p_currency_code :p_effective_date :p_element_type_id :p_end_date :p_entity_type :p_position_type :p_report_title :p_session_date :p_start_date :p_variance_percent 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') 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 10 :p_effective_date Date Y AR تاريخ الفعالية D Gültigkeitsdatum E Fecha en Vigor F Date de début de validité I Data validità JA 有効日 KO 유효 일자 PTB Data de Efetivação RU Дата действия S Giltighetsdatum TR Geçerlilik Tarihi US Effective Date ZHS 有效日期 3 20 :p_element_type_id LOV Oracle PAY_SRS_ELEMENT_TYPE Y select el.element_type_id id, tl.element_name value, null description from fnd_sessions fd,pay_element_types_f_tl tl,pay_element_types_f el 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=(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 order by value,description Y AR اسم العنصر D Elementbezeichnung E Nombre de Elemento F Nom d'élément I Nome elemento JA エレメント名称 KO 항목명 PTB Nome do Elemento RU Имя элемента S Löneart TR Kalem Adı US Element Name ZHS 要素名称 4 30 :p_budgeted_entity_cd LOV Oracle PQH_CMMTMNT_BDGT_ENTITY_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='PQH_BUDGET_ENTITY' and enabled_flag='Y' and lookup_code not in ('OPEN') order by meaning Y AR الكيان D Objekt E Entidad F Entité I Entità JA エンティティ KO 개체 PTB Entidade RU Объект S Enhet TR Nesne US Entity ZHS 实体 5 40 :p_entity_type LOV Oracle PQH_ENTITY_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='PQH_ENTITY_TYPE' and enabled_flag='Y' order by meaning Y AR نوع الكيان D Objektart E Tipo de Entidad F Type d'entité I Tipo entità JA エンティティ・タイプ KO 개체 유형 PTB Tipo de Entidade RU Тип объекта S Enhetstyp TR Tüzel Kişilik Tipi US Entity Type ZHS 实体类型 6 50 :p_variance_percent Number AR نسبة التباين D Prozentuale Abweichung E Porcentaje de Desviación F Ecarts en pourcentage I Percentuale scostamento JA 差異パーセント KO 차이 퍼센트 PTB Percentual de Variação RU Процент расхождения S Avvikelse i procent TR Fark Yüzdesi US Variance Percent ZHS 差异百分比 7 60 :p_start_date Date Y AR تاريخ البداية D Startdatum E Fecha de Inicio F Date de début I Data inizio JA 開始日 KO 시작 일자 PTB Data Inicial RU Начальная дата S Startdatum TR Başlangıç Tarihi US Start Date ZHS 起始日期 8 70 :p_end_date Date Y AR تاريخ النهاية D Enddatum E Fecha de Finalización F Date de fin I Data fine JA 終了日 KO 종료 일자 PTB Data Final RU Конечная дата S Slutdatum TR Bitiş Tarihi US End Date ZHS 终止日期 9 80 :p_currency_code LOV Oracle PQH_CURRENCY Y select currency_code id, name value, null description from fnd_currencies_active_v where currency_code!='STAT' order by name Y AR العملة D Währung E Divisa F Devise I Divisa JA 通貨 KO 통화 PTB Moeda RU Валюта S Valuta TR Para Birimi US Currency ZHS 币种