ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714651A9E05362FB09050512 select /*+ ORDERED */ asgs.blocked_asg blocked_asg, asgs.blocking_asg blocking_asg , peo.full_name full_name, hr_general.decode_lookup('ACTION_TYPE', pact.action_type), fnd_date.date_to_displaydate(pact.effective_date) effective_date, aact.assignment_action_id, hr_general.decode_lookup('ACTION_STATUS', aact.action_status) status, hr_general.decode_lookup('PAY_ASSIGNT_NOT_PROCESS',sign(to_number(:LP_EFFECTIVE_DATE - pact.effective_date))) Reason, payroll_name, fnd_date.date_to_displayDT(sysdate) today , PAY_PAYRPBLK1_XMLP_PKG.cf_q1_data_foundformula() CF_Q1_data_found from ( select asg.person_id person_id, asg.assignment_id blocked_asg_id, asg.assignment_number blocked_asg, as2.assignment_id blocking_asg_id, as2.assignment_number blocking_asg , asg.payroll_id blocked_asg_pi, as2.payroll_id blocking_asg_pi, min(asg.effective_start_date) blocked_asg_sd, max(asg.effective_end_date) blocked_asg_ed, min(as2.effective_start_date) blocking_asg_sd, max(as2.effective_end_date) blocking_asg_ed from per_assignments_f asg, per_all_assignments_f as2 where asg.payroll_id = :p_payroll_id and as2.period_of_service_id = asg.period_of_service_id and as2.payroll_id is not null and (( asg.assignment_id = as2.assignment_id ) or exists ( select null from PAY_LEGISLATION_RULES PLR, PER_BUSINESS_GROUPS_PERF GRP /* check the time dependency rule */ where PLR.RULE_TYPE = 'I' and PLR.RULE_MODE = 'N' and PLR.LEGISLATION_CODE = GRP.LEGISLATION_CODE and GRP.BUSINESS_GROUP_ID = :p_business_group_id)) and :LP_EFFECTIVE_DATE between asg.effective_start_date and asg.effective_end_date group by asg.person_id, asg.assignment_id, asg.assignment_number, as2.assignment_id, as2.assignment_number, asg.payroll_id, as2.payroll_id) asgs, pay_assignment_actions aact, pay_payroll_actions pact, pay_action_classifications pcl, pay_payrolls_f roll, per_people_f peo where (( pact.effective_date > :LP_EFFECTIVE_DATE) or ( pact.effective_date <= :LP_EFFECTIVE_DATE and aact.action_status <> 'C' )) and pact.effective_date between asgs.blocking_asg_sd and asgs.blocking_asg_ed and peo.person_id = asgs.person_id and pact.effective_date between peo.effective_start_date and peo.effective_end_date and pact.payroll_action_id = aact.payroll_action_id and aact.assignment_id = asgs.blocking_asg_id and aact.source_action_id is null and pact.payroll_action_id = aact.payroll_action_id and pcl.action_type = pact.action_type and pcl.classification_name = 'SEQUENCED' and roll.payroll_id = :p_payroll_id and :LP_EFFECTIVE_DATE between roll.effective_start_date and roll.effective_end_date /*order by asg.assignment_number,pact.effective_date*/ order by PAYROLL_NAME, BLOCKED_ASG, BLOCKING_ASG, full_name, today Y PAY PAYRPBLK_XML AR PAY التعيينات غير المتاحة للمعالجة (بتنسيق XML) Imported from BI Publisher Description: سرد التعيينات الموجودة في كشف رواتب لن يتم انتقاؤه أثناء التشغيل Application: كشوف الرواتب Source: التعيينات غير المتاحة للمعالجة (بتنسيق XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG D PAY Stellen für Verarbeitung nicht verfügbar Imported from BI Publisher Description: Die Stellen in einer Lohn- und Gehaltsabrechnung auflisten, die bei dem Lauf nicht berücksichtigt werden Application: Lohn und Gehalt Source: Stellen für Verarbeitung nicht verfügbar (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG E PAY Asignaciones No Disponibles para Procesamiento Imported from BI Publisher Description: Listar las asignaciones sobre una nómina que no se van a seleccionar en la ejecución Application: Payroll Source: Asignaciones No Disponibles para Procesamiento (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG F PAY Affectations non disponibles pour traitement Imported from BI Publisher Description: Lister les affectations sur une paye qui n'est pas incluse dans l'exécution Application: Payroll Source: Affectations non disponibles pour traitement (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG I PAY Assegnazioni non disponibili per l'elaborazione Imported from BI Publisher Description: Elenca le assegnazioni di un ciclo paghe che non verranno incluse nell'esecuzione Application: Payroll Source: Assegnazioni non disponibili per l'elaborazione (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG JA PAY 処理時に除かれるアサイメントのレポート Imported from BI Publisher Description: 給与計算実行で選択されないアサイメントのリスト Application: Payroll Source: 処理時に除かれるアサイメントのレポート(XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG KO PAY 처리에 사용할 수 없는 발령 Imported from BI Publisher Description: 급여 명부에서 실행 시 선택되지 않을 발령을 나열 Application: Payroll Source: 처리에 사용할 수 없는 발령(XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG PTB PAY Atribuições Indisponíveis para Processamento Imported from BI Publisher Description: Listar as atribuições de uma folha de pagamento que não serão selecionadas durante a execução Application: Folha de Pagto. Source: Atribuições Indisponíveis para Processamento (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG RU PAY Недоступные при обработке назначения Imported from BI Publisher Description: Список назначений ведомости, которые не будут учитываться при обработке Application: Заработная плата Source: Недоступные при обработке назначения (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG S PAY Anst.uppdrag som ej är tillgängliga för bearbetning Imported from BI Publisher Description: Lista uppdragen i en lönegrupp som inte kommer att inkluderas i körningen Application: Payroll Source: Anst.uppdrag som ej är tillgängliga för bearbetning (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG TR PAY İşlem için Kullanılamayan Görevler Imported from BI Publisher Description: Çalışma sırasında alınamayacak bir bordrodaki görevleri listeler Application: Bordro Source: İşlem için Kullanılamayan Görevler (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG US PAY Assignments Unavailable for Processing Imported from BI Publisher Description: List the assignments on a payroll who won't be picked up in the run Application: Payroll Source: Assignments Unavailable for Processing (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG ZHS PAY 不能进行处理的分配 Imported from BI Publisher Description: 列出运行时不会被挑选的工资单分配 Application: 工资单 Source: 不能进行处理的分配 (XML) Short Name: PAYRPBLK_XML DB package: PAY_PAYRPBLK1_XMLP_PKG BI Publisher :c_effective_date :cp_payroll_name :cp_q1_no_data_found :cp_q2_no_data_found :lp_effective_date :p_business_group_id :p_conc_request_id :p_effective_date :p_payroll_id 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_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 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 工资单名称 工资单标识 3 20 :p_effective_date Date select regular_payment_date from per_time_periods p,fnd_sessions f where p.payroll_id = :$flex$.payroll_name and f.session_id = userenv('sessionid') and f.effective_date between p.start_date and p.end_date Y AR تاريخ الفعالية تاريخ الفعالية D Gültigkeitsdatum Gültigkeitsdatum E Fecha en Vigor Fecha en Vigor F Date de validité Date de validité I Data di validità Data di validità JA 有効日 有効日 KO 유효 일자 유효 일자 PTB Data de Efetivação Data de Efetivação RU Дата действия Дата действия S Giltighetsdatum Giltighetsdatum TR Geçerlilik Tarihi Geçerlilik Tarihi US Effective Date Effective Date ZHS 有效日期 有效日期 :$flex$.payroll_name Payroll Name Effective Date