162: p_timecard_ovn in number)
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'
180: p_timecard_ovn in number)
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