APPS.HR_PAC_BUS SQL Statements

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

Line: 28

	select	1
	from	hr_pattern_purposes
	where	pattern_id = p_pattern_id
	and	pattern_purpose = 'QUALIFYING PATTERN';

Line: 35

	select	1
	from	hr_pattern_bits
	where	pattern_bit_id = p_pattern_bit_id
	and	(time_unit_multiplier <> ceil (time_unit_multiplier)
		or base_time_unit <> 'DAYS'
		or p_availability is null
		or p_availability not in ('QUALIFYING','NON QUALIFYING'))
	union all
	select	1
	from	hr_pattern_bits			BIT,
		hr_pattern_constructions	CON
	where	bit.pattern_bit_id = con.pattern_bit_id
	and	con.pattern_id = p_component_pattern_id
	and	(bit.time_unit_multiplier <> ceil (bit.time_unit_multiplier)
		or bit.base_time_unit <> 'DAYS'
		or con.availability not in ('QUALIFYING','NON QUALIFYING'));

Line: 131

	select	1
	from	hr_lookups
	where	lookup_code = p_availability
	and	lookup_type = 'AVAILABILITY';

Line: 179

	select	1
	from	hr_pattern_constructions
	where	pattern_id = p_component_pattern_id
	and	component_pattern_id is not null;

Line: 212

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

Line: 232

End insert_validate;

Line: 237

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

Line: 249

End update_validate;

Line: 254

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

Line: 264

End delete_validate;