73: Select 'exists'
74: From sys.dual
75: Where EXISTS (
76: Select 'x'
77: From hxc_time_building_blocks htb
78: Where htb.scope = 'TIMECARD'
79: And htb.type = 'RANGE'
80: And htb.date_to = hr_general.end_of_time
81: And htb.resource_type = 'PERSON'
163: IS
164: select max(ht.transaction_date)
165: from hxc_dep_transactions ht,
166: hxc_dep_transaction_details htd,
167: hxc_time_building_blocks htb
168: where htb.parent_building_block_id = p_timecard_id
169: and htb.parent_building_block_ovn = p_timecard_ovn
170: and htb.scope = 'DAY'
171: and htd.time_building_block_id = htb.time_building_block_id
181: IS
182: select max(ht.transaction_date)
183: from hxc_dep_transactions ht,
184: hxc_dep_transaction_details htd,
185: hxc_time_building_blocks htb_day,
186: hxc_time_building_blocks htb_detail
187: where htb_day.parent_building_block_id = p_timecard_id
188: and htb_day.parent_building_block_ovn = p_timecard_ovn
189: and htb_day.scope = 'DAY'
182: select max(ht.transaction_date)
183: from hxc_dep_transactions ht,
184: hxc_dep_transaction_details htd,
185: hxc_time_building_blocks htb_day,
186: hxc_time_building_blocks htb_detail
187: where htb_day.parent_building_block_id = p_timecard_id
188: and htb_day.parent_building_block_ovn = p_timecard_ovn
189: and htb_day.scope = 'DAY'
190: and htb_detail.parent_building_block_id = htb_day.time_building_block_id