APPS.HR_AHC_SHD SQL Statements

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

Line: 69

    select
		api_hook_call_id,
	api_hook_id,
	api_hook_call_type,
	legislation_code,
	sequence,
	enabled_flag,
	call_package,
	call_procedure,
	pre_processor_date,
	encoded_error,
	status,
	object_version_number,
        application_id,
        app_install_status
    from	hr_api_hook_calls
    where	api_hook_call_id = p_api_hook_call_id;

Line: 153

    select 	api_hook_call_id,
	api_hook_id,
	api_hook_call_type,
	legislation_code,
	sequence,
	enabled_flag,
	call_package,
	call_procedure,
	pre_processor_date,
	encoded_error,
	status,
	object_version_number,
        application_id,
        app_install_status
    from	hr_api_hook_calls
    where	api_hook_call_id      = p_api_hook_call_id
    for	update nowait;