PSP Archive History

Description
Categories: BI Publisher, Human Resources
Application: Labor Distribution
Source: PSP: Archive History Report (XML)
Short Name: PSPARREP_XML
DB package: PSP_PSPARREP_XMLP_PKG
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
Parameter Name SQL text Validation
Ledger ID
 
Business Group ID
 
End Time Period
 
LOV Oracle
Begin Time Period
 
LOV Oracle
Payroll Name
 
LOV Oracle