APPS.HR_CAU_SHD SQL Statements

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

Line: 75

    select
		calendar_id,
	calendar_usage_id,
	primary_key_value,
	purpose_usage_id,
	start_date,
	end_date,
	object_version_number
    from	hr_calendar_usages
    where	calendar_usage_id = p_calendar_usage_id;

Line: 152

    select 	calendar_id,
	calendar_usage_id,
	primary_key_value,
	purpose_usage_id,
	start_date,
	end_date,
	object_version_number
    from	hr_calendar_usages
    where	calendar_usage_id = p_calendar_usage_id
    for	update nowait;