APPS.HXT_RETRIEVAL_ROLLBACK dependencies on HXT_SUM_HOURS_WORKED

Line 2000: FROM hxt_sum_hours_worked_f sum,

1996: ret2.attribute3,
1997: ret2.request_id,
1998: rank() over ( partition by ret.time_building_block_id,ret.object_version_number
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,

Line 2026: hxt_sum_hours_worked_f sum,

2022: IS SELECT det.ROWID,
2023: det.pbl_line_id,
2024: pbl.object_version_number
2025: FROM hxt_det_hours_worked_f det,
2026: hxt_sum_hours_worked_f sum,
2027: pay_batch_lines pbl,
2028: FND_Sessions sess
2029: WHERE sum.tim_id = p_tim_id
2030: AND sess.session_id = USERENV('sessionid')

Line 2422: hxt_sum_hours_worked_f sum,

2418: ROWIDTOCHAR(ret.ROWID),
2419: pbl.batch_line_id
2420: FROM pay_batch_lines pbl,
2421: hxt_det_hours_worked_f det,
2422: hxt_sum_hours_worked_f sum,
2423: hxc_ret_pay_latest_details ret
2424: WHERE pbl.batch_id = p_batch_id
2425: AND pbl.batch_line_id = det.retro_pbl_line_id
2426: AND det.tim_id = p_tim_id

Line 2446: hxt_sum_hours_worked_f sum,

2442: ROWIDTOCHAR(ret.ROWID),
2443: pbl.batch_line_id
2444: FROM pay_batch_lines pbl,
2445: hxt_det_hours_worked_f det,
2446: hxt_sum_hours_worked_f sum,
2447: hxc_ret_pay_latest_details ret
2448: WHERE pbl.batch_id = p_batch_id
2449: AND pbl.batch_line_id = det.retro_pbl_line_id
2450: AND det.pay_status = 'B'

Line 2466: hxt_sum_hours_worked_f sum

2462: p_tim_id IN NUMBER)
2463: IS SELECT DISTINCT
2464: ROWIDTOCHAR(ret.ROWID)
2465: FROM hxc_ret_pay_latest_details ret,
2466: hxt_sum_hours_worked_f sum
2467: WHERE hxt_batch_id = p_batch_id
2468: AND retro_batch_id IS NULL
2469: AND retro_pbl_id IS NULL
2470: AND pbl_id IS NOT NULL

Line 2481: hxt_sum_hours_worked_f sum,

2477: ROWIDTOCHAR(det.ROWID),
2478: ROWIDTOCHAR(ret.ROWID),
2479: pbl.batch_line_id
2480: FROM hxt_det_hours_worked_f det,
2481: hxt_sum_hours_worked_f sum,
2482: hxc_ret_pay_latest_details ret,
2483: pay_batch_lines pbl
2484: WHERE det.pay_status = 'C'
2485: AND det.retro_batch_id = p_batch_id

Line 2507: hxt_sum_hours_worked_f sum,

2503: RANK() OVER ( PARTITION BY ret.time_building_block_id,
2504: ret.object_version_number
2505: ORDER BY det.ROWID) rank
2506: FROM hxt_det_hours_worked_f det,
2507: hxt_sum_hours_worked_f sum,
2508: hxc_ret_pay_latest_details ret,
2509: pay_batch_lines pbl
2510: WHERE det.pay_status = 'C'
2511: AND det.retro_batch_id = p_batch_id

Line 3227: DELETE FROM hxt_sum_hours_worked_f

3223:
3224: DELETE FROM hxt_det_hours_worked_f
3225: WHERE tim_id = p_tim_id;
3226:
3227: DELETE FROM hxt_sum_hours_worked_f
3228: WHERE tim_id = p_tim_id;
3229:
3230: DELETE FROM hxt_timecards_f
3231: WHERE id = p_tim_id;

Line 3280: FROM hxt_sum_hours_worked sum,

3276: ret2.attribute1,
3277: ret2.attribute2,
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

Line 3502: FROM hxt_sum_hours_worked_f

3498: ORDER BY pay_status;
3499:
3500: CURSOR get_otm_entries
3501: IS SELECT id
3502: FROM hxt_sum_hours_worked_f
3503: WHERE tim_id = p_tim_id
3504: AND time_building_block_id IS NULL ;
3505:
3506:

Line 3527: FROM hxt_sum_hours_worked sum,

3523: ret2.attribute1,
3524: ret2.attribute2,
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

Line 3542: FROM hxt_sum_hours_worked_f sum,

3538: sum.id,
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