DBA Data[Home] [Help]

APPS.HXC_TIMECARD_SUMMARY_PKG dependencies on HXC_TRANSACTIONS

Line 696: FROM hxc_transactions ht,

692: AND det.parent_building_block_ovn = day.object_version_number
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'

Line 708: FROM hxc_transactions ht,

704: AND ht.transaction_process_id = p_process_id )
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'