APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXT_DET_HOURS_WORKED

Line 208: FROM hxt_det_hours_worked

204: IS
205:
206: CURSOR get_retro_batches
207: IS SELECT retro_batch_id
208: FROM hxt_det_hours_worked
209: WHERE tim_id = p_tim_id
210: AND pay_status = 'R';
211:
212: l_retro_batch NUMBER := 0;

Line 415: l_time_summary_id hxt_det_hours_worked_f.parent_id%TYPE;

411: l_is_retrievable BOOLEAN := TRUE;
412: l_dt_update_mode VARCHAR2 (256);
413: l_error_message VARCHAR2 (2000);
414: l_return_code NUMBER;
415: l_time_summary_id hxt_det_hours_worked_f.parent_id%TYPE;
416:
417: -- Bug 12850901
418: --Added the following variables and cursor.
419: l_timecard_id NUMBER;

Line 3824: DELETE FROM hxt_det_hours_worked_f

3820:
3821: --
3822: -- Delete old summary and detail rows.
3823: --
3824: DELETE FROM hxt_det_hours_worked_f
3825: WHERE parent_id = l_time_summary_id;
3826:
3827: --
3828: -- Delete the summary row itself.