PA Validate Purge Batches

SELECT proj.name, proj.segment1, 
	DECODE(ppj.archive_summary_flag, 'Y', :c_yes, :c_no) archive_summary_flag,
	DECODE(ppj.purge_summary_flag, 'Y', :c_yes, :c_no) purge_summary_flag,
	DECODE(ppj.archive_capital_flag, 'Y', :c_yes, :c_no) archive_capital_flag,
	DECODE(ppj.purge_capital_flag, 'Y', :c_yes, :c_no) purge_capital_flag,
	DECODE(ppj.archive_budgets_flag, 'Y', :c_yes, :c_no) archive_budgets_flag,
	DECODE(ppj.purge_budgets_flag, 'Y', :c_yes, :c_no) purge_budgets_flag,
	DECODE(ppj.archive_actuals_flag, 'Y', :c_yes, :c_no) archive_actuals_flag,
	DECODE(ppj.purge_actuals_flag, 'Y', :c_yes, :c_no) purge_actuals_flag,
	ppj.project_id
FROM pa_purge_projects ppj, pa_projects_all proj
WHERE ppj.purge_project_status_code = 'V'
AND ppj.project_id = proj.project_id
AND ppj.purge_batch_id = :P_Purge_batch_id

SELECT proj.name, proj.segment1, DECODE(ppj.archive_summary_flag, 'Y', :c_yes, :c_no) archive_summary_flag, DECODE(ppj.purge_summary_flag, 'Y', :c_yes, :c_no) purge_summary_flag, DECODE(ppj.archive_capital_flag, 'Y', :c_yes, :c_no) archive_capital_flag, DECODE(ppj.purge_capital_flag, 'Y', :c_yes, :c_no) purge_capital_flag, DECODE(ppj.archive_budgets_flag, 'Y', :c_yes, :c_no) archive_budgets_flag, DECODE(ppj.purge_budgets_flag, 'Y', :c_yes, :c_no) purge_budgets_flag, DECODE(ppj.archive_actuals_flag, 'Y', :c_yes, :c_no) archive_actuals_flag, DECODE(ppj.purge_actuals_flag, 'Y', :c_yes, :c_no) purge_actuals_flag, ppj.project_id FROM pa_purge_projects ppj, pa_projects_all proj WHERE ppj.purge_project_status_code = 'V' AND ppj.project_id = proj.project_id AND ppj.purge_batch_id = :P_Purge_batch_id