ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2CB3869E053B46B63588994Y SELECT upper(decode(:sort_by, 'EMPLOYEE NAME', p.last_name, 'EMPLOYEE NUMBER', DECODE(p.current_employee_flag,'Y',p.employee_number,p.npw_number), 'ORGANIZATION' ,substr(o.name,1,60), 'JOB LEVEL' ,jd.segment1, 'JOB DISCIPLINE',jd.segment2, 'COMP RULE SET' , PA_COST_RATE_PUB.GetEmpCostRateInfo(p.person_id,a.job_id,a.organization_id,trunc(nvl(:effective_date,sysdate)),'RULE','R'), p.last_name)) sort_by_value , p.full_name , DECODE(p.current_employee_flag,'Y',p.employee_number,p.npw_number) employee_number , substr(o.name,1,60) organization , j.name job ,PA_COST_RATE_PUB.GetEmpCostRateInfo(p.person_id,a.job_id,a.organization_id,trunc(nvl(:effective_date,sysdate)),'RULE','R') compensation_rule_set ,PA_COST_RATE_PUB.GetEmpCostRateInfo(p.person_id,a.job_id,a.organization_id,trunc(nvl(:effective_date,sysdate)),'CURR','R') rate_curr ,PA_COST_RATE_PUB.GetEmpCostRate(p.person_id,a.job_id,a.organization_id,trunc(nvl(:effective_date,sysdate)),'DENOM','R') hourly_cost_rate , PA_COST_RATE_PUB.GetEmpCostRateInfo(p.person_id,a.job_id,a.organization_id,trunc(nvl(:effective_date,sysdate)),'START','R') start_date_active ,PA_COST_RATE_PUB.GetEmpCostRateInfo(p.person_id,a.job_id,a.organization_id,trunc(nvl(:effective_date,sysdate)),'END','R') end_date_active FROM per_job_definitions jd , per_jobs j , hr_organization_units o , per_assignments_f a , per_people_f p WHERE PA_COST_RATE_PUB.GetEmpCostRate(p.person_id,a.job_id,a.organization_id,trunc(nvl(:effective_date,sysdate)),'DENOM','R') >= 0 and (:p_compensation_rule_set is null or :p_compensation_rule_set = PA_COST_RATE_PUB.GetEmpCostRateInfo(p.person_id,a.job_id,a.organization_id,trunc(nvl(:effective_date,sysdate)),'RULE','R') ) and trunc(nvl(:effective_date,sysdate)) between p.effective_start_date and p.effective_end_date and p.person_id= a.person_id and a.assignment_Type IN ('E','C') and a.primary_flag = 'Y' and trunc(nvl(:effective_date,sysdate)) between a.effective_start_date and a.effective_end_date and a.organization_id = o.organization_id and a.job_id = j.job_id(+) and j.job_definition_id = jd.job_definition_id(+) and (:job_level is null or (:job_level is not null and jd.segment1 = :job_level)) and (:job_discipline is null or (:job_discipline is not null and jd.segment2 = :job_discipline)) order by 1, 2, 3, 4, 5, 7, 6, 8 -- p.full_name,8 ,6 PA PAXRWLCR_XML AR PA قائمة أسعار تكاليف العمالة (بتنسيق XML) Application: المشروعات Source: IMP: قائمة أسعار تكاليف العمالة (بتنسيق XML) Short Name: PAXRWLCR_XML DB package: PA_PAXRWLCR_XMLP_PKG D PA Arbeitskostensätze Application: Projects Source: IMP: Arbeitskostensätze (XML) Short Name: PAXRWLCR_XML DB package: PA_PAXRWLCR_XMLP_PKG F PA Liste des coûts de main-d'oeuvre Application: Projects Source: IMP: Liste des coûts de main-d'oeuvre (XML) Short Name: PAXRWLCR_XML DB package: PA_PAXRWLCR_XMLP_PKG US PA Labor Cost Rates Listing Application: Projects Source: IMP: Labor Cost Rates Listing (XML) Short Name: PAXRWLCR_XML DB package: PA_PAXRWLCR_XMLP_PKG ZHS PA IMP：人工成本费率列表 Application: 项目 Source: IMP：人工成本费率列表 (XML) Short Name: PAXRWLCR_XML DB package: PA_PAXRWLCR_XMLP_PKG BI Publisher :c_company_name_header :c_sort_by_name :effective_date :job_discipline :job_level :operating_unit :p_compensation_rule_set :p_conc_request_id :sort_by 1 10 :sort_by LOV Oracle PA_SRS_LABOR_SORT_BY Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='LABOR RATE SORT BY' order by meaning AR فرز الموظفين حسب D Mitarbeiter sortieren nach F Tri des employés par US Sort Employees By ZHS 员工排序依据 2 20 :effective_date Date select sysdate from dual Y AR تاريخ الفعالية D Gültigkeitsdatum F Date de validité US Effective Date ZHS 有效日期 3 30 :job_level LOV Oracle PA_SRS_JOB_LEVEL Y select job_level id, job_level value, null description from pa_job_levels_v order by value,description AR مستوى الوظيفة D Tätigkeitsebene F Niveau de fonction US Job Level ZHS 职务级别 4 40 :job_discipline LOV Oracle PA_SRS_JOB_DISCIPLINE Y select job_discipline id, job_discipline value, null description from pa_job_disciplines_v order by job_discipline AR النظام الوظيفي D Tätigkeitsart F Poste US Job Discipline ZHS 作业领域 5 50 :p_compensation_rule_set LOV Oracle PA_SRS_COMPENSATION_RULE_SET Y select compensation_rule_set id, compensation_rule_set value, null description from pa_compensation_rule_sets order by compensation_rule_set AR قاعدة تحديد تكلفة العمالة D Arbeitskostenregel F Règle de valorisation des coûts de main-d'oeuvre US Labor Costing Rule ZHS 人工成本计算规则