APPS.HR_CAL_BUS SQL Statements

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

Line: 23

	select	1
	from	hr_calendars
	where	upper(calendar_name) = upper (p_calendar_name)
	and	(p_calendar_id is null or calendar_id <> p_calendar_id);

Line: 78

	select	count (*)
	from	hr_pattern_constructions
	where	pattern_id = p_pattern_id;

Line: 146

	select  bit1.time_unit_multiplier,
		bit1.base_time_unit,
		con1.sequence_no,
		0
	from    hr_pattern_constructions        CON1,
		hr_pattern_bits                 BIT1
	where   bit1.pattern_bit_id = con1.pattern_bit_id
	and     con1.pattern_id = p_pattern_id
	union all
	select  bit2.time_unit_multiplier,
		bit2.base_time_unit,
		con2.sequence_no,
		con3.sequence_no
	from    hr_pattern_bits                 BIT2,
		hr_pattern_constructions        CON2,
		hr_pattern_constructions        CON3
	where   bit2.pattern_bit_id = con3.pattern_bit_id
	and     con2.component_pattern_id = con3.pattern_id
	and     con2.pattern_id = p_pattern_id
	order by 3,4;

Line: 171

	select	*
	from	hr_patterns
	where	pattern_id = p_pattern_id;

Line: 298

Procedure insert_validate(p_rec in hr_cal_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 318

End insert_validate;

Line: 323

Procedure update_validate(p_rec in hr_cal_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 338

End update_validate;

Line: 343

Procedure delete_validate(p_rec in hr_cal_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 353

End delete_validate;