ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0013869E053B46B63588994Y SELECT ALL pet1.effective_start_date effective_start_date, pet1.effective_end_date effective_end_date, pet2.effective_start_date effective_start_date1, pet2.effective_end_date effective_end_date1, hxt_work_shifts.sht_id, hxt_shifts.id id1, hxt_work_shifts.week_day, hxt_shifts.NAME NAME1, hxt_shifts.early_start, hxt_shifts.late_stop, hxt_shifts.standard_start, hxt_shifts.standard_stop, hxt_work_shifts.off_shift_prem_id, pet2.element_name off_shift_premium, hxt_work_shifts.shift_diff_ovrrd_id, pet1.element_name shift_diff_override, hxt_work_shifts.tws_id FROM pay_element_types_f pet1, pay_element_types_f pet2, hxt_work_shifts, hxt_shifts WHERE hxt_shifts.id = hxt_work_shifts.sht_id AND hxt_work_shifts.shift_diff_ovrrd_id = pet1.element_type_id(+) AND SYSDATE BETWEEN NVL (pet1.effective_start_date, SYSDATE) AND NVL (pet1.effective_end_date, SYSDATE) AND hxt_work_shifts.off_shift_prem_id = pet2.element_type_id(+) AND SYSDATE BETWEEN NVL (pet2.effective_start_date, SYSDATE) AND NVL (pet2.effective_end_date,SYSDATE) and hxt_work_shifts.tws_id=:ID HXT HXT957B_XML AR HXT قائمة جداول خطط العمل Application: الوقت والعمالة Source: قائمة جداول خطط العمل (XML) Short Name: HXT957B_XML DB package: HXT_HXT957B_XMLP_PKG D HXT Arbeitsplan - Tabelle Application: Time and Labor Source: Arbeitsplan - Tabelle (XML) Short Name: HXT957B_XML DB package: HXT_HXT957B_XMLP_PKG F HXT Données de la table des plans de travail Application: Time and Labor Source: Données de la table des plans de travail (XML) Short Name: HXT957B_XML DB package: HXT_HXT957B_XMLP_PKG US HXT Work Plan Table Listing Application: Time and Labor Source: Work Plan Table Listing (XML) Short Name: HXT957B_XML DB package: HXT_HXT957B_XMLP_PKG ZHS HXT 工作计划表 Application: 时间和人工管理系统 Source: 工作计划表 (XML) Short Name: HXT957B_XML DB package: HXT_HXT957B_XMLP_PKG BI Publisher :id :p_conc_request_id