ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2D73869E053B46B63588994Y SELECT br.std_bill_rate_schedule, br.bill_rate_organization_id, p.full_name employee, decode(p.current_npw_flag,'Y',p.npw_number,p.employee_number) employee_number, br.markup_percentage, br.rate, u.meaning unit, br.start_date_active start_date, br.end_date_active end_date FROM per_people_f p, pa_lookups u, pa_bill_rates br WHERE br.person_id = p.person_id and br.bill_rate_unit = u.lookup_code (+) and u.lookup_type (+) = 'UNIT' and nvl(:effective_date,br.start_date_active) between br.start_date_active and nvl(br.end_date_active, nvl(:effective_date,br.start_date_active)) and :schedule_type = 'EMPLOYEE' and sysdate between p.effective_start_date and p.effective_end_date and ( p.employee_number IS NOT NULL OR p.npw_number IS NOT NULL ) and br.std_bill_rate_schedule=:std_bill_rate_schedule_q_rate and br.bill_rate_organization_id=:organization_id_q_rate order by p.full_name, br.start_date_active PA PAXRWSBR_XML AR PA جداول الأسعار القياسية (بتنسيق XML) Application: المشروعات Source: IMP: جداول الأسعار القياسية (بتنسيق XML) Short Name: PAXRWSBR_XML DB package: PA_PAXRWSBR_XMLP_PKG D PA Standard-Verrechnungssatztabellen Application: Projects Source: IMP: Standard-Verrechnungssatztabellen (XML) Short Name: PAXRWSBR_XML DB package: PA_PAXRWSBR_XMLP_PKG F PA Barèmes de taux standard Application: Projects Source: IMP : Barèmes de taux standard (XML) Short Name: PAXRWSBR_XML DB package: PA_PAXRWSBR_XMLP_PKG US PA Standard Rate Schedules Application: Projects Source: IMP: Standard Rate Schedules (XML) Short Name: PAXRWSBR_XML DB package: PA_PAXRWSBR_XMLP_PKG ZHS PA IMP：标准费率分摊计划 Application: 项目 Source: IMP：标准费率分摊计划 (XML) Short Name: PAXRWSBR_XML DB package: PA_PAXRWSBR_XMLP_PKG BI Publisher :c_company_name_header :c_org_name :effective_date :effective_date1 :operating_unit :organization_id :organization_id_q_rate :p_conc_request_id :p_rule_optimizer :schedule_type :std_bill_rate_schedule :std_bill_rate_schedule_q_rate 1 10 :organization_id LOV Oracle PA_SRS_ORGANIZATION_NAME Y Y select organization_id id, name value, null description from pa_organizations_v order by name AR المنشأة D Organisation F Organisation US Organization ZHS 组织 2 20 :std_bill_rate_schedule LOV Oracle PA_SRS_STANDARD_BILL_RATE_SCHEDULE Y select s.std_bill_rate_schedule id, s.std_bill_rate_schedule value, o.name description from pa_std_bill_rate_schedules s,pa_organizations_v o where s.organization_id=o.organization_id order by s.std_bill_rate_schedule AR جدول الأسعار القياسية D Standard-Verrechnungssatztabelle F Barème de taux standard US Standard Rate Schedule ZHS 标准费率分摊计划 3 30 :effective_date Date AR تاريخ الفعالية D Gültigkeitsdatum F Date de validité US Effective Date ZHS 有效日期