ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471E351A9E05362FB09050512Y select element_name, element_type_id, position_name, budget_measurement_type, budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null, position_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, :p_currency_code ) budgeted_amt, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null, position_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, 'C', :p_currency_code ) committed_amt, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null, position_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, 'A', :p_currency_code ) actual_amt, PQH_PQHWSEPS_XMLP_PKG.cf_act_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code )) CF_act_per, PQH_PQHWSEPS_XMLP_PKG.cf_com_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) CF_com_per, PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) cf_projected_exp, PQH_PQHWSEPS_XMLP_PKG.cf_proj_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) CF_proj_per, PQH_PQHWSEPS_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) cf_def_ex_amt, PQH_PQHWSEPS_XMLP_PKG.cf_def_ex_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )))) CF_def_ex_per, PQH_PQHWSEPS_XMLP_PKG.cf_format_mask1(budget_unit_id) CF_Format_Mask1 from pqh_position_element_types_v where element_type_id = :p_element_type_id And pqh_mgmt_rpt_pkg.check_pos_type_and_variance ( null, position_id, :p_start_date, :p_end_date, budget_unit_id , :p_position_type, NVL(:p_variance_percent,0) , :p_currency_code ) = NVL(:p_position_type,'A') PQH PQHWSEPS_XML AR PQH تقرير إجمالي عناصر المناصب (بتنسيق XML) Imported from BI Publisher Application: الموارد البشرية للقطاع العام Source: تقرير إجمالي عناصر المناصب (بتنسيق XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG D PQH Positionen - Elementübersicht Imported from BI Publisher Application: Public Sector HR Source: Positionen - Elementübersicht (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG E PQH Resumen de Elemento de Posición Imported from BI Publisher Application: Public Sector HR Source: Resumen de Elemento de Posición (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG F PQH Etat Synthèse des éléments de poste Imported from BI Publisher Application: Public Sector HR Source: Etat Synthèse des éléments de poste (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG I PQH Rapporto Sintetico elemento posizione Imported from BI Publisher Application: Public Sector HR Source: Rapporto Sintetico elemento posizione (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG JA PQH 職階エレメント要約レポート Imported from BI Publisher Application: Public Sector HR Source: 職階エレメント要約レポート(XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG KO PQH Position 항목 요약 보고서 Imported from BI Publisher Application: Public Sector HR Source: Position 항목 요약 보고서(XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG PTB PQH Relatório Sumariado do Elemento da Posição Imported from BI Publisher Application: Public Sector HR Source: Relatório Sumariado do Elemento da Posição (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG RU PQH Сводный отчет об элементах штатных единиц Imported from BI Publisher Application: Государственный сектор: персонал Source: Сводный отчет об элементах штатных единиц (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG S PQH Löneart för tjänst - översiktsrapport Imported from BI Publisher Application: Public Sector HR Source: Löneart för tjänst - översiktsrapport (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG TR PQH Pozisyon Kalemi Özet Raporu Imported from BI Publisher Application: Kamu Sektörü İnsan Kaynakları Yönetimi Source: Pozisyon Kalemi Özet Raporu (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG US PQH Position Element Summary Imported from BI Publisher Application: Public Sector HR Source: Position Element Summary Report (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG ZHS PQH 职位要素汇总报表 Imported from BI Publisher Application: Public Sector HR Source: 职位要素汇总报表 (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG BI Publisher :c_business_group_name :c_report_subtitle :cp_currency :cp_element_name :cp_position_type :cp_session_dt :lp_end_date :lp_start_date :p_business_group_id :p_conc_request_id :p_currency_code :p_effective_date :p_element_type_id :p_end_date :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') US P_business_group_id 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_position_type LOV Oracle PQH_POSITION_BUDGET_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='PQH_POSITION_TYPE' order by value,description Y AR نوع المنصب D Positionsart E Tipo de Posición F Type de poste I Tipo di posizione JA 職階タイプ KO Position 유형 PTB Tipo de Posição RU Тип штатной единицы S Tjänstetyp TR Pozisyon Tipi US Position Type ZHS 职位类型 5 40 :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 差异百分比 6 50 :p_start_date Date sysdate 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 起始日期 7 60 :p_end_date Date sysdate 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 终止日期 8 70 :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 币种