APPS.HXT_TIME_COLLECTION dependencies on HXT_DET_HOURS_WORKED_F

Line 5581: DELETE FROM hxt_det_hours_worked_f

5577: -- Bug 7359347
5578: -- Changed the below DELETE to use one instance of the base table
5579: -- and a session_date
5580: /*
5581: DELETE FROM hxt_det_hours_worked_f
5582: WHERE ROWID IN (SELECT ROWID
5583: FROM hxt_det_hours_worked
5584: WHERE parent_id = l_hours_worked_id);
5585:

Line 5588: DELETE FROM hxt_det_hours_worked_f

5584: WHERE parent_id = l_hours_worked_id);
5585:
5586: */
5587:
5588: DELETE FROM hxt_det_hours_worked_f
5589: WHERE parent_id = l_hours_worked_id
5590: AND l_session_date BETWEEN effective_start_date
5591: AND effective_end_date;
5592:

Line 5612: UPDATE hxt_det_hours_worked_f

5608: -- Bug 7359347
5609: -- Changed the below update to use the base table instead of the view.
5610:
5611: /*
5612: UPDATE hxt_det_hours_worked_f
5613: SET effective_end_date = l_session_date - 1
5614: WHERE ROWID IN (SELECT ROWID
5615: FROM hxt_det_hours_worked
5616: WHERE parent_id = l_hours_worked_id);

Line 5622: UPDATE hxt_det_hours_worked_f

5618: */
5619: -- Bug 12919783
5620: -- Added TRUNC to trim the time component.
5621:
5622: UPDATE hxt_det_hours_worked_f
5623: SET effective_end_date = TRUNC(l_session_date - 1)
5624: WHERE parent_id = l_hours_worked_id
5625: AND l_session_date BETWEEN effective_start_date
5626: AND effective_end_date ;

Line 6200: DELETE FROM hxt_det_hours_worked_f

6196: l_proc := g_package || 'remove_tc_details';
6197: hr_utility.set_location ('Entering ' || l_proc, 10);
6198: END IF;
6199:
6200: DELETE FROM hxt_det_hours_worked_f
6201: WHERE parent_id = p_sum_id;
6202:
6203: DELETE FROM hxt_sum_hours_worked_f
6204: WHERE ID = p_sum_id;

Line 6328: DELETE FROM hxt_det_hours_worked_f

6324: -- Bug 7359347
6325: -- Changed the below DELETE to look at the table instead
6326: -- of the view.
6327: /*
6328: DELETE FROM hxt_det_hours_worked_f
6329: WHERE ROWID IN (SELECT ROWID
6330: FROM hxt_det_hours_worked
6331: WHERE tim_id = p_tim_id);
6332: */

Line 6334: DELETE FROM hxt_det_hours_worked_f

6330: FROM hxt_det_hours_worked
6331: WHERE tim_id = p_tim_id);
6332: */
6333:
6334: DELETE FROM hxt_det_hours_worked_f
6335: WHERE tim_id = p_tim_id
6336: AND p_effective_start_date BETWEEN effective_start_date
6337: AND effective_end_date ;
6338:

Line 6356: UPDATE hxt_det_hours_worked_f

6352: -- Bug 7359347
6353: -- changed the update below to use the base table instead
6354: -- of the view.
6355: /*
6356: UPDATE hxt_det_hours_worked_f
6357: SET effective_end_date = p_effective_start_date - 1
6358: WHERE ROWID IN (SELECT ROWID
6359: FROM hxt_det_hours_worked
6360: WHERE tim_id = p_tim_id);

Line 6367: UPDATE hxt_det_hours_worked_f

6363:
6364: -- Bug 12919783
6365: -- Added TRUNC to trim the time component
6366:
6367: UPDATE hxt_det_hours_worked_f
6368: SET effective_end_date = TRUNC(p_effective_start_date - 1)
6369: WHERE tim_id = p_tim_id
6370: AND p_effective_start_date BETWEEN effective_start_date
6371: AND effective_end_date ;