PSP Reconciliation between payroll lines and sublines

Description
Categories: BI Publisher, Human Resources
Application: Labor Distribution
Source: PSP: Reconciliation between payroll lines and sublines (XML)
Short Name: PSPRCLSL_XML
DB package: PSP_PSPRCLSL_XMLP_PKG
SELECT	ppl.person_id person_id,
	ppl.assignment_id assignment_id,
	ppl.element_type_id element_type_id,
	psp_general.get_element_name(ppl.element_type_id,ppl.effective_date) element_name , 
	sum(decode(ppl.dr_cr_flag, 'C', ppl.pay_amount, 0)) l_credit_amount,
	sum(decode(ppl.dr_cr_flag, 'D'
Parameter Name SQL text Validation
Batch Name
 
LOV Oracle
Time Period
 
LOV Oracle
Payroll Name
 
LOV Oracle
Source Code
 
LOV Oracle
Source Type
 
LOV Oracle