APPS.PQH_BVR_SHD SQL Statements

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

Line: 56

    select
		budget_version_id,
	budget_id,
	version_number,
	date_from,
	date_to,
	transfered_to_gl_flag,
	gl_status,
	xfer_to_other_apps_cd,
	object_version_number,
	budget_unit1_value,
	budget_unit2_value,
	budget_unit3_value,
	budget_unit1_available,
	budget_unit2_available,
	budget_unit3_available
    from	pqh_budget_versions
    where	budget_version_id = p_budget_version_id;

Line: 141

    select 	budget_version_id,
	budget_id,
	version_number,
	date_from,
	date_to,
	transfered_to_gl_flag,
	gl_status,
	xfer_to_other_apps_cd,
	object_version_number,
	budget_unit1_value,
	budget_unit2_value,
	budget_unit3_value,
	budget_unit1_available,
	budget_unit2_available,
	budget_unit3_available
    from	pqh_budget_versions
    where	budget_version_id = p_budget_version_id
    for	update nowait;