DBA Data[Home] [Help]

APPS.HXC_TIMECARD_SUMMARY_PKG dependencies on HXC_TRANSACTION_DETAILS

Line 697: hxc_transaction_details htd

693: AND hld.time_building_block_id = det.time_building_block_id
694: AND hld.object_version_number = det.object_version_number
695: AND NOT EXISTS ( SELECT 1
696: FROM hxc_transactions ht,
697: hxc_transaction_details htd
698: WHERE htd.time_building_block_id = det.time_building_block_id
699: AND det.object_version_number = htd.time_building_block_ovn
700: AND htd.status = 'SUCCESS'
701: AND ht.transaction_id = htd.transaction_id

Line 709: hxc_transaction_details htd

705: AND ( det.date_to = hr_general.end_of_time
706: OR ( det.date_to <> hr_general.end_of_time
707: AND EXISTS ( SELECT 1
708: FROM hxc_transactions ht,
709: hxc_transaction_details htd
710: WHERE htd.time_building_block_id = det.time_building_block_id
711: AND det.object_version_number > htd.time_building_block_ovn
712: AND htd.status = 'SUCCESS'
713: AND ht.transaction_id = htd.transaction_id