APPS.HXT_RETRIEVAL_ROLLBACK dependencies on HXC_RET_PAY_DETAILS

Line 2003: hxc_ret_pay_details ret2,

1999: ORDER by ret.ROWID) rank
2000: FROM hxt_sum_hours_worked_f sum,
2001: hxt_det_hours_worked_f det,
2002: hxc_ret_pay_latest_details ret,
2003: hxc_ret_pay_details ret2,
2004: FND_sessions sess,
2005: pay_batch_lines pbl
2006: WHERE sum.tim_id = p_tim_id
2007: AND sess.session_id = USERENV('sessionid')

Line 3282: hxc_ret_pay_details ret2

3278: ret2.attribute3,
3279: ret2.request_id
3280: FROM hxt_sum_hours_worked sum,
3281: hxc_ret_pay_latest_details ret,
3282: hxc_ret_pay_details ret2
3283: WHERE sum.tim_id = p_tim_id
3284: AND sum.time_building_block_id = ret.time_building_block_id
3285: AND ret.time_building_block_id = ret2.time_building_block_id;
3286:

Line 3427: DELETE FROM hxc_ret_pay_details

3423: AND object_version_number <> l_sum_ovn_tab(i);
3424:
3425:
3426: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
3427: DELETE FROM hxc_ret_pay_details
3428: WHERE time_building_block_id = l_sum_id_tab(i)
3429: AND object_version_number <> l_sum_ovn_tab(i);
3430:
3431: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST

Line 3529: hxc_ret_pay_details ret2

3525: ret2.attribute3,
3526: ret2.measure
3527: FROM hxt_sum_hours_worked sum,
3528: hxc_ret_pay_latest_details ret,
3529: hxc_ret_pay_details ret2
3530: WHERE sum.tim_id = p_tim_id
3531: AND sum.time_building_block_id = ret2.time_building_block_id
3532: AND sum.time_building_block_ovn = ret2.object_version_number
3533: AND ret.time_building_block_id = ret2.time_building_block_id

Line 3543: hxc_ret_pay_details ret2,

3539: ret2.time_building_block_id,
3540: ret2.object_version_number,
3541: htd.transaction_detail_id
3542: FROM hxt_sum_hours_worked_f sum,
3543: hxc_ret_pay_details ret2,
3544: hxc_transaction_details htd,
3545: hxc_transactions ht
3546: WHERE sum.tim_id = p_tim_id
3547: AND sum.time_building_block_id = ret2.time_building_block_id

Line 3742: DELETE FROM hxc_ret_pay_details

3738: WHERE time_building_block_id = l_lines_time_building_block_id(i);
3739:
3740: /*
3741: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
3742: DELETE FROM hxc_ret_pay_details
3743: WHERE time_building_block_id = l_lines_time_building_block_id(i);
3744:
3745: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
3746: UPDATE hxc_transaction_details

Line 3840: DELETE FROM hxc_ret_pay_details

3836:
3837: display_numtab('Transaction Details ',l_lines_td_id);
3838:
3839: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
3840: DELETE FROM hxc_ret_pay_details
3841: WHERE time_building_block_id = l_lines_time_building_block_id(i);
3842:
3843: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
3844: UPDATE hxc_transaction_details