DBA Data[Home] [Help]

APPS.HR_AHK_SHD SQL Statements

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

Line: 63

    select
		api_hook_id,
	api_module_id,
	api_hook_type,
	hook_package,
	hook_procedure,
	legislation_code,
	legislation_package,
	legislation_function,
	encoded_error
    from	hr_api_hooks
    where	api_hook_id = p_api_hook_id;
Line: 136

    select 	api_hook_id,
	api_module_id,
	api_hook_type,
	hook_package,
	hook_procedure,
	legislation_code,
	legislation_package,
	legislation_function,
	encoded_error
    from	hr_api_hooks
    where	api_hook_id = p_api_hook_id
    for	update nowait;