APPS.PSP_PSPRCPGD_XMLP_PKG SQL Statements

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

Line: 10

	  select assignment_number
	  into x_assignment_number
	  from per_assignments_f
--	  where assignment_id = assignment_id
	  where assignment_id = v_assignment_id
	  AND	assignment_type ='E'		  and rownum < 2; 	  	  	  return(x_assignment_number);

Line: 32

  select end_date into x_end_date
  from per_time_periods
  where time_period_id = p_time_period_id;

Line: 36

  select full_name into x_person_name
  from per_people_f
--  where person_id = person_id
  where person_id = v_person_id
  and x_end_date BETWEEN effective_start_date and effective_end_date;

Line: 56

  select start_date into p_start_date
  from per_time_periods
  where time_period_id = p_time_period_id;

Line: 61

    /*srw.message(1,'Start Date not found for the selected time period id');*/null;

Line: 65

    /*srw.message(2,'Too many rows found for the selected time period id');*/null;

Line: 144

	SELECT 	sum(decode(a.dr_cr_flag, 'C',b.distribution_amount,0)) pgdl_Credit_Amount,
		sum(decode(a.dr_cr_flag, 'D',b.distribution_amount,0)) pgdl_Debit_Amount,
		B.suspense_reason_code		FROM 	PSP_SUMMARY_LINES A,
		PSP_PRE_GEN_DIST_LINES_HISTORY B
	WHERE 	A.SUMMARY_LINE_ID 	= B.SUMMARY_LINE_ID
	AND 	A.STATUS_CODE 		= 'A' AND B.STATUS_CODE = 'A'
	AND	a.source_type 		= p_source_type
	and 	a.source_code 		= p_source_code
	and 	a.time_period_id 	= p_time_period_id
	and 	(a.interface_batch_name = p_batch_name or a.interface_batch_name IS NULL)
--	and 	a.person_id 		= person_id
--	and 	a.assignment_id 	= assignment_id
--	and 	a.gl_code_combination_id = gl_code_combination_id
	and 	a.person_id 		= v_person_id
	and 	a.assignment_id 	= v_assignment_id
	and 	a.gl_code_combination_id = v_gl_code_combination_id
	GROUP BY	B.suspense_reason_code;

Line: 165

	SELECT 	sum(decode(a.dr_cr_flag, 'C',b.distribution_amount,0)) pgdl_Credit_Amount,
		sum(decode(a.dr_cr_flag, 'D',b.distribution_amount,0)) pgdl_Debit_Amount,
		B.suspense_reason_code 	FROM 	PSP_SUMMARY_LINES A,
		PSP_PRE_GEN_DIST_LINES_HISTORY B
	WHERE 	A.SUMMARY_LINE_ID 	= B.SUMMARY_LINE_ID
	AND 	A.STATUS_CODE 		= 'A' AND B.STATUS_CODE = 'A'
	AND	a.source_type 		= p_source_type
	and 	a.source_code 		= p_source_code
	and 	a.time_period_id 	= p_time_period_id
	and 	(a.interface_batch_name = p_batch_name or a.interface_batch_name IS NULL)
--	and 	a.person_id 		= person_id
--	and 	a.assignment_id 	= assignment_id
--	and 	A.project_id 		= project_id
--	and 	a.task_id 		= task_id
--	and 	(	a.award_id 		= award_id
--		OR	(a.award_id IS NULL AND award_id IS NULL))
--	and 	a.expenditure_type 	= expenditure_type
--	and 	a.expenditure_organization_id = expenditure_organization_id
	and 	a.person_id 		= v_person_id
	and 	a.assignment_id 	= v_assignment_id
	and 	A.project_id 		= v_project_id
	and 	a.task_id 		= v_task_id
	and 	(	a.award_id 		= v_award_id
--		OR	(a.award_id IS NULL AND award_id IS NULL))
		OR	(a.award_id IS NULL AND v_award_id IS NULL))
	and 	a.expenditure_type 	= v_expenditure_type
	and 	a.expenditure_organization_id = v_expenditure_organization_id
	GROUP BY	B.suspense_reason_code;

Line: 273

	select name into x_org_name from hr_organization_units				where organization_id = TO_NUMBER(x_org_id);

Line: 298

  select meaning into x_source_type from psp_lookups
  where lookup_type = 'PSP_SOURCE_TYPE' and lookup_code = p_source_type;

Line: 307

  	select period_name into x_time_period from per_time_periods
  	where time_period_id = p_time_period_id;

Line: 323

	SELECT ppa.name
	FROM   pa_projects_all ppa
--	WHERE  ppa.project_id = project_id;

Line: 330

	SELECT	pt.task_number
	FROM 	pa_tasks_expend_v pt   -- Bug : 16391366   (20/03/2013)
--	WHERE   pt.task_id = task_id;

Line: 337

	SELECT	gma.award_number
	FROM	gms_awards_all gma
--	WHERE	gma.award_id = award_id;

Line: 344

	SELECT	haou.name
	FROM	hr_all_organization_units haou
--	WHERE	haou.organization_id = expenditure_organization_id;