APPS.PQH_WDT_SHD SQL Statements

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

Line: 97

    select
		worksheet_detail_id,
	worksheet_id,
	organization_id,
	job_id,
	position_id,
	grade_id,
	position_transaction_id,
	budget_detail_id,
	parent_worksheet_detail_id,
	user_id,
	action_cd,
	budget_unit1_percent,
	budget_unit1_value,
	budget_unit2_percent,
	budget_unit2_value,
	budget_unit3_percent,
	budget_unit3_value,
	object_version_number,
	budget_unit1_value_type_cd,
	budget_unit2_value_type_cd,
	budget_unit3_value_type_cd,
	status,
	budget_unit1_available,
	budget_unit2_available,
	budget_unit3_available,
	old_unit1_value,
	old_unit2_value,
	old_unit3_value,
	defer_flag,
	propagation_method
    from	pqh_worksheet_details
    where	worksheet_detail_id = p_worksheet_detail_id;

Line: 197

    select 	worksheet_detail_id,
	worksheet_id,
	organization_id,
	job_id,
	position_id,
	grade_id,
	position_transaction_id,
	budget_detail_id,
	parent_worksheet_detail_id,
	user_id,
	action_cd,
	budget_unit1_percent,
	budget_unit1_value,
	budget_unit2_percent,
	budget_unit2_value,
	budget_unit3_percent,
	budget_unit3_value,
	object_version_number,
	budget_unit1_value_type_cd,
	budget_unit2_value_type_cd,
	budget_unit3_value_type_cd,
	status,
	budget_unit1_available,
	budget_unit2_available,
	budget_unit3_available,
	old_unit1_value,
	old_unit2_value,
	old_unit3_value,
	defer_flag,
	propagation_method
    from	pqh_worksheet_details
    where	worksheet_detail_id = p_worksheet_detail_id
    for	update nowait;