ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714A51A9E05362FB09050512Y select ppf.full_name Employee_name , paf.assignment_number Assignment_Number , paa2.serial_number Payment_Number , ppa2.effective_date Payment_Date , ppa1.effective_date Void_Date , ppp.value Amount , ppef.payroll_name Payroll_Name , pcs.consolidation_set_name Consolidation_Set , htu.name GRE_name, DECODE(ppa2.action_type,'M',SUBSTRB(hr_general.decode_lookup('PAY_METHOD_PAYMENT_TYPE','DEPOSIT'),1,8),'Check') payment_type, --&payment_type C_Payment_Type PAY_PAYRPVPR_XMLP_PKG.C_Payment_TypeFormula(DECODE(ppa2.action_type,'M',SUBSTRB(hr_general.decode_lookup('PAY_METHOD_PAYMENT_TYPE','DEPOSIT'),1,8),'Check')) C_Payment_Type from pay_payroll_actions ppa1, pay_assignment_actions paa1, pay_action_interlocks pai1, pay_assignment_actions paa2, pay_payroll_actions ppa2, per_assignments_f paf, per_people_f ppf, pay_action_interlocks pai2, pay_assignment_actions paa3, pay_payroll_actions ppa3, hr_organization_units htu, pay_payrolls_f ppef, pay_pre_payments ppp, pay_consolidation_sets pcs where ppa1.business_group_id + 0 = :p_business_group_id and :p_uk_us = 'US' and ppa1.action_type = 'D' and ppa1.effective_date between :p_start_date and :p_end_date and ppa1.payroll_action_id = paa1.payroll_action_id and paa1.assignment_action_id = pai1.locking_action_id and pai1.locked_action_id = paa2.assignment_action_id and paa2.payroll_action_id = ppa2.payroll_action_id and paa2.assignment_id = paf.assignment_id and paf.person_id = ppf.person_id and ppa2.effective_date between ppf.effective_start_date and ppf.effective_end_date and ppa2.effective_date between paf.effective_start_date and paf.effective_end_date and pai2.locking_action_id = paa2.assignment_action_id and paa3.assignment_action_id = pai2.locked_action_id and paa3.payroll_action_id = ppa3.payroll_action_id and ppa3.payroll_id = ppef.payroll_id and paa2.pre_payment_id = ppp.pre_payment_id and ppa2.effective_date between ppef.effective_start_date and ppef.effective_end_date and htu.organization_id = paa2.tax_unit_id and ppa3.consolidation_set_id = pcs.consolidation_set_id and htu.business_group_id = :p_business_group_id &where_optional union select ppf.full_name Employee_name , paf.assignment_number Assignment_Number , paa2.serial_number Payment_Number , ppa2.effective_date Payment_Date , ppa1.effective_date Void_Date , ppp.value Amount , ppef.payroll_name Payroll_Name , pcs.consolidation_set_name Consolidation_Set , to_char(null) GRE_name, decode(ppa2.action_type,'M',SUBSTRB(hr_general.decode_lookup('PAY_METHOD_PAYMENT_TYPE','DEPOSIT'),1,8),'Cheque') payment_type, --&payment_type C_Payment_Type PAY_PAYRPVPR_XMLP_PKG.C_Payment_TypeFormula(decode(ppa2.action_type,'M',SUBSTRB(hr_general.decode_lookup('PAY_METHOD_PAYMENT_TYPE','DEPOSIT'),1,8),'Cheque')) C_Payment_Type from pay_payroll_actions ppa1, pay_assignment_actions paa1, pay_action_interlocks pai1, pay_assignment_actions paa2, pay_payroll_actions ppa2, per_assignments_f paf, per_people_f ppf, pay_action_interlocks pai2, pay_assignment_actions paa3, pay_payroll_actions ppa3, pay_payrolls_f ppef, pay_pre_payments ppp, pay_consolidation_sets pcs where ppa1.business_group_id + 0 = :p_business_group_id and :p_uk_us <> 'US' and ppa1.action_type = 'D' and ppa1.effective_date between :p_start_date and :p_end_date and ppa1.payroll_action_id = paa1.payroll_action_id and paa1.assignment_action_id = pai1.locking_action_id and pai1.locked_action_id = paa2.assignment_action_id and paa2.payroll_action_id = ppa2.payroll_action_id and paa2.assignment_id = paf.assignment_id and paf.person_id = ppf.person_id and ppa2.effective_date between ppf.effective_start_date and ppf.effective_end_date and ppa2.effective_date between paf.effective_start_date and paf.effective_end_date and pai2.locking_action_id = paa2.assignment_action_id and paa3.assignment_action_id = pai2.locked_action_id and paa3.payroll_action_id = ppa3.payroll_action_id and ppa3.payroll_id = ppef.payroll_id and paa2.pre_payment_id = ppp.pre_payment_id and ppa2.effective_date between ppef.effective_start_date and ppef.effective_end_date and ppa3.consolidation_set_id = pcs.consolidation_set_id &where_optional order by Employee_name &order_optional PAY PAYRPVPR_XML AR PAY تقرير المدفوعات اللاغية (بتنسيق XML) Imported from BI Publisher Description: تقرير المدفوعات اللاغية Application: كشوف الرواتب Source: تقرير المدفوعات اللاغية (بتنسيق XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG D PAY Zahlungen annullieren Imported from BI Publisher Description: Auswertung "Zahlungen annullieren" Application: Lohn und Gehalt Source: Zahlungen annullieren (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG E PAY Informe Pagos Anulados Imported from BI Publisher Description: Informe Anulación de Pagos Application: Payroll Source: Informe Pagos Anulados (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG F PAY Etat des règlements annulés Imported from BI Publisher Description: Etat des règlements annulés Application: Payroll Source: Etat des règlements annulés (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG I PAY Rapporto Pagamenti annullati Imported from BI Publisher Description: Rapporto Pagamenti annullati Application: Payroll Source: Rapporto Pagamenti annullati (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG JA PAY 無効支払レポート Imported from BI Publisher Description: 無効支払レポート Application: Payroll Source: 無効支払レポート(XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG KO PAY 무효 지급 보고서 Imported from BI Publisher Description: 무효 지급 보고서 Application: Payroll Source: 무효 지급 보고서(XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG PTB PAY Relatório de Pagamentos Anulados Imported from BI Publisher Description: Relatório de Pagamentos Anulados Application: Folha de Pagto. Source: Relatório de Pagamentos Anulados (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG RU PAY Отчет об аннулированных платежах Imported from BI Publisher Description: Отчет об аннулированных платежах Application: Заработная плата Source: Отчет об аннулированных платежах (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG S PAY Makulerade betalningar - rapport Imported from BI Publisher Description: Makulerade betalningar - rapport Application: Payroll Source: Makulerade betalningar - rapport (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG TR PAY Hükümsüz Ödemeler Raporu Imported from BI Publisher Description: Hükümsüz Ödemeler Raporu Application: Bordro Source: Hükümsüz Ödemeler Raporu (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG US PAY Void Payments Imported from BI Publisher Description: Void Payments Report Application: Payroll Source: Void Payments Report (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG ZHS PAY 撤消付款报表 Imported from BI Publisher Description: 撤消付款报表 Application: 工资单 Source: 撤消付款报表 (XML) Short Name: PAYRPVPR_XML DB package: PAY_PAYRPVPR_XMLP_PKG BI Publisher &order_optional &payment_type &where_optional :c_business_group_name :c_consolidation_set_name :c_gre_name :c_payroll_name :c_session_date :order_optional :p_business_group_id :p_conc_request_id :p_consolidation_set_id :p_end_date :p_payment_type :p_payroll_id :p_start_date :p_tax_unit_id :p_uk_us :where_optional 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR معرف مجموعة الأعمال معرف مجموعة الأعمال D Kennung Unternehmensgruppe Kennung Unternehmensgruppe E Id Grupo de Trabajo Id Grupo de Trabajo F ID entité professionnelle ID entité professionnelle I Id business group Id del business group JA ビジネス・グループID ビジネス・グループID KO 업무 그룹 ID 업무 그룹 ID PTB ID do Grupo Funcional ID do Grupo Funcional RU Идентификатор бизнес-группы Идентификатор бизнес-группы S Id för verksamhetsgrupp Id för verksamhetsgrupp TR İş Grubu No İş Grubu No US Business Group ID Business Group ID ZHS 业务组标识 业务组标识 2 10 :p_start_date Date Y AR PY_SRS_START_DATE_STANDARD تاريخ البداية D PY_SRS_START_DATE_STANDARD Startdatum E PY_SRS_START_DATE_STANDARD Fecha de Inicio F PY_SRS_START_DATE_STANDARD Date de début I PY_SRS_START_DATE_STANDARD Data di inizio JA PY_SRS_START_DATE_STANDARD 開始日 KO PY_SRS_START_DATE_STANDARD 시작 일자 PTB PY_SRS_START_DATE_STANDARD Data Inicial RU PY_SRS_START_DATE_STANDARD Начальная дата S PY_SRS_START_DATE_STANDARD Startdatum TR PY_SRS_START_DATE_STANDARD Başlangıç Tarihi US PY_SRS_START_DATE_STANDARD Start Date ZHS PY_SRS_START_DATE_STANDARD 起始日期 3 20 :p_end_date Date Y AR PY_SRS_EFFECTIVE_DATE_STANDARD تاريخ النهاية D PY_SRS_EFFECTIVE_DATE_STANDARD Enddatum E PY_SRS_EFFECTIVE_DATE_STANDARD Fecha de Finalización F PY_SRS_EFFECTIVE_DATE_STANDARD Date de fin I PY_SRS_EFFECTIVE_DATE_STANDARD Data di fine JA PY_SRS_EFFECTIVE_DATE_STANDARD 終了日 KO PY_SRS_EFFECTIVE_DATE_STANDARD 종료 일자 PTB PY_SRS_EFFECTIVE_DATE_STANDARD Data Final RU PY_SRS_EFFECTIVE_DATE_STANDARD Конечная дата S PY_SRS_EFFECTIVE_DATE_STANDARD Slutdatum TR PY_SRS_EFFECTIVE_DATE_STANDARD Bitiş Tarihi US PY_SRS_EFFECTIVE_DATE_STANDARD End Date ZHS PY_SRS_EFFECTIVE_DATE_STANDARD 终止日期 4 30 :p_payroll_id LOV Oracle PAY_VOID_PMTS_PAYROLL_NAMES Y select ppf.payroll_id id, ppf.payroll_name value, null description from pay_payrolls_f ppf where ppf.business_group_id+0=fnd_global.per_business_group_id and exists (select 1 from pay_payroll_actions ppa2, pay_assignment_actions paa2, pay_action_interlocks pai2, pay_action_interlocks pai1, pay_assignment_actions paa1, pay_payroll_actions ppa1 where ppa1.business_group_id+0= fnd_global.per_business_group_id and ppa1.action_type='D' and ppa1.effective_date between to_date(:$flex$.py_srs_start_date_standard, 'YYYY/MM/DD HH24:MI:SS') and to_date(:$flex$.py_srs_effective_date_standard, 'YYYY/MM/DD HH24:MI:SS') and ppa1.payroll_action_id=paa1.payroll_action_id and paa1.assignment_action_id=pai1.locking_action_id and pai1.locked_action_id=pai2.locking_action_id and pai2.locked_action_id=paa2.assignment_action_id and paa2.payroll_action_id=ppa2.payroll_action_id and ppa2.payroll_id=ppf.payroll_id and ppa1.effective_date between ppf.effective_start_date and ppf.effective_end_date) order by ppf.payroll_name AR اسم كشف الرواتب معرف كشف الرواتب D Bezeichnung Lohn- und Gehaltsabrechnung Kennung Lohn- und Gehaltsabrechnung E Nombre de Nómina Id Nómina F Nom de la paie ID paie I Nome ciclo paghe Id del ciclo paghe JA 給与 給与ID KO 급여명 급여 ID PTB Nome da Folha de Pagamento ID da Folha de Pagamento RU Имя ведомости Идентификатор ведомости S Lönegrupp Lönegrupps-id TR Bordro Adı Bordro No US Payroll Name Payroll ID ZHS 工资单名称 工资单标识 5 40 :p_consolidation_set_id LOV Oracle PAY_VOID_PMTS_CONS_SET_NAMES Y select pcs.consolidation_set_id id, pcs.consolidation_set_name value, null description from pay_consolidation_sets pcs where pcs.business_group_id+0=fnd_global.per_business_group_id and pcs.consolidation_set_id in (select pcs2.consolidation_set_id from pay_consolidation_sets pcs2,pay_payroll_actions ppa where ppa.action_type='D' and ppa.effective_date between to_date(:$flex$.py_srs_start_date_standard, 'YYYY/MM/DD HH24:MI:SS') and to_date(:$flex$.py_srs_effective_date_standard, 'YYYY/MM/DD HH24:MI:SS') and pcs2.consolidation_set_id=ppa.consolidation_set_id) order by pcs.consolidation_set_name AR اسم مجموعة التجميع معرف مجموعة التجميع D Bezeichnung KonsolidierungSet Kennung KonsolidierungSet E Nombre de Juego de Consolidación Id Juego de Consolidación F Nom du jeu de consolidation ID jeu de consolidation I Nome gruppo di consolidamento Id del gruppo di consolidamento JA 連結セット名 連結セットID KO 급여 통합 세트명 급여 통합 세트 ID PTB Nome do Conjunto de Consolidações ID do Conjunto de Consolidações RU Имя консолидированного набора Идент. консолидированного набора S Namn på konsolideringsgrupp Id för konsolideringsgrupp TR Konsolidasyon Kümesi Adı Konsolidasyon Kümesi No US Consolidation Set Name Consolidation Set ID ZHS 合并集名称 合并集标识