APPS.HXT_TIME_GEN dependencies on HXT_SUM_HOURS_WORKED_F

Line 1067: INSERT INTO hxt_sum_hours_worked_f

1063:
1064:
1065: --SIR012 INSERT into hxt_sum_hours_worked --C431
1066: -- 1704149 Commented the lines which insert values into WHO columns.
1067: INSERT INTO hxt_sum_hours_worked_f
1068: (id, tim_id, date_worked, seqno,
1069: hours, assignment_id, element_type_id, time_in, time_out
1070: -- , created_by
1071: -- , creation_date

Line 1094: FROM hxt_sum_hours_worked_f

1090:
1091: -- begin SIR012. need rowid for call to generate_details.
1092: SELECT ROWID
1093: INTO l_rowid
1094: FROM hxt_sum_hours_worked_f
1095: WHERE id = l_hrw_id;
1096:
1097: -- Create detail records
1098: g_sub_loc := 'HXT_TIME_SUMMARY.Generate_Details';

Line 1402: DELETE FROM hxt_sum_hours_worked_f

1398: LOOP
1399: DELETE FROM hxt_det_hours_worked_f
1400: WHERE tim_id = l_record.id;
1401:
1402: DELETE FROM hxt_sum_hours_worked_f
1403: WHERE tim_id = l_record.id;
1404:
1405: DELETE FROM hxt_timecards_f
1406: WHERE id = l_record.id;

Line 1533: DELETE FROM hxt_sum_hours_worked_f

1529: /*
1530: DELETE FROM hxt_sum_hours_worked
1531: WHERE tim_id = a_tim_id; --C421
1532: */
1533: DELETE FROM hxt_sum_hours_worked_f
1534: WHERE tim_id = a_tim_id
1535: AND g_gen_session_date BETWEEN effective_start_date
1536: AND effective_end_date; --C421
1537: