ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F00B3869E053B46B63588994Y SELECT paf.person_id , emp.full_name , emp.employee_number FROM per_time_periods ptp , pay_payrolls_f ppf , per_people_f emp , per_assignments_f paf , hxt_per_aei_ddf_v pafv WHERE ptp.payroll_id = ppf.payroll_id AND ppf.payroll_id = paf.payroll_id AND emp.person_id = paf.person_id AND paf.assignment_id = pafv.assignment_id AND (ptp.start_date between pafv.effective_start_date and pafv.effective_end_date OR pafv.effective_start_date between ptp.start_date and ptp.end_date) AND (ptp.start_date between paf.effective_start_date AND paf.effective_end_date OR paf.effective_start_date between ptp.start_date AND ptp.end_date) AND paf.assignment_status_type_id = 1 AND (ptp.start_date between ppf.effective_start_date AND ppf.effective_end_date OR ppf.effective_start_date between ptp.start_date AND ptp.end_date) AND (ptp.start_date between emp.effective_start_date AND emp.effective_end_date OR emp.effective_start_date between ptp.start_date AND ptp.end_date) AND ptp.time_period_id = :P_TIME_PERIOD_ID AND ptp.time_period_id NOT IN (SELECT time_period_id from HXT_DET_HOURS_WORKED_X THW, HXT_TIMECARDS_X TTC where TTC.FOR_PERSON_ID = emp.PERSON_ID and THW.ASSIGNMENT_ID in ( SELECT paf.ASSIGNMENT_ID from per_assignments_f paf where ppf.payroll_id = paf.payroll_id AND emp.person_id = paf.person_id AND (ptp.start_date between paf.effective_start_date AND paf.effective_end_date OR paf.effective_start_date between ptp.start_date AND ptp.end_date) AND paf.assignment_status_type_id = 1 ) AND TTC.TIME_PERIOD_ID = :P_TIME_PERIOD_ID and TTC.ID = THW.TIM_ID and THW.PARENT_ID > 0) HXT HXT964A_XML AR HXT تقرير بطاقة قيد الوقت غير الموجودة في OTLR Application: الوقت والعمالة Source: تقرير بطاقة قيد الوقت غير الموجودة في OTLR (XML) Short Name: HXT964A_XML DB package: HXT_HXT964A_XMLP_PKG D HXT OTLR Fehlende Stundennachweise Application: Time and Labor Source: OTLR Fehlende Stundennachweise (XML) Short Name: HXT964A_XML DB package: HXT_HXT964A_XMLP_PKG F HXT OTLR - Etat Feuilles de temps manquantes Application: Time and Labor Source: OTLR - Etat Feuilles de temps manquantes (XML) Short Name: HXT964A_XML DB package: HXT_HXT964A_XMLP_PKG US HXT OTLR Missing Timecard Application: Time and Labor Source: OTLR Missing Timecard Report (XML) Short Name: HXT964A_XML DB package: HXT_HXT964A_XMLP_PKG ZHS HXT OTLR 缺少工时记录卡报表 Application: 时间和人工管理系统 Source: OTLR 缺少工时记录卡报表 (XML) Short Name: HXT964A_XML DB package: HXT_HXT964A_XMLP_PKG BI Publisher :p_conc_request_id :p_payroll_id :p_time_period_id 1 10 :p_payroll_id LOV Oracle PY_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay,fnd_sessions fnd where pay.business_group_id= fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name Y AR اسم كشف الرواتب D Bezeichnung Lohn- und Gehaltsabrechnung F Nom de la paie US Payroll Name ZHS 工资单名称 2 20 :p_time_period_id LOV Oracle HXT_TIME_PERIOD Y select ptp.time_period_id id, ptp.period_name value, null description from per_time_periods ptp where ptp.payroll_id=:$flex$.py_srs_payroll order by ptp.start_date Y AR الفترة الزمنية D Zeitperiode F Période US Time Period ZHS 时间期