eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_TIME_PAY dependencies on STANDARD

Line 1093: ,hs.standard_start

1089: ,p_date_worked DATE ) IS
1090: SELECT aeiv.hxt_rotation_plan
1091: ,rts.tws_id
1092: ,hws.week_day
1093: ,hs.standard_start
1094: ,hs.standard_stop
1095: FROM hxt_shifts hs
1096: ,hxt_work_shifts hws
1097: ,hxt_per_aei_ddf_v aeiv

Line 1094: ,hs.standard_stop

1090: SELECT aeiv.hxt_rotation_plan
1091: ,rts.tws_id
1092: ,hws.week_day
1093: ,hs.standard_start
1094: ,hs.standard_stop
1095: FROM hxt_shifts hs
1096: ,hxt_work_shifts hws
1097: ,hxt_per_aei_ddf_v aeiv
1098: ,hxt_rotation_schedules rts

Line 1116: lv_standard_start hxt_shifts.standard_start%TYPE;

1112:
1113: lv_rotation_plan hxt_rotation_schedules.rtp_id%TYPE;
1114: lv_tws_id hxt_rotation_schedules.tws_id%TYPE;
1115: lv_week_day hxt_work_shifts.week_day%TYPE;
1116: lv_standard_start hxt_shifts.standard_start%TYPE;
1117: lv_standard_stop hxt_shifts.standard_stop%TYPE;
1118:
1119: lv_elig_for_prem BOOLEAN := FALSE; */
1120:

Line 1117: lv_standard_stop hxt_shifts.standard_stop%TYPE;

1113: lv_rotation_plan hxt_rotation_schedules.rtp_id%TYPE;
1114: lv_tws_id hxt_rotation_schedules.tws_id%TYPE;
1115: lv_week_day hxt_work_shifts.week_day%TYPE;
1116: lv_standard_start hxt_shifts.standard_start%TYPE;
1117: lv_standard_stop hxt_shifts.standard_stop%TYPE;
1118:
1119: lv_elig_for_prem BOOLEAN := FALSE; */
1120:
1121: -- Not needed.Declared in FOR loop.

Line 1213: ,lv_standard_start ,lv_standard_stop;

1209: end if;
1210:
1211: open Get_Shift_Info( g_ASSIGNMENT_ID,g_DATE_WORKED );
1212: fetch Get_Shift_Info into lv_rotation_plan ,lv_tws_id ,lv_week_day
1213: ,lv_standard_start ,lv_standard_stop;
1214:
1215: if g_debug then
1216: hr_utility.set_location('hxt_time_pay.Gen_Premiums',63);
1217: end if;

Line 1224: hr_utility.trace('lv_standard_start:'||lv_standard_start);

1220: if g_debug then
1221: hr_utility.trace('lv_rotation_plan :'||lv_rotation_plan);
1222: hr_utility.trace('lv_tws_id :'||lv_tws_id);
1223: hr_utility.trace('lv_week_day :'||lv_week_day);
1224: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1225: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1226: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);
1227:
1228: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));

Line 1225: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);

1221: hr_utility.trace('lv_rotation_plan :'||lv_rotation_plan);
1222: hr_utility.trace('lv_tws_id :'||lv_tws_id);
1223: hr_utility.trace('lv_week_day :'||lv_week_day);
1224: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1225: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1226: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);
1227:
1228: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));
1229: hr_utility.trace('p_time_out :'||to_char(p_time_out,'HH24MI'));

Line 1234: IF lv_standard_start = 0 AND lv_standard_stop = 0

1230:
1231: hr_utility.trace('p_time_in :'||to_number(to_char(p_time_in,'HH24MI')));
1232: hr_utility.trace('p_time_out:'||to_number(to_char(p_time_out,'HH24MI')));
1233: end if;
1234: IF lv_standard_start = 0 AND lv_standard_stop = 0
1235: AND g_osp_id is NOT NULL THEN -- for off shift days
1236:
1237: if g_debug then
1238: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64.1);

Line 1254: AND to_number(to_char(p_time_in,'HH24MI')) >= lv_standard_start

1250: -- range of time_in and time_out OR there are no shift Overrides for
1251: -- the day and the shift diff policy is applicable to time_in and
1252: -- time_out
1253: IF (p_sdf_id <> g_sdovr_id OR g_sdovr_id is NULL)
1254: AND to_number(to_char(p_time_in,'HH24MI')) >= lv_standard_start
1255: AND to_number(to_char(p_time_out,'HH24MI')) <= lv_standard_stop THEN
1256:
1257: -- i.e., If shift differential policy is applicable to time_in and
1258: -- time_outs

Line 1255: AND to_number(to_char(p_time_out,'HH24MI')) <= lv_standard_stop THEN

1251: -- the day and the shift diff policy is applicable to time_in and
1252: -- time_out
1253: IF (p_sdf_id <> g_sdovr_id OR g_sdovr_id is NULL)
1254: AND to_number(to_char(p_time_in,'HH24MI')) >= lv_standard_start
1255: AND to_number(to_char(p_time_out,'HH24MI')) <= lv_standard_stop THEN
1256:
1257: -- i.e., If shift differential policy is applicable to time_in and
1258: -- time_outs
1259: if g_debug then