ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4720751A9E05362FB09050512Y SELECT person_id, assignment_id, gl_code_combination_id, project_id, task_id, award_id, expenditure_type, expenditure_organization_id, sum(decode(dr_cr_flag, 'C', summary_amount, 0)) sl_credit_amount, sum(decode(dr_cr_flag, 'D', summary_amount, 0)) sl_debit_amount, currency_code, PSP_PSPRCPGD_XMLP_PKG.cf_currency_codeformula(currency_code) CF_currency_code, PSP_PSPRCPGD_XMLP_PKG.cf_currency_formatformula(currency_code) CF_currency_format, PSP_PSPRCPGD_XMLP_PKG.cf_sum_sl_d_total_dspformula(:CS_sum_sl_d_total, :CF_currency_format) CF_sum_sl_d_total_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_sum_sl_c_total_dspformula(:CS_sum_sl_c_total, :CF_currency_format) CF_sum_sl_c_total_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_sum_dl_d_total_dspformula(:CS_sum_dl_d_total, :CF_currency_format) CF_sum_dl_d_total_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_sum_dl_c_total_dspformula(:CS_sum_dl_c_total, :CF_currency_format) CF_sum_dl_c_total_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_mismatch_currency_totalform(:CS_sum_dl_d_total, :CS_sum_sl_d_total, :CS_sum_dl_c_total, :CS_sum_sl_c_total) CF_mismatch_currency_total, PSP_PSPRCPGD_XMLP_PKG.cf_person_nameformula(person_id) CF_person_name, PSP_PSPRCPGD_XMLP_PKG.cf_sum_sl_d_person_dspformula(:sum_sl_d_person, :CF_currency_format) CF_sum_sl_d_person_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_sum_sl_c_person_dspformula(:sum_sl_c_person, :CF_currency_format) CF_sum_sl_c_person_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_sum_dl_d_person_dspformula(:sum_dl_d_person, :CF_currency_format) CF_sum_dl_d_person_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_sum_dl_c_person_dspformula(:sum_dl_c_person, :CF_currency_format) CF_sum_dl_c_person_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_mismatch_personformula(:sum_dl_d_person, :sum_sl_d_person, :sum_dl_c_person, :sum_sl_c_person) CF_mismatch_person, PSP_PSPRCPGD_XMLP_PKG.cf_assignment_numberformula(assignment_id) CF_assignment_number, PSP_PSPRCPGD_XMLP_PKG.cf_sum_sl_d_assg_dspformula(:sum_sl_d_assg, :CF_currency_format) CF_sum_sl_d_assg_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_sum_sl_c_assg_dspformula(:sum_sl_c_assg, :CF_currency_format) CF_sum_sl_c_assg_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_sum_dl_d_assg_dspformula(:sum_dl_d_assg, :CF_currency_format) CF_sum_dl_d_assg_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_sum_dl_c_assg_dspformula(:sum_dl_c_assg, :CF_currency_format) CF_sum_dl_c_assg_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_mismatch_assgformula(:sum_dl_d_assg, :sum_sl_d_assg, :sum_dl_c_assg, :sum_sl_c_assg) CF_mismatch_assg, PSP_PSPRCPGD_XMLP_PKG.cf_sl_debit_amount_dspformula(sum ( decode ( dr_cr_flag , 'D' , summary_amount , 0 ) ), :CF_currency_format) CF_sl_debit_amount_dsp, PSP_PSPRCPGD_XMLP_PKG.cf_amt_sl_cformula(gl_code_combination_id, sum ( decode ( dr_cr_flag , 'C' , summary_amount , 0 ) )) CF_amt_sl_c, PSP_PSPRCPGD_XMLP_PKG.cf_amt_sl_c_dspformula(:CF_amt_sl_c, :CF_currency_format) CF_amt_sl_c_dsp, -- PSP_PSPRCPGD_XMLP_PKG.cf_amt_dl_dformula(gl_code_combination_id) CF_amt_dl_d, PSP_PSPRCPGD_XMLP_PKG.cf_amt_dl_dformula(person_id,assignment_id, gl_code_combination_id, project_id, task_id, award_id, expenditure_type, expenditure_organization_id ) CF_amt_dl_d, PSP_PSPRCPGD_XMLP_PKG.cf_amt_dl_d_dspformula(:CF_amt_dl_d, :CF_currency_format) CF_amt_dl_d_dsp, -- PSP_PSPRCPGD_XMLP_PKG.cf_mismatch_eltformula(:CF_amt_dl_d, sum ( decode ( dr_cr_flag , 'D' , summary_amount , 0 ) ), :CF_amt_sl_c) CF_mismatch_elt, PSP_PSPRCPGD_XMLP_PKG.cf_mismatch_eltformula(PSP_PSPRCPGD_XMLP_PKG.cf_amt_dl_dformula(person_id,assignment_id, gl_code_combination_id, project_id, task_id, award_id, expenditure_type, expenditure_organization_id ), sum ( decode ( dr_cr_flag , 'D' , summary_amount , 0 ) ), PSP_PSPRCPGD_XMLP_PKG.cf_amt_sl_cformula(gl_code_combination_id, sum ( decode ( dr_cr_flag , 'C' , summary_amount , 0 ) ))) CF_mismatch_elt, -- PSP_PSPRCPGD_XMLP_PKG.cf_charging_instructionsformu(project_id, task_id, award_id, expenditure_organization_id, gl_code_combination_id) CF_Charging _Instructions, PSP_PSPRCPGD_XMLP_PKG.cf_charging_instructionsformu(project_id, task_id, award_id, expenditure_organization_id, gl_code_combination_id, expenditure_type) CF_Charging_Instructions, PSP_PSPRCPGD_XMLP_PKG.cf_credit_amount_pgdl_dspformu(:CF_currency_format) CF_credit_amount_pgdl_dsp, PSP_PSPRCPGD_XMLP_PKG.CP_suspense_p CP_suspense, PSP_PSPRCPGD_XMLP_PKG.CP_credit_amount_pgdl_p CP_credit_amount_pgdl FROM psp_summary_lines psl, psp_payroll_controls ppc WHERE psl.status_code = 'A' AND psl.payroll_control_id = ppc. payroll_control_id AND ppc.source_type = :p_source_type AND payroll_source_code = :p_source_code AND ppc.time_period_id = :p_time_period_id AND (batch_name = :p_batch_name OR batch_name IS NULL ) GROUP BY currency_code, person_id, assignment_id, gl_code_combination_id, project_id, task_id, award_id, expenditure_type, -- expenditure_organization_id; expenditure_organization_id --added order by currency_code, person_id, assignment_id, gl_code_combination_id, project_id, task_id, award_id, expenditure_type, expenditure_organization_id PSP PSPRCPGD_XML PTB PSP Reconciliação entre as linhas da classificação contábil geradas anteriormente e as linhas resumidas Imported from BI Publisher Description: Reconciliação entre as linhas de classificação contábil pré-geradas e as linhas resumidas Application: Distribuição da Mão de Obra Source: PSP: Reconciliação entre as linhas da classificação contábil geradas anteriormente e as linhas resumidas (XML) Short Name: PSPRCPGD_XML DB package: PSP_PSPRCPGD_XMLP_PKG US PSP Reconciliation between pre-generated distribution lines and summary lines Imported from BI Publisher Description: Reconciliation between pre-generated distribution lines and summary lines Application: Labor Distribution Source: PSP: Reconciliation between pre-generated distribution lines and summary lines (XML) Short Name: PSPRCPGD_XML DB package: PSP_PSPRCPGD_XMLP_PKG BI Publisher :cf_amt_dl_d :cf_amt_sl_c :cf_currency_format :cp_credit_amount_pgdl :cp_suspense :cs_sum_dl_c_total :cs_sum_dl_d_total :cs_sum_sl_c_total :cs_sum_sl_d_total :p_batch_name :p_batch_name_1 :p_conc_request_id :p_payroll_id :p_set_of_books_id :p_source_code :p_source_code_1 :p_source_type :p_start_date :p_time_period_id :sum_dl_c_assg :sum_dl_c_person :sum_dl_d_assg :sum_dl_d_person :sum_sl_c_assg :sum_sl_c_person :sum_sl_d_assg :sum_sl_d_person 1 -20 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') Y PTB P_SET_OF_BOOKS_ID ID do Razão US P_SET_OF_BOOKS_ID Ledger ID 2 10 :p_source_type LOV Oracle PSP_SOURCE_TYPE_P Y select lookup_code id, meaning value, null description from psp_lookups where lookup_type='PSP_SOURCE_TYPE' and lookup_code='P' and lookup_code in (select source_type from psp_payroll_controls where status_code='P' and business_group_id=fnd_global.per_business_group_id and set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID')) order by meaning Y PTB Tipo de Origem Tipo de Origem US Source Type Source Type 3 20 :p_source_code LOV Oracle PSP_SOURCE_CODE_P Y select source_code id, source_code value, null description from psp_payroll_sources where source_type=:$flex$.psp_source_type_p and source_code in (select payroll_source_code from psp_payroll_controls where status_code='P' and business_group_id=fnd_global.per_business_group_id and set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID')) order by source_code Y PTB Código da Origem Código da Origem US Source Code Source Code 4 30 :p_payroll_id LOV Oracle PSP_SRS_IMP_PAYROLL_NAME Y select payroll_id id, payroll_name value, null description from pay_payrolls_f where sysdate between effective_start_date and effective_end_date and business_group_id=fnd_global.per_business_group_id and gl_set_of_books_id= fnd_profile.value('GL_SET_OF_BKS_ID') order by value,description Y PTB Nome da Folha de Pagamento Nome da Folha de Pagamento US Payroll Name Payroll Name 5 40 :p_time_period_id LOV Oracle PSP_TIME_PERIODS_P Y select time_period_id id, period_name value, null description from per_time_periods where time_period_id in (select time_period_id from psp_payroll_controls where business_group_id=fnd_global.per_business_group_id and set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') and source_type=:$flex$.psp_source_type_p and payroll_source_code=:$flex$.psp_source_code_p and payroll_id=:$flex$.psp_srs_imp_payroll_name and status_code='P') order by time_period_id Y PTB Período Período US Time Period Time Period 6 50 :p_batch_name LOV Oracle PSP_BATCH_P Y select batch_name id, batch_name value, null description from psp_batch_names_v where batch_name in (select batch_name from psp_payroll_controls where business_group_id=fnd_global.per_business_group_id and set_of_books_id=fnd_profile.value('GL_SET_OF_BKS_ID') and source_type=:$flex$.psp_source_type_p and payroll_source_code=:$flex$.psp_source_code_p and status_code='P') order by batch_name PTB Nome do Lote Nome do Lote US Batch Name Batch Name