DBA Data[Home] [Help]

APPS.BEN_PUM_SHD SQL Statements

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

Line: 64

    select
		pop_up_messages_id,
	pop_name,
	formula_id,
	function_name,
	block_name,
	field_name,
	event_name,
	message,
	message_type,
	business_group_id,
	object_version_number,
	start_date,
	end_date,
	no_formula_flag
    from	ben_pop_up_messages
    where	pop_up_messages_id = p_pop_up_messages_id;
Line: 148

    select 	pop_up_messages_id,
	pop_name,
	formula_id,
	function_name,
	block_name,
	field_name,
	event_name,
	message,
	message_type,
	business_group_id,
	object_version_number,
	start_date,
	end_date,
	no_formula_flag
    from	ben_pop_up_messages
    where	pop_up_messages_id = p_pop_up_messages_id
    for	update nowait;