[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select 'exists'
From sys.dual
Where EXISTS (
Select 'x'
From hxc_time_building_blocks htb
Where htb.scope = 'TIMECARD'
And htb.type = 'RANGE'
And htb.date_to = hr_general.end_of_time
And htb.resource_type = 'PERSON'
And htb.resource_id = cp_resource_id
And htb.start_time = l_period_start);
select 1 from per_all_people_f where person_id=p_resource_id;
select max(ht.transaction_date)
from hxc_transactions ht,
hxc_transaction_details htd,
hxc_time_building_blocks htb
where htb.parent_building_block_id = p_timecard_id
and htb.parent_building_block_ovn = p_timecard_ovn
and htb.scope = 'DAY'
and htd.time_building_block_id = htb.time_building_block_id
and htd.time_building_block_ovn = htb.object_version_number
and htd.status='SUCCESS'
and ht.transaction_id=htd.transaction_id
and ht.type='DEPOSIT'
and ht.status='SUCCESS' ;
select max(ht.transaction_date)
from hxc_transactions ht,
hxc_transaction_details htd,
hxc_time_building_blocks htb_day,
hxc_time_building_blocks htb_detail
where htb_day.parent_building_block_id = p_timecard_id
and htb_day.parent_building_block_ovn = p_timecard_ovn
and htb_day.scope = 'DAY'
and htb_detail.parent_building_block_id = htb_day.time_building_block_id
and htb_detail.parent_building_block_ovn = htb_day.object_version_number
and htb_detail.scope = 'DETAIL'
and htd.time_building_block_id = htb_detail.time_building_block_id
and htd.time_building_block_ovn = htb_detail.object_version_number
and htd.status='SUCCESS'
and ht.transaction_id=htd.transaction_id
and ht.type='DEPOSIT'
and ht.status='SUCCESS' ;