DBA Data[Home] [Help]

APPS.PQH_WKS_SHD SQL Statements

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

Line: 57

    select
		worksheet_id,
	budget_id,
	worksheet_name,
	version_number,
	action_date,
	date_from,
	date_to,
	worksheet_mode_cd,
	transaction_status,
	object_version_number,
	budget_version_id,
	propagation_method,
        wf_transaction_category_id
    from	pqh_worksheets
    where	worksheet_id = p_worksheet_id;
Line: 140

    select 	worksheet_id,
	budget_id,
	worksheet_name,
	version_number,
	action_date,
	date_from,
	date_to,
	worksheet_mode_cd,
	transaction_status,
	object_version_number,
	budget_version_id,
	propagation_method,
        wf_transaction_category_id
    from	pqh_worksheets
    where	worksheet_id = p_worksheet_id
    for	update nowait;