APPS.HXT_TIME_SUMMARY dependencies on HXT_SHIFTS

Line 1288: FROM hxt_shifts hs

1284:
1285: /*CURSOR Get_shift_stop_time (p_assignment_id NUMBER
1286: ,p_date_worked DATE ) IS
1287: SELECT hs.standard_stop
1288: FROM hxt_shifts hs
1289: ,hxt_work_shifts hws
1290: ,hxt_per_aei_ddf_v aeiv
1291: ,hxt_rotation_schedules rts
1292: WHERE aeiv.assignment_id = p_ASSIGNMENT_ID

Line 1305: ln_standard_start hxt_shifts.standard_start%TYPE;

1301: AND hws.tws_id = rts.tws_id
1302: AND hws.week_day = to_char(p_DATE_WORKED,'DY')
1303: AND hws.sht_id = hs.id;
1304: */
1305: ln_standard_start hxt_shifts.standard_start%TYPE;
1306: ln_standard_stop hxt_shifts.standard_stop%TYPE;
1307: wp_start_time DATE;
1308: wp_stop_time DATE;
1309: ld_carryover2 DATE;

Line 1306: ln_standard_stop hxt_shifts.standard_stop%TYPE;

1302: AND hws.week_day = to_char(p_DATE_WORKED,'DY')
1303: AND hws.sht_id = hs.id;
1304: */
1305: ln_standard_start hxt_shifts.standard_start%TYPE;
1306: ln_standard_stop hxt_shifts.standard_stop%TYPE;
1307: wp_start_time DATE;
1308: wp_stop_time DATE;
1309: ld_carryover2 DATE;
1310:

Line 1316: ,hxt_shifts hs

1312: SELECT hs.standard_start , hs.standard_stop
1313: FROM hxt_per_aei_ddf_v aeiv
1314: ,hxt_rotation_schedules rts
1315: ,hxt_work_shifts hws
1316: ,hxt_shifts hs
1317: WHERE aeiv.assignment_id = g_ASSIGNMENT_ID
1318: AND g_DATE_WORKED between aeiv.effective_start_date
1319: and aeiv.effective_end_date
1320: AND rts.rtp_id = aeiv.hxt_rotation_plan