APPS.PSP_PSPARREP_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

	SELECT min(PTP1.time_period_id)	time_period_id
	FROM 	PER_TIME_PERIODS PTP1
	WHERE	PTP1.payroll_id	=  nvl(p_payroll_id,PTP1.payroll_id);

Line: 24

	SELECT  PTP.period_name	period_name
	FROM	PER_TIME_PERIODS PTP
	WHERE	PTP.time_period_id	= 	l_time_period_id;

Line: 68

	SELECT max(PTP1.time_period_id)	time_period_id
	FROM 	PER_TIME_PERIODS PTP1
	WHERE	PTP1.payroll_id	=  nvl(p_payroll_id,PTP1.payroll_id);

Line: 75

	SELECT  PTP.period_name	period_name
	FROM	PER_TIME_PERIODS PTP
	WHERE	PTP.time_period_id	= 	l_time_period_id;

Line: 120

SELECT	COUNT(*)	no_dist_lines
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';

Line: 134

SELECT	COUNT(*)	no_enc_lines
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';