APPS.HXC_RETRIEVAL_ROLLBACK dependencies on HXC_RET_PAY_LATEST_DETAILS

Line 259: FROM hxc_ret_pay_latest_details ret,

255:
256: CURSOR get_otlr_details(p_timecard_id IN NUMBER)
257: IS SELECT sum.id,
258: tim.batch_id
259: FROM hxc_ret_pay_latest_details ret,
260: hxt_sum_hours_worked_f sum,
261: hxt_timecards_f tim
262: WHERE ret.timecard_id = p_timecard_id
263: AND ret.time_building_block_id = sum.time_building_block_id

Line 1585: INDEX(det HXC_RET_PAY_LATEST_DETAILS_N3)

1581:
1582: -- Bug 16446212
1583: l_query VARCHAR2(32000) :=
1584: 'SELECT /*+ LEADING(tc)
1585: INDEX(det HXC_RET_PAY_LATEST_DETAILS_N3)
1586: INDEX(tc HXC_TIMECARD_SUMMARY_FK1) */
1587: DISTINCT det.timecard_id,batch_id,retro_batch_id
1588: FROM hxc_ret_pay_latest_details det,
1589: hxc_timecard_summary tc

Line 1588: FROM hxc_ret_pay_latest_details det,

1584: 'SELECT /*+ LEADING(tc)
1585: INDEX(det HXC_RET_PAY_LATEST_DETAILS_N3)
1586: INDEX(tc HXC_TIMECARD_SUMMARY_FK1) */
1587: DISTINCT det.timecard_id,batch_id,retro_batch_id
1588: FROM hxc_ret_pay_latest_details det,
1589: hxc_timecard_summary tc
1590: WHERE tc.timecard_id = det.timecard_id
1591: ';
1592:

Line 1629: FROM hxc_ret_pay_latest_details latest,

1625: latest.last_update_date,
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

Line 1680: FROM hxc_ret_pay_latest_details latest,

1676: latest.last_update_date,
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

Line 1731: FROM hxc_ret_pay_latest_details latest,

1727: latest.last_update_date,
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

Line 2123: UPDATE hxc_ret_pay_latest_details

2119: END;
2120:
2121:
2122: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2123: UPDATE hxc_ret_pay_latest_details
2124: SET attribute1 = l_lines_old_attribute1(i),
2125: attribute2 = l_lines_old_attribute2(i),
2126: attribute3 = l_lines_old_attribute3(i),
2127: measure = l_lines_old_measure(i),

Line 2277: DELETE FROM hxc_ret_pay_latest_details

2273: END;
2274:
2275:
2276: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2277: DELETE FROM hxc_ret_pay_latest_details
2278: WHERE time_building_block_id = l_lines_time_building_block_id(i)
2279: AND object_version_number = l_lines_object_version_number(i);
2280:
2281: END IF;

Line 2414: UPDATE hxc_ret_pay_latest_details

2410: END;
2411:
2412:
2413: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
2414: UPDATE hxc_ret_pay_latest_details
2415: SET attribute1 = l_lines_old_attribute1(i),
2416: attribute2 = l_lines_old_attribute2(i),
2417: attribute3 = l_lines_old_attribute3(i),
2418: measure = l_lines_old_measure(i),

Line 2699: FROM hxc_ret_pay_latest_details latest

2695: latest.application_set_id,
2696: latest.comment_text,
2697: latest.last_update_date,
2698: latest.resource_type
2699: FROM hxc_ret_pay_latest_details latest
2700: WHERE timecard_id = p_timecard_id;
2701:
2702:
2703:

Line 3007: DELETE FROM hxc_ret_pay_latest_details

3003:
3004: END;
3005:
3006: FORALL i IN l_lines_time_building_block_id.FIRST..l_lines_time_building_block_id.LAST
3007: DELETE FROM hxc_ret_pay_latest_details
3008: WHERE time_building_block_id = l_lines_time_building_block_id(i);
3009:
3010: END IF;
3011: