APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_RET_PAY_LATEST_DETAILS

Line 9568: UPDATE hxc_ret_pay_latest_details

9564: IF g_params.p_process = 'Apply Schedule Rules'
9565: THEN
9566:
9567: FORALL i IN t_l_time_building_block_id.FIRST..t_l_time_building_block_id.LAST
9568: UPDATE hxc_ret_pay_latest_details
9569: SET old_attribute1 = attribute1,
9570: old_attribute2 = attribute2,
9571: old_attribute3 = attribute3,
9572: old_measure = measure,

Line 9594: UPDATE hxc_ret_pay_latest_details

9590:
9591: ELSE
9592:
9593: FORALL i IN t_l_time_building_block_id.FIRST..t_l_time_building_block_id.LAST
9594: UPDATE hxc_ret_pay_latest_details
9595: SET old_attribute1 = attribute1,
9596: old_attribute2 = attribute2,
9597: old_attribute3 = attribute3,
9598: old_measure = measure,

Line 9677: INSERT INTO hxc_ret_pay_latest_details

9673: END LOOP;
9674:
9675:
9676: FORALL i IN l_time_building_block_id.FIRST..l_time_building_block_id.LAST
9677: INSERT INTO hxc_ret_pay_latest_details
9678: (resource_id,
9679: time_building_block_id,
9680: approval_status,
9681: start_time,

Line 9773: UPDATE hxc_ret_pay_latest_details

9769: END LOOP;
9770:
9771:
9772: FORALL i IN l_rec_bb_id.FIRST..l_rec_bb_id.LAST
9773: UPDATE hxc_ret_pay_latest_details
9774: SET old_pbl_id = pbl_id,
9775: pbl_id = l_rec_id(i),
9776: batch_id = l_batch_id(i)
9777: WHERE time_building_block_id = l_rec_bb_id(i)

Line 9833: UPDATE hxc_ret_pay_latest_details

9829: END LOOP;
9830:
9831:
9832: FORALL i IN l_rec_bb_id.FIRST..l_rec_bb_id.LAST
9833: UPDATE hxc_ret_pay_latest_details
9834: SET retro_pbl_id = l_rec_id(i),
9835: retro_batch_id = l_batch_id(i)
9836: WHERE time_building_block_id = l_rec_bb_id(i)
9837: AND old_ovn = l_rec_ovn(i);