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 978: ,hs.standard_start

974: ,p_date_worked DATE ) IS
975: SELECT aeiv.hxt_rotation_plan
976: ,rts.tws_id
977: ,hws.week_day
978: ,hs.standard_start
979: ,hs.standard_stop
980: FROM hxt_shifts hs
981: ,hxt_work_shifts hws
982: ,hxt_per_aei_ddf_v aeiv

Line 979: ,hs.standard_stop

975: SELECT aeiv.hxt_rotation_plan
976: ,rts.tws_id
977: ,hws.week_day
978: ,hs.standard_start
979: ,hs.standard_stop
980: FROM hxt_shifts hs
981: ,hxt_work_shifts hws
982: ,hxt_per_aei_ddf_v aeiv
983: ,hxt_rotation_schedules rts

Line 1001: lv_standard_start hxt_shifts.standard_start%TYPE;

997:
998: lv_rotation_plan hxt_rotation_schedules.rtp_id%TYPE;
999: lv_tws_id hxt_rotation_schedules.tws_id%TYPE;
1000: lv_week_day hxt_work_shifts.week_day%TYPE;
1001: lv_standard_start hxt_shifts.standard_start%TYPE;
1002: lv_standard_stop hxt_shifts.standard_stop%TYPE;
1003:
1004: lv_elig_for_prem BOOLEAN := FALSE; */
1005:

Line 1002: lv_standard_stop hxt_shifts.standard_stop%TYPE;

998: lv_rotation_plan hxt_rotation_schedules.rtp_id%TYPE;
999: lv_tws_id hxt_rotation_schedules.tws_id%TYPE;
1000: lv_week_day hxt_work_shifts.week_day%TYPE;
1001: lv_standard_start hxt_shifts.standard_start%TYPE;
1002: lv_standard_stop hxt_shifts.standard_stop%TYPE;
1003:
1004: lv_elig_for_prem BOOLEAN := FALSE; */
1005:
1006: -- Not needed.Declared in FOR loop.

Line 1090: ,lv_standard_start ,lv_standard_stop;

1086: end if;
1087:
1088: open Get_Shift_Info( g_ASSIGNMENT_ID,g_DATE_WORKED );
1089: fetch Get_Shift_Info into lv_rotation_plan ,lv_tws_id ,lv_week_day
1090: ,lv_standard_start ,lv_standard_stop;
1091:
1092: if g_debug then
1093: hr_utility.set_location('hxt_time_pay.Gen_Premiums',63);
1094: end if;

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

1097: if g_debug then
1098: hr_utility.trace('lv_rotation_plan :'||lv_rotation_plan);
1099: hr_utility.trace('lv_tws_id :'||lv_tws_id);
1100: hr_utility.trace('lv_week_day :'||lv_week_day);
1101: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1103: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);
1104:
1105: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));

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

1098: hr_utility.trace('lv_rotation_plan :'||lv_rotation_plan);
1099: hr_utility.trace('lv_tws_id :'||lv_tws_id);
1100: hr_utility.trace('lv_week_day :'||lv_week_day);
1101: hr_utility.trace('lv_standard_start:'||lv_standard_start);
1102: hr_utility.trace('lv_standard_stop :'||lv_standard_stop);
1103: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64);
1104:
1105: hr_utility.trace('p_time_in :'||to_char(p_time_in,'HH24MI'));
1106: hr_utility.trace('p_time_out :'||to_char(p_time_out,'HH24MI'));

Line 1111: IF lv_standard_start = 0 AND lv_standard_stop = 0

1107:
1108: hr_utility.trace('p_time_in :'||to_number(to_char(p_time_in,'HH24MI')));
1109: hr_utility.trace('p_time_out:'||to_number(to_char(p_time_out,'HH24MI')));
1110: end if;
1111: IF lv_standard_start = 0 AND lv_standard_stop = 0
1112: AND g_osp_id is NOT NULL THEN -- for off shift days
1113:
1114: if g_debug then
1115: hr_utility.set_location('hxt_time_pay.Gen_Premiums',64.1);

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

1127: -- range of time_in and time_out OR there are no shift Overrides for
1128: -- the day and the shift diff policy is applicable to time_in and
1129: -- time_out
1130: IF (p_sdf_id <> g_sdovr_id OR g_sdovr_id is NULL)
1131: AND to_number(to_char(p_time_in,'HH24MI')) >= lv_standard_start
1132: AND to_number(to_char(p_time_out,'HH24MI')) <= lv_standard_stop THEN
1133:
1134: -- i.e., If shift differential policy is applicable to time_in and
1135: -- time_outs

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

1128: -- the day and the shift diff policy is applicable to time_in and
1129: -- time_out
1130: IF (p_sdf_id <> g_sdovr_id OR g_sdovr_id is NULL)
1131: AND to_number(to_char(p_time_in,'HH24MI')) >= lv_standard_start
1132: AND to_number(to_char(p_time_out,'HH24MI')) <= lv_standard_stop THEN
1133:
1134: -- i.e., If shift differential policy is applicable to time_in and
1135: -- time_outs
1136: if g_debug then