DBA Data[Home] [Help]

APPS.HXC_ABS_RETRIEVAL_PKG dependencies on HXC_PAY_LATEST_DETAILS

Line 300: DELETE FROM hxc_pay_latest_details

296: -- avoid issues with prepop and edited(or from SS) absences.
297:
298: IF g_abs_integ_enabled = 'Y'
299: THEN
300: DELETE FROM hxc_pay_latest_details
301: WHERE (time_building_block_id,object_version_number)
302: IN ( SELECT co.time_building_block_id,
303: co.object_version_number
304: FROM hxc_abs_co_details co,

Line 491: DELETE FROM hxc_pay_latest_details

487: -- Bug 9394444
488: -- Added the DELETE to avoid Abs details getting into
489: -- retrieval tables.
490:
491: DELETE FROM hxc_pay_latest_details
492: WHERE (time_building_block_id,object_version_number)
493: IN ( SELECT time_building_block_id,
494: object_version_number
495: FROM hxc_abs_ret_temp );