ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2773869E053B46B63588994 SELECT INTERFACE_RUN_ID_PAY , BATCH_ID , PAYROLL_NAME , PAYROLL_ID , ORGANIZATION_NAME , ORGANIZATION_ID , ELEMENT_TYPE_ID , ELEMENT_NAME , REPORTING_NAME , OUTPUT_CURRENCY_CODE , TIME_PERIOD_ID , TIME_PERIOD_START_DATE, TIME_PERIOD_END_DATE , SOURCE_START_DATE, SOURCE_END_DATE, CLASSIFICATION , AMOUNT FROM ( SELECT PPA.INTERFACE_RUN_ID INTERFACE_RUN_ID_PAY , PCV.PAYROLL_ACTION_ID BATCH_ID , PCV.PAYROLL_NAME , PCV.PAYROLL_ID , PCV.ORGANIZATION_NAME , PCV.ORGANIZATION_ID , PCV.ELEMENT_TYPE_ID , PCV.ELEMENT_NAME , PCV.REPORTING_NAME , PCV.OUTPUT_CURRENCY_CODE , PCV.TIME_PERIOD_ID , PCV.TIME_PERIOD_START_DATE , PCV.TIME_PERIOD_END_DATE , NVL(PCV.SOURCE_START_DATE,PCV.TIME_PERIOD_START_DATE) SOURCE_START_DATE, NVL(PCV.SOURCE_END_DATE,PCV.TIME_PERIOD_END_DATE) SOURCE_END_DATE, CLASSIFICATION_NAME CLASSIFICATION , SUM(PCV.DEBIT_AMOUNT- PCV.CREDIT_AMOUNT) AMOUNT FROM PAY_COSTING_PROJECTS_V PCV, PA_PAY_AUDIT PPA WHERE BALANCE_OR_COST = 'C' AND PPA.INTERFACE_RUN_ID = NVL(:P_INTERFACE_RUN_ID ,PPA.INTERFACE_RUN_ID) AND PCV.ORGANIZATION_ID = NVL(:P_EMP_ORG,PCV.ORGANIZATION_ID ) AND PCV.PERSON_ID = NVL(:P_PERSON_ID , PCV.PERSON_ID ) AND PCV.PAYROLL_ACTION_ID = PPA.BATCH_ID AND PPA.INT_EXT_INDICATOR = 'INT' AND PPA.PAYROLL_ID = PCV.PAYROLL_ID AND TRUNC(NVL(PPA.SOURCE_START_DATE,PPA.PAY_PERIOD_START_DATE)) = TRUNC(NVL(PCV.SOURCE_START_DATE,PCV.TIME_PERIOD_START_DATE)) AND TRUNC(NVL(PPA.SOURCE_END_DATE,PPA.PAY_PERIOD_END_DATE)) = TRUNC(NVL(PCV.SOURCE_END_DATE,PCV.TIME_PERIOD_END_DATE)) GROUP BY PPA.INTERFACE_RUN_ID , PCV.PAYROLL_ACTION_ID , PCV.PAYROLL_NAME , PCV.PAYROLL_ID , ORGANIZATION_NAME , ORGANIZATION_ID , ELEMENT_TYPE_ID , ELEMENT_NAME , REPORTING_NAME , OUTPUT_CURRENCY_CODE , PCV.TIME_PERIOD_ID , PCV.TIME_PERIOD_START_DATE, PCV.TIME_PERIOD_END_DATE , NVL(PCV.SOURCE_START_DATE,PCV.TIME_PERIOD_START_DATE) , NVL(PCV.SOURCE_END_DATE,PCV.TIME_PERIOD_END_DATE) , CLASSIFICATION_NAME UNION SELECT PPA.INTERFACE_RUN_ID INTERFACE_RUN_ID_PAY , PCV.PAYROLL_BATCH_ID BATCH_ID , PPE.PAYROLL_NAME , PCV.PAYROLL_ID , PCV.EMP_ORGANIZATION_NAME ORGANIZATION_NAME , PCV.EMP_ORGANIZATION_ID ORGANIZATION_ID , NULL AS ELEMENT_TYPE_ID , PCV.PAY_ELEMENT_TYPE_CODE ELEMENT_NAME , PL.MEANING REPORTING_NAME , PCV.PAY_CURRENCY_CODE , PCV.TIME_PERIOD_ID , PCV.TIME_PERIOD_START_DATE , PCV.TIME_PERIOD_END_DATE , NULL, NULL, (CASE WHEN PREDEFINED_FLAG = 'E' THEN 'Earnings' WHEN PREDEFINED_FLAG = 'I' THEN 'Informational' WHEN PREDEFINED_FLAG = 'S' THEN 'Supplemental Earnings' WHEN PREDEFINED_FLAG = 'T' THEN 'Employer Taxes' WHEN PREDEFINED_FLAG = 'L' THEN 'Employer Liabilities' WHEN PREDEFINED_FLAG = 'O' THEN 'Other' WHEN PREDEFINED_FLAG IS NULL THEN 'Other' END) CLASSIFICATION , SUM(PAY_AMOUNT) AMOUNT FROM PA_PAY_EXT_INTERAFACE_V PCV, PA_PAY_AUDIT PPA , PA_PAY_EXTERNAL_PAYROLL PPE, PA_LOOKUPS PL WHERE PPA.INTERFACE_RUN_ID = NVL(:P_INTERFACE_RUN_ID, PPA.INTERFACE_RUN_ID) AND PCV.EMP_ORGANIZATION_ID = NVL(:P_EMP_ORG, PCV.EMP_ORGANIZATION_ID ) AND PCV.PERSON_ID = NVL(:P_PERSON_ID , PCV.PERSON_ID ) AND PL.lookup_type = 'PA_THIRD_PARTY_PAY_ELEMENTS' AND NVL(PREDEFINED_FLAG,'E') IN ('E','I') AND PCV.PAY_ELEMENT_TYPE_CODE = PL.LOOKUP_CODE AND PCV.PAYROLL_BATCH_ID = PPA.BATCH_ID AND PPA.INT_EXT_INDICATOR = 'EXT' AND PPA.PAYROLL_ID = PCV.PAYROLL_ID AND TRUNC(PPA.PAY_PERIOD_START_DATE) = TRUNC( PCV.TIME_PERIOD_START_DATE) AND TRUNC(PPA.PAY_PERIOD_END_DATE) = TRUNC(PCV.TIME_PERIOD_END_DATE) AND PCV.PAYROLL_ID = PPE.PAYROLL_ID GROUP BY PPA.INTERFACE_RUN_ID , PCV.PAYROLL_BATCH_ID , PPE.PAYROLL_NAME , PCV.PAYROLL_ID , PCV.EMP_ORGANIZATION_NAME , PCV.EMP_ORGANIZATION_ID , PCV.PAY_ELEMENT_TYPE_CODE , PL.MEANING , PAY_CURRENCY_CODE , PCV.TIME_PERIOD_ID , PCV.TIME_PERIOD_START_DATE, PCV.TIME_PERIOD_END_DATE , ( CASE WHEN PREDEFINED_FLAG = 'E' THEN 'Earnings' WHEN PREDEFINED_FLAG = 'I' THEN 'Informational' WHEN PREDEFINED_FLAG = 'S' THEN 'Supplemental Earnings' WHEN PREDEFINED_FLAG = 'T' THEN 'Employer Taxes' WHEN PREDEFINED_FLAG = 'L' THEN 'Employer Liabilities' WHEN PREDEFINED_FLAG = 'O' THEN 'Other' WHEN PREDEFINED_FLAG IS NULL THEN 'Other' END) ) ORDER BY BATCH_ID , PAYROLL_ID , TIME_PERIOD_ID , OUTPUT_CURRENCY_CODE, CLASSIFICATION Y PA PAPAYEXC AR PA تقرير استثناء معالجة استحقاقات كشف الرواتب Application: المشروعات Source: PRC: تقرير استثناء معالجة استحقاقات كشف الرواتب Short Name: PAPAYEXC DB package: D PA Istbeträge der Lohn- und Gehaltsabrechnung verarbeiten(2) Application: Projects Source: PA: Istbeträge der Lohn- und Gehaltsabrechnung verarbeiten(2) Short Name: PAPAYEXC DB package: F PA Etat Exception de traitement des montants réels de paie Application: Projects Source: PRC : Etat Exception de traitement des montants réels de paie Short Name: PAPAYEXC DB package: US PA Process Payroll Actuals Exception Application: Projects Source: PRC: Process Payroll Actuals Exception Report Short Name: PAPAYEXC DB package: ZHS PA PRC：处理工资单应计项例外报表 Application: 项目 Source: PRC：处理工资单应计项例外报表 Short Name: PAPAYEXC DB package: BI Publisher :operating_unit :p_emp_org :p_interface_run_id :p_person_id 1 10 :p_interface_run_id LOV Oracle PA_PAY_INTERFACE_RUN_ID Y select pap.interface_run_id id, pap.interface_run_id value, pap.description description from pa_pay_costed_set_lov_v pap where 1=1 order by pap.interface_run_id desc,pap.run_sequence desc AR معرف مجموعة كشف رواتب محددة التكاليف D Kennung verrechnetes Lohn- und GehaltSet F ID jeu de paies valorisé US Costed Payroll Set ID ZHS 工资单成本集标识 2 20 :p_exp_org LOV Oracle PA_SRS_EXPENDITURE_ORG Y select organization_id id, name value, null description from pa_organizations_expend_v order by name AR تنظيم المصروفات D Aufwandsorganisation F Organisation des dépenses US Expenditure Organization ZHS 支出组织 3 30 :p_person_id LOV Oracle PA_SRS_EMPLOYEE_LOV Y Y select person_id id, full_name value, employee_number description from pa_employees order by full_name AR الموظف D Mitarbeiter F Employé US Employee ZHS 员工