DBA Data[Home] [Help]

APPS.HXC_TIMECARD_UTIL dependencies on HXC_TRANSACTION_DETAILS

Line 166: hxc_transaction_details htd,

162: p_timecard_ovn in number)
163: IS
164: select max(ht.transaction_date)
165: from hxc_transactions ht,
166: hxc_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'

Line 184: hxc_transaction_details htd,

180: p_timecard_ovn in number)
181: IS
182: select max(ht.transaction_date)
183: from hxc_transactions ht,
184: hxc_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