ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471FB51A9E05362FB09050512Y select papf.full_name, paf.assignment_number, ppf.payroll_name, decode(pepa.assignment_status,'P','Z',pepa.assignment_status) assignment_status FROM psp_enc_process_assignments pepa, per_all_assignments_f paf, pay_all_payrolls_f ppf, per_all_people_f papf WHERE paf.assignment_id = pepa.assignment_id AND ppf.payroll_id = pepa.payroll_id AND papf.person_id = paf.person_id AND pepa.payroll_action_id = :p_payroll_action_id AND paf.effective_start_date = (SELECT MAX(paf2.effective_start_date) FROM per_all_assignments_f paf2 WHERE paf2.assignment_id = pepa.assignment_id) AND ppf.effective_start_date = (SELECT MAX(ppf2.effective_start_date) From pay_all_payrolls_f ppf2 WHERE ppf2.payroll_id = pepa.payroll_id) AND papf.effective_start_date = (SELECT MAX(papf2.effective_start_date) FROM per_all_people_f papf2 WHERE papf2.person_id = paf.person_id) order by 4,3,1,2 PSP PSPENEXR_XML PTB PSP Relatório de Exceção de Liquidação do Empenho Imported from BI Publisher Description: Relatório de Exceção de Liquidação do Empenho Application: Distribuição da Mão de Obra Source: PSP: Relatório de Exceção de Liquidação do Empenho (XML) Short Name: PSPENEXR_XML DB package: PSP_PSPENEXR_XMLP_PKG US PSP Encumbrance Liquidation Exception Imported from BI Publisher Description: Encumbrance Liquidation Exception Report Application: Labor Distribution Source: PSP: Encumbrance Liquidation Exception Report (XML) Short Name: PSPENEXR_XML DB package: PSP_PSPENEXR_XMLP_PKG BI Publisher :cp_sort_by_detail :cp_sort_description2 :p_actual_select :p_business_group :p_conc_request_id :p_gl_application_id :p_gms_application_id :p_payroll_action_id :p_payroll_id :p_set_of_books_id :p_sort_by 1 -30 :p_business_group_id Char fnd_profile.value('PER_BUSINESS_GROUP_ID') PTB P_BUSINESS_GROUP_ID Grupo Funcional US P_BUSINESS_GROUP_ID Business Group 2 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') PTB P_SET_OF_BOOKS_ID Id do Razão US P_SET_OF_BOOKS_ID Ledger Id 3 10 :p_payroll_action_id LOV Oracle PSP_ENC_LQRP_PAY_ACTION_ID Y select pep.payroll_action_id id, pep.request_id value, null description from psp_enc_processes pep,fnd_concurrent_requests fcr,fnd_concurrent_programs_tl fcpt where fcr.request_id=pep.request_id and fcpt.concurrent_program_id=fcr.concurrent_program_id and pep.process_code='ST' and pep.process_phase='liquidate' and pep.business_group_id=fnd_global.per_business_group_id and pep.set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') and fcpt.language=userenv('LANG') order by pep.request_id desc Y PTB Id da Solicitação ID da Solicitação US Request Id Request ID 4 20 :p_sort_by LOV Oracle PSP_ENC_EXC_REPORT_SORT_BY Y select lookup_code id, meaning value, null description from psp_lookups pl where lookup_type='PSP_ENC_EXC_REP_SORT_OPTIONS' order by value,description PTB Classificar por Opção de Classificação US Sort By Sort Option