DBA Data[Home] [Help]

APPS.HR_CAL_SHD SQL Statements

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

Line: 78

    select
		calendar_id,
	calendar_name,
	pattern_start_position,
	calendar_start_time,
	pattern_id,
	object_version_number
    from	hr_calendars
    where	calendar_id = p_calendar_id;
Line: 154

    select 	calendar_id,
	calendar_name,
	pattern_start_position,
	calendar_start_time,
	pattern_id,
	object_version_number
    from	hr_calendars
    where	calendar_id = p_calendar_id
    for	update nowait;