APPS.HXC_RETRIEVAL_ROLLBACK dependencies on HXC_RET_PAY_DETAILS

Line 1630: hxc_ret_pay_details det,

1626: latest.resource_type,
1627: htd.transaction_detail_id,
1628: ht.transaction_id
1629: FROM hxc_ret_pay_latest_details latest,
1630: hxc_ret_pay_details det,
1631: hxc_transaction_details htd,
1632: hxc_transactions ht
1633: WHERE det.timecard_id = p_timecard_id
1634: AND det.batch_id = p_batch_id

Line 1681: hxc_ret_pay_details det,

1677: latest.resource_type,
1678: htd.transaction_detail_id,
1679: ht.transaction_id
1680: FROM hxc_ret_pay_latest_details latest,
1681: hxc_ret_pay_details det,
1682: hxc_transaction_details htd,
1683: hxc_transactions ht
1684: WHERE det.timecard_id = p_timecard_id
1685: AND det.batch_id = p_batch_id

Line 1732: hxc_ret_pay_details det,

1728: latest.resource_type,
1729: htd.transaction_detail_id,
1730: ht.transaction_id
1731: FROM hxc_ret_pay_latest_details latest,
1732: hxc_ret_pay_details det,
1733: hxc_transaction_details htd,
1734: hxc_transactions ht
1735: WHERE det.timecard_id = p_timecard_id
1736: AND det.batch_id IS NULL

Line 2047: DELETE FROM hxc_ret_pay_details

2043: WHERE transaction_detail_id = l_lines_trans_id(i);
2044:
2045:
2046: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2047: DELETE FROM hxc_ret_pay_details
2048: WHERE time_building_block_id = l_lines_time_building_block_id(i)
2049: AND object_version_number = l_lines_object_version_number(i)
2050: AND batch_id = l_lines_batch_id(i)
2051: AND retro_batch_id = l_lines_retro_batch_id(i);

Line 2201: DELETE FROM hxc_ret_pay_details

2197: WHERE transaction_detail_id = l_lines_td_id(i);
2198:
2199:
2200: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2201: DELETE FROM hxc_ret_pay_details
2202: WHERE time_building_block_id = l_lines_time_building_block_id(i)
2203: AND object_version_number = l_lines_object_version_number(i)
2204: AND batch_id = l_lines_batch_id(i)
2205: AND retro_batch_id IS NULL;

Line 2338: DELETE FROM hxc_ret_pay_details

2334: WHERE transaction_detail_id = l_lines_td_id(i);
2335:
2336:
2337: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2338: DELETE FROM hxc_ret_pay_details
2339: WHERE time_building_block_id = l_lines_time_building_block_id(i)
2340: AND object_version_number = l_lines_object_version_number(i)
2341: AND retro_batch_id = l_lines_retro_batch_id(i)
2342: AND batch_id IS NULL;

Line 2657: FROM hxc_ret_pay_details det,

2653: det.retro_batch_id,
2654: det.retro_pbl_id,
2655: det.timecard_id,
2656: htd.transaction_detail_id
2657: FROM hxc_ret_pay_details det,
2658: hxc_transaction_details htd,
2659: hxc_transactions ht
2660: WHERE det.timecard_id = p_timecard_id
2661: AND det.time_building_block_id = htd.time_building_block_id

Line 3054: DELETE FROM hxc_ret_pay_details

3050: WHERE transaction_detail_id = l_tc_data_td_id(i);
3051:
3052:
3053: FORALL i IN l_tc_data_td_id.FIRST..l_tc_data_td_id.LAST
3054: DELETE FROM hxc_ret_pay_details
3055: WHERE time_building_block_id = l_tc_data_tbb_id(i)
3056: AND object_version_number = l_tc_data_ovn(i);
3057:
3058: