DBA Data[Home] [Help]

APPS.PQH_WEL_SHD SQL Statements

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

Line: 67

    select
		worksheet_bdgt_elmnt_id,
	worksheet_budget_set_id,
	element_type_id,
	distribution_percentage,
	object_version_number
    from	pqh_worksheet_bdgt_elmnts
    where	worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id;
Line: 142

    select 	worksheet_bdgt_elmnt_id,
	worksheet_budget_set_id,
	element_type_id,
	distribution_percentage,
	object_version_number
    from	pqh_worksheet_bdgt_elmnts
    where	worksheet_bdgt_elmnt_id = p_worksheet_bdgt_elmnt_id
    for	update nowait;