APPS.HR_CAU_BUS SQL Statements

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

Line: 25

	select	calendar_start_time
	from	hr_calendars
	where	calendar_id = p_calendar_id;

Line: 109

	select	1
	from	hr_calendar_usages
	where	purpose_usage_id = p_purpose_usage_id
	and	(p_calendar_usage_id is null
		or p_calendar_usage_id <> calendar_usage_id)
	and	primary_key_value = p_primary_key_value
	and	p_start_date <= end_date
	and	p_end_date   >= start_date;

Line: 184

	select	1
	from	hr_pattern_constructions	CON,
		hr_pattern_constructions	CON2,
		hr_calendars			CAL
	where	cal.calendar_id = p_calendar_id
	and	cal.pattern_id = con.pattern_id
	and	con.component_pattern_id = con2.pattern_id (+)
	and	(nvl (con.availability,con2.availability)
		not in ('QUALIFYING', 'NON QUALIFYING'));

Line: 198

	select	pattern_purpose
	from	hr_pattern_purpose_usages
	where	purpose_usage_id = p_purpose_usage_id;

Line: 266

	select	cau.purpose_usage_id,
		cau.primary_key_value
	from	hr_pattern_purpose_usages PPU1,
		hr_calendar_usages	CAU
	where	ppu1.pattern_purpose = (
		select ppu2.pattern_purpose
		from hr_pattern_purpose_usages PPU2
		where ppu2.purpose_usage_id = p_purpose_usage_id
		and ppu1.hierarchy_level < ppu2.hierarchy_level)
	and	cau.purpose_usage_id = ppu1.purpose_usage_id
	and	p_start_date between cau.start_date and cau.end_date
	order by ppu1.hierarchy_level desc;

Line: 287

	select	calendar_id
	from	hr_calendar_usages
	where	primary_key_value = p_primary_key_value
	and	purpose_usage_id = p_purpose_usage_id
	and	p_start_date between start_date and end_date;

Line: 364

	select	1
	from	per_all_people_f
	where	person_id = p_primary_key_value
	and	p_start_date between effective_start_date
				and effective_end_date;

Line: 374

	select	1
	from	per_assignments_f
	where	assignment_id = p_primary_key_value
	and	p_start_date between effective_start_date
				and effective_end_date;

Line: 384

	select	1
	from	hr_locations
	where	location_id = p_primary_key_value
	and	p_start_date < nvl (inactive_date, hr_general.end_of_time);

Line: 393

	select	1
	from	per_jobs
	where	job_id = p_primary_key_value
	and	p_start_date between date_from
				and nvl (date_to, hr_general.end_of_time);

Line: 403

	select	1
	from	per_business_groups_perf
	where	business_group_id = p_primary_key_value
	and	p_start_date between date_from
				and nvl (date_to, hr_general.end_of_time);

Line: 414

	select	1
	from	hr_positions_f
	where	position_id = p_primary_key_value
	and	p_start_date between date_effective
				and nvl (hr_general.get_position_date_end(position_id), hr_general.end_of_time);

Line: 424

	select	entity_name
	from 	hr_pattern_purpose_usages
	where	purpose_usage_id = p_purpose_usage_id;

Line: 538

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

Line: 568

End insert_validate;

Line: 573

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

Line: 594

End update_validate;

Line: 599

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

Line: 609

End delete_validate;