ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471F651A9E05362FB09050512Y SELECT DISTINCT PPF.payroll_name payroll_name, PTP.start_date start_date, PTP.end_date end_date, PTP.period_name, 'A' func_area FROM PSP_PAYROLL_CONTROLS PPC, PER_TIME_PERIODS PTP, PAY_PAYROLLS_F PPF WHERE PPC.payroll_id = PPF.payroll_id and PPC.time_period_id = PTP.time_period_id and PPC.payroll_id = nvl(:p_payroll_id,PPF.payroll_id) and PTP.time_period_id >= nvl(:p_begin_period,PTP.time_period_id) and PTP.time_period_id <= nvl(:p_end_period,PTP.time_period_id) and PPC.archive_flag = 'Y' UNION SELECT DISTINCT PPF.payroll_name payroll_name, PTP.start_date start_date, PTP.end_date end_date, PTP.period_name, 'E' func_area FROM PSP_ENC_CONTROLS PEC, PER_TIME_PERIODS PTP, PAY_PAYROLLS_F PPF WHERE PEC.payroll_id = PPF.payroll_id and PEC.time_period_id = PTP.time_period_id and PEC.payroll_id = nvl(:p_payroll_id,PPF.payroll_id) and PTP.time_period_id >= nvl(:p_begin_period,PTP.time_period_id) and PTP.time_period_id <= nvl(:p_end_period,PTP.time_period_id) and PEC.archive_flag = 'Y' ORDER BY 1,2,5 PSP PSPARREP_XML PTB PSP Relatório de Histórico do Arquivo Imported from BI Publisher Description: Relatório do Histórico de Arquivo Application: Distribuição da Mão de Obra Source: PSP: Relatório de Histórico do Arquivo (XML) Short Name: PSPARREP_XML DB package: PSP_PSPARREP_XMLP_PKG US PSP Archive History Imported from BI Publisher Description: Archive History Report Application: Labor Distribution Source: PSP: Archive History Report (XML) Short Name: PSPARREP_XML DB package: PSP_PSPARREP_XMLP_PKG BI Publisher :p_begin_period :p_business_group_id :p_conc_request_id :p_end_period :p_payroll_id :p_set_of_books_id 1 -30 :p_business_group_id Char fnd_profile.value('PER_BUSINESS_GROUP_ID') PTB Id do Grupo Funcional Id do Grupo Funcional US Business Group ID Business Group ID 2 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') PTB ID do Razão ID do Razão US Ledger ID Ledger ID 3 10 :p_payroll_id LOV Oracle PSP_ARC_ARR_PAYROLL_NAME Y select ppf1.payroll_id id, ppf1.payroll_name value, null description from pay_payrolls_f ppf1 where ppf1.business_group_id=fnd_global.per_business_group_id and ppf1.gl_set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') and ppf1.effective_start_date= (select max(ppf2.effective_start_date) from pay_payrolls_f ppf2 where ppf2.payroll_id=ppf1.payroll_id and ppf2.business_group_id=ppf1.business_group_id and ppf2.gl_set_of_books_id=ppf1.gl_set_of_books_id) order by value,description PTB Nome da Folha de Pagamento Nome da Folha de Pagamento US Payroll Name Payroll Name 4 20 :p_begin_period LOV Oracle PSP_ARC_ARR_BEGIN_PERIOD Y select ptp.time_period_id id, ptp.period_name value, null description from per_time_periods ptp where ptp.payroll_id=:$flex$.psp_arc_arr_payroll_name order by ptp.time_period_id PTB Período Inicial Período Inicial US Begin Time Period Begin Time Period 5 30 :p_end_period LOV Oracle PSP_ARC_ARR_END_PERIOD Y select ptp.time_period_id id, ptp.period_name value, null description from per_time_periods ptp where ptp.payroll_id=:$flex$.psp_arc_arr_payroll_name and ptp.time_period_id>=:$flex$.psp_arc_arr_begin_period order by ptp.time_period_id PTB Período Final Período Final US End Time Period End Time Period