ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F00C3869E053B46B63588994Y select tim.FOR_PERSON_ID, tim.ID timecard_id, tim.PAYROLL_ID, tim.TIME_PERIOD_ID, per.LAST_NAME, per.FIRST_NAME, per.EMPLOYEE_NUMBER, per.FULL_NAME, per.PERSON_ID, tim.AUTO_GEN_FLAG, fcl.MEANING, HXT_HXT970A_XMLP_PKG.cf_status1formula(tim.ID) CF_STATUS1 from HXT_TIMECARDS_X tim, PER_PEOPLE_F per, FND_COMMON_LOOKUPS fcl, PER_TIME_PERIODS ptp where tim.TIME_PERIOD_ID = :P_TIME_PERIOD_ID AND tim.PAYROLL_ID in ( SELECT ptp.payroll_id FROM per_time_periods ptp where ptp.time_period_id = :P_TIME_PERIOD_ID) AND tim.FOR_PERSON_ID = per.PERSON_ID AND (tim.AUTO_GEN_FLAG = 'M' OR tim.AUTO_GEN_FLAG = 'U') AND FCL.LOOKUP_CODE = tim.AUTO_GEN_FLAG AND sysdate BETWEEN NVL(START_DATE_ACTIVE, sysdate) AND NVL(END_DATE_ACTIVE, sysdate) AND FCL.APPLICATION_ID = 808 AND FCL.ENABLED_FLAG = 'Y' AND (FCL.LOOKUP_TYPE = 'HXT_TIMECARD_SOURCE') AND FCL.LOOKUP_CODE = tim.AUTO_GEN_FLAG AND sysdate BETWEEN NVL(START_DATE_ACTIVE, sysdate) AND NVL(END_DATE_ACTIVE, sysdate) AND FCL.APPLICATION_ID = 808 AND FCL.ENABLED_FLAG = 'Y' AND (FCL.LOOKUP_TYPE = 'HXT_TIMECARD_SOURCE') AND tim.TIME_PERIOD_ID = ptp.TIME_PERIOD_ID AND PER.EFFECTIVE_END_DATE >= ptp.START_DATE AND PER.EFFECTIVE_START_DATE <= ptp.END_DATE ORDER BY per.LAST_NAME HXT HXT970A_XML AR HXT تقرير التكوين الآلي واليدوي Application: الوقت والعمالة Source: تقرير التكوين الآلي واليدوي (XML) Short Name: HXT970A_XML DB package: HXT_HXT970A_XMLP_PKG D HXT Manuell und Automatisch generiert Application: Time and Labor Source: Manuell und Automatisch generiert (XML) Short Name: HXT970A_XML DB package: HXT_HXT970A_XMLP_PKG F HXT Saisies manuelles et générées automatiquement Application: Time and Labor Source: Saisies manuelles et générées automatiquement (XML) Short Name: HXT970A_XML DB package: HXT_HXT970A_XMLP_PKG US HXT Manual and Autogen Application: Time and Labor Source: Manual and Autogen Report (XML) Short Name: HXT970A_XML DB package: HXT_HXT970A_XMLP_PKG ZHS HXT 人工和自动生成报表 Application: 时间和人工管理系统 Source: 人工和自动生成报表 (XML) Short Name: HXT970A_XML DB package: HXT_HXT970A_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 时间期