APPS.HXC_RETRIEVAL_ROLLBACK dependencies on HXC_TIMECARD_SUMMARY

Line 319: FROM hxc_timecard_summary

315: IS
316:
317: CURSOR get_data_set_id(p_timecard_id NUMBER)
318: IS SELECT data_set_id
319: FROM hxc_timecard_summary
320: WHERE timecard_id = p_timecard_id;
321:
322: l_data_set_id NUMBER;
323:

Line 371: AND timecard_type = 'HXC_TIMECARD_SUMMARY';

367: CURSOR get_rollback_eligibility(p_timecard_id IN NUMBER)
368: IS SELECT timecard_id
369: FROM hxc_rollback_timecards_all
370: WHERE timecard_id = p_timecard_id
371: AND timecard_type = 'HXC_TIMECARD_SUMMARY';
372:
373: l_id NUMBER;
374:
375:

Line 492: FROM hxc_timecard_summary

488: IS
489:
490: CURSOR get_transferred_to
491: IS SELECT transferred_to
492: FROM hxc_timecard_summary
493: WHERE timecard_id = p_timecard_id;
494:
495: l_transferred_to VARCHAR2(100);
496:

Line 509: UPDATE hxc_timecard_summary

505: l_transferred_to := LTRIM(RTRIM(REPLACE(l_transferred_to,'Payroll'),','),',');
506:
507: log('Modified Transferred to for this timecard '||l_transferred_to);
508:
509: UPDATE hxc_timecard_summary
510: SET transferred_to = l_transferred_to
511: WHERE timecard_id = p_timecard_id;
512:
513: END update_transferred_to;

Line 1586: INDEX(tc HXC_TIMECARD_SUMMARY_FK1) */

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
1590: WHERE tc.timecard_id = det.timecard_id

Line 1589: hxc_timecard_summary 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:
1593:

Line 2642: FROM hxc_timecard_summary sum

2638:
2639: -- Bug 16446212
2640: l_query VARCHAR2(8000) :=
2641: 'SELECT timecard_id
2642: FROM hxc_timecard_summary sum
2643: WHERE 1 = 1';
2644:
2645:
2646: