ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2763869E053B46B63588994 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, to_char(TIME_PERIOD_START_DATE,'DD-MM-YYYY') TIME_PERIOD_START_DATE, to_char(TIME_PERIOD_END_DATE ,'DD-MM-YYYY') TIME_PERIOD_END_DATE, to_char(SOURCE_START_DATE,'DD-MM-YYYY') SOURCE_START_DATE, to_char(SOURCE_END_DATE,'DD-MM-YYYY') 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.REQUEST_ID = :P_REQUEST_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 PAYROLL_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 , 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) 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 PL.lookup_type = 'PA_THIRD_PARTY_PAY_ELEMENTS' AND Nvl(PREDEFINED_FLAG,'O') IN ('E','I','S','T','L','O') AND PCV.PAY_ELEMENT_TYPE_CODE = PL.LOOKUP_CODE AND PPA.REQUEST_ID = :P_REQUEST_ID 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 INTERFACE_RUN_ID_PAY , PAYROLL_ID , TIME_PERIOD_ID , OUTPUT_CURRENCY_CODE, CLASSIFICATION Y PA PAPAYAUD AR PA معالجة استحقاقات كشف الرواتب Application: المشروعات Source: AUD: معالجة استحقاقات كشف الرواتب Short Name: PAPAYAUD DB package: D PA Istbeträge der Lohn- und Gehaltsabrechnung verarbeiten(1) Application: Projects Source: PA: Istbeträge der Lohn- und Gehaltsabrechnung verarbeiten(1) Short Name: PAPAYAUD DB package: F PA Traitement des montants réels de la paie Application: Projects Source: AUD : Traitement des montants réels de la paie Short Name: PAPAYAUD DB package: US PA Process Payroll Actuals Application: Projects Source: AUD: Process Payroll Actuals Short Name: PAPAYAUD DB package: ZHS PA AUD：处理工资单应计项 Application: 项目 Source: AUD：处理工资单应计项 Short Name: PAPAYAUD DB package: BI Publisher :operating_unit :p_request_id 1 10 :p_from_date Date Y US PA_PAY_FROM_DATE 2 20 :p_to_date Date Y US PA_PAY_TO_DATE 3 30 :p_streamline LOV Oracle PA_SRS_YES_NO_LOV Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning Select meaning from fnd_lookup_values WHERE LOOKUP_TYPE = 'YES_NO' and lookup_code='N' and language = USERENV('LANG') Y AR تمكين المعالجة المتوالية D Optimierte Verarbeitung aktivieren F Activer les traitements en série US Enable Streamlined Processing ZHS 启用简化处理 4 40 :p_payroll_name LOV Oracle PA_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pa_pay_payrolls_f_v pay where business_group_id=fnd_global.per_business_group_id and ((pay.effective_start_date between fnd_date.canonical_to_date(:$flex$.pa_pay_from_date) and fnd_date.canonical_to_date(:$flex$.pa_pay_to_date)) or (nvl(pay.effective_end_date,fnd_date.canonical_to_date(:$flex$.pa_pay_to_date)) between fnd_date.canonical_to_date(:$flex$.pa_pay_from_date) and fnd_date.canonical_to_date(:$flex$.pa_pay_to_date)) or ((pay.effective_start_date<=fnd_date.canonical_to_date(:$flex$.pa_pay_from_date)) and (nvl(pay.effective_end_date,fnd_date.canonical_to_date(:$flex$.pa_pay_to_date))>=fnd_date.canonical_to_date(:$flex$.pa_pay_to_date)))or ((pay.effective_start_date>=fnd_date.canonical_to_date(:$flex$.pa_pay_from_date)) and (nvl(pay.effective_end_date,fnd_date.canonical_to_date(:$flex$.pa_pay_to_date))<=fnd_date.canonical_to_date(:$flex$.pa_pay_to_date))) ) order by value,description AR اسم كشف الرواتب D Bezeichnung Lohn- und Gehaltsabrechnung F Nom paie US Payroll Name ZHS 工资单名称 5 50 :p_emp_org LOV Oracle PA_SRS_EXPENDITURE_ORGANIZATION Y Y select organization_id id, name value, null description from pa_organizations_exp_all_bg_v order by name AR تنظيم الموظف D Mitarbeiter-Organisation F Organisation employés US Employee Organization ZHS 员工组织 6 60 :p_employee 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 员工 7 70 :p_request_id Char AR معرف الطلب D Prozessnummer F Numéro de traitement US Request ID ZHS 请求编号 :$flex$.pa_pay_from_date PA_PAY_FROM_DATE Y Payroll Name :$flex$.pa_pay_to_date PA_PAY_TO_DATE Y Payroll Name