APPS.PQH_BPR_SHD SQL Statements

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

Line: 75

    select
		budget_period_id,
	budget_detail_id,
	start_time_period_id,
	end_time_period_id,
	budget_unit1_percent,
	budget_unit2_percent,
	budget_unit3_percent,
	budget_unit1_value,
	budget_unit2_value,
	budget_unit3_value,
	budget_unit1_value_type_cd,
	budget_unit2_value_type_cd,
	budget_unit3_value_type_cd,
	budget_unit1_available,
	budget_unit2_available,
	budget_unit3_available,
	object_version_number
    from	pqh_budget_periods
    where	budget_period_id = p_budget_period_id;

Line: 162

    select 	budget_period_id,
	budget_detail_id,
	start_time_period_id,
	end_time_period_id,
	budget_unit1_percent,
	budget_unit2_percent,
	budget_unit3_percent,
	budget_unit1_value,
	budget_unit2_value,
	budget_unit3_value,
	budget_unit1_value_type_cd,
	budget_unit2_value_type_cd,
	budget_unit3_value_type_cd,
	budget_unit1_available,
	budget_unit2_available,
	budget_unit3_available,
	object_version_number
    from	pqh_budget_periods
    where	budget_period_id = p_budget_period_id
    for	update nowait;