DBA Data[Home] [Help]

APPS.HXT_RETRIEVAL_ROLLBACK dependencies on HXC_TIMECARD_SUMMARY

Line 558: FROM hxc_timecard_summary

554: IS
555:
556: CURSOR get_transferred_to(p_timecard_id IN NUMBER)
557: IS SELECT transferred_to
558: FROM hxc_timecard_summary
559: WHERE timecard_id = p_timecard_id;
560:
561: l_transferred_to VARCHAR2(100);
562:

Line 584: UPDATE hxc_timecard_summary

580: l_transferred_to := LTRIM(RTRIM(REPLACE(l_transferred_to,'Payroll'),','),',');
581:
582: put_log('Modified Transferred to for this timecard '||l_transferred_to);
583:
584: UPDATE hxc_timecard_summary
585: SET transferred_to = l_transferred_to
586: WHERE timecard_id = p_timecards(i);
587: END IF;
588: END LOOP;