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_DETAIL dependencies on HXT_DET_HOURS_WORKED_F

Line 28: g_fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE;

24: g_hours NUMBER;
25: g_time_in DATE;
26: g_time_out DATE;
27: g_element_type_id NUMBER;
28: g_fcl_earn_reason_code hxt_det_hours_worked.fcl_earn_reason_code%TYPE;
29: --C421
30: g_ffv_cost_center_id NUMBER;
31: g_ffv_labor_account_id NUMBER;
32: g_tas_id NUMBER;

Line 40: g_fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE;

36: g_ffv_rate_code_id NUMBER;
37: g_rate_multiple NUMBER;
38: g_hourly_rate NUMBER;
39: g_amount NUMBER;
40: g_fcl_tax_rule_code hxt_det_hours_worked.fcl_tax_rule_code%TYPE;
41: --C421
42: g_separate_check_flag hxt_det_hours_worked.separate_check_flag%TYPE;
43: --C421
44: g_seqno NUMBER;

Line 65: g_state_name hxt_det_hours_worked_f.state_name%TYPE;

61: --g_group_id NUMBER; -- HXT11i1
62: l_time_in DATE; -- SIR132
63: l_time_out DATE; -- SIR132
64: g_call_adjust_abs VARCHAR2 (1);
65: g_state_name hxt_det_hours_worked_f.state_name%TYPE;
66: g_county_name hxt_det_hours_worked_f.county_name%TYPE;
67: g_city_name hxt_det_hours_worked_f.city_name%TYPE;
68: g_zip_code hxt_det_hours_worked_f.zip_code%TYPE;
69:

Line 66: g_county_name hxt_det_hours_worked_f.county_name%TYPE;

62: l_time_in DATE; -- SIR132
63: l_time_out DATE; -- SIR132
64: g_call_adjust_abs VARCHAR2 (1);
65: g_state_name hxt_det_hours_worked_f.state_name%TYPE;
66: g_county_name hxt_det_hours_worked_f.county_name%TYPE;
67: g_city_name hxt_det_hours_worked_f.city_name%TYPE;
68: g_zip_code hxt_det_hours_worked_f.zip_code%TYPE;
69:
70: g_adjust_for_holiday BOOLEAN;

Line 67: g_city_name hxt_det_hours_worked_f.city_name%TYPE;

63: l_time_out DATE; -- SIR132
64: g_call_adjust_abs VARCHAR2 (1);
65: g_state_name hxt_det_hours_worked_f.state_name%TYPE;
66: g_county_name hxt_det_hours_worked_f.county_name%TYPE;
67: g_city_name hxt_det_hours_worked_f.city_name%TYPE;
68: g_zip_code hxt_det_hours_worked_f.zip_code%TYPE;
69:
70: g_adjust_for_holiday BOOLEAN;
71:

Line 68: g_zip_code hxt_det_hours_worked_f.zip_code%TYPE;

64: g_call_adjust_abs VARCHAR2 (1);
65: g_state_name hxt_det_hours_worked_f.state_name%TYPE;
66: g_county_name hxt_det_hours_worked_f.county_name%TYPE;
67: g_city_name hxt_det_hours_worked_f.city_name%TYPE;
68: g_zip_code hxt_det_hours_worked_f.zip_code%TYPE;
69:
70: g_adjust_for_holiday BOOLEAN;
71:
72: TYPE element_tab IS TABLE OF VARCHAR2(5) INDEX BY BINARY_INTEGER;

Line 109: -- or OVT row in the hxt_det_hours_worked_f table.

105: -- part of the cursor (sub select) looks for REG and OVT rows with higher
106: -- sequence numbers than the one passed in. This is an effort to sandwich
107: -- premiums between their related REG and OVT elements. Without this there is
108: -- no guarantee thata premium selected would be associated with any given REG
109: -- or OVT row in the hxt_det_hours_worked_f table.
110:
111: -- Bug 7359347
112: -- Changed the below cursor to use the base tables instead of views
113: -- referencing fnd_sessions. Uses a global variable instead.

Line 196: hxt_det_hours_worked_f hrw

192: hrw.time_out prem_time_out, hrw.hours prem_hours,
193: elt.element_name
194: FROM hxt_pay_element_types_f_ddf_v eltv,
195: pay_element_types_f elt,
196: hxt_det_hours_worked_f hrw
197: WHERE hrw.tim_id = a_tim_id
198: AND hrw.parent_id = a_parent_id
199: AND hrw.seqno > a_seqno
200: AND a_session_date BETWEEN hrw.effective_start_date

Line 208: hxt_det_hours_worked_f det

204: (hrw.seqno <
205: (SELECT MIN (det.seqno)
206: FROM hxt_pay_element_types_f_ddf_v eltv2,
207: pay_element_types_f elt2,
208: hxt_det_hours_worked_f det
209: WHERE det.tim_id = a_tim_id
210: AND det.parent_id = a_parent_id
211: AND det.seqno > a_seqno
212: AND a_session_date BETWEEN det.effective_start_date

Line 227: hxt_det_hours_worked_f det

223: (NOT EXISTS (
224: SELECT det.seqno
225: FROM hxt_pay_element_types_f_ddf_v eltv2,
226: pay_element_types_f elt2,
227: hxt_det_hours_worked_f det
228: WHERE det.tim_id = a_tim_id
229: AND det.parent_id = a_parent_id
230: AND det.seqno > a_seqno
231: AND a_session_date BETWEEN det.effective_start_date

Line 255: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,

251:
252:
253: -- Function and Procedure declarations
254: FUNCTION contig_hours_worked (
255: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
256: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
257: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
258: )
259: RETURN hxt_det_hours_worked.hours%TYPE;

Line 257: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE

253: -- Function and Procedure declarations
254: FUNCTION contig_hours_worked (
255: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
256: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
257: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
258: )
259: RETURN hxt_det_hours_worked.hours%TYPE;
260:
261: -- Bug 7143238

Line 266: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,

262: -- Added for effective calculation of hours worked
263: -- when there is an SDP.
264:
265: FUNCTION contig_hours_worked2 (
266: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
267: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
268: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
269: )
270: RETURN hxt_det_hours_worked.hours%TYPE;

Line 268: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE

264:
265: FUNCTION contig_hours_worked2 (
266: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
267: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
268: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
269: )
270: RETURN hxt_det_hours_worked.hours%TYPE;
271:
272:

Line 274: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,

270: RETURN hxt_det_hours_worked.hours%TYPE;
271:
272:
273: PROCEDURE overtime_hoursoverride (
274: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
275: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
276: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
277: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
278: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE

Line 276: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,

272:
273: PROCEDURE overtime_hoursoverride (
274: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
275: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
276: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
277: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
278: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
279: );
280:

Line 277: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,

273: PROCEDURE overtime_hoursoverride (
274: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
275: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
276: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
277: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
278: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
279: );
280:
281: FUNCTION delete_zero_hour_details (

Line 278: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE

274: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
275: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
276: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
277: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
278: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
279: );
280:
281: FUNCTION delete_zero_hour_details (
282: a_tim_id NUMBER,

Line 294: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE

290: RETURN NUMBER;
291:
292: FUNCTION holiday_rule_found (
293: p_ep_id IN hxt_earning_policies.ID%TYPE,
294: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE
295: )
296: RETURN BOOLEAN
297: IS
298: l_holiday_rule_found BOOLEAN;

Line 918: hxt_det_hours_worked_f hrw,

914: pay_element_types_f elt,
915: hxt_earning_policies egp,
916: hxt_per_aei_ddf_v asmv,
917: per_assignments_f asm,
918: hxt_det_hours_worked_f hrw,
919: hxt_timecards_f tim
920: WHERE hrw.parent_id > 0
921: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
922: start_day_of_week

Line 1039: hxt_det_hours_worked_f hrw,

1035: hxt_earn_groups erg,
1036: hxt_earning_policies egp,
1037: hxt_per_aei_ddf_v asmv,
1038: per_assignments_f asm,
1039: hxt_det_hours_worked_f hrw,
1040: hxt_timecards_f tim
1041: WHERE hrw.parent_id > 0
1042: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
1043: start_day_of_week

Line 1160: hxt_det_hours_worked_f hrw,

1156: pay_element_types_f elt,
1157: hxt_earning_policies egp,
1158: hxt_per_aei_ddf_v asmv,
1159: per_assignments_f asm,
1160: hxt_det_hours_worked_f hrw,
1161: hxt_timecards_f tim
1162: WHERE hrw.parent_id > 0
1163: AND hrw.date_worked = g_date_worked
1164: AND asm.assignment_id = hrw.assignment_id

Line 1208: from hxt_det_hours_worked_f det,

1204:
1205: CURSOR daily_hol_total(session_date IN DATE)
1206: IS
1207: select NVL(SUM(det.hours),0)
1208: from hxt_det_hours_worked_f det,
1209: hxt_sum_hours_worked_f sum,
1210: hxt_earning_rules er
1211: WHERE det.date_worked = g_date_worked
1212: AND sum.id = det.parent_id

Line 1309: hxt_det_hours_worked_f hrw, --C421

1305: IS
1306: SELECT hrw.ROWID hrw_rowid, hrw.hours
1307: FROM hxt_pay_element_types_f_ddf_v eltv,
1308: pay_element_types_f elt,
1309: hxt_det_hours_worked_f hrw, --C421
1310: hxt_timecards_f tim
1311: WHERE hrw.date_worked = g_date_worked
1312: AND tim_id = g_tim_id
1313: AND tim.ID = hrw.tim_id

Line 1371: UPDATE hxt_det_hours_worked_f

1367: END IF;
1368:
1369: CLOSE overtime_cur;
1370:
1371: UPDATE hxt_det_hours_worked_f
1372: SET hours = l_hours_to_adjust - l_delta
1373: WHERE ROWID = l_rowid;
1374:
1375: OPEN daily_earn_rules_cur2 (g_ep_id);

Line 1527: hxt_det_hours_worked_f hrw,

1523: pay_element_types_f elt,
1524: hxt_earning_policies egp,
1525: hxt_per_aei_ddf_v asmv,
1526: per_assignments_f asm,
1527: hxt_det_hours_worked_f hrw,
1528: hxt_timecards_f tim
1529: WHERE hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
1530: start_day_of_week
1531: )

Line 1736: hxt_det_hours_worked_f dhw

1732: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
1733: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
1734: FROM hxt_pay_element_types_f_ddf_v eltv,
1735: pay_element_types_f elt,
1736: hxt_det_hours_worked_f dhw
1737: WHERE dhw.tim_id = g_tim_id
1738: AND dhw.date_worked = g_date_worked
1739: AND session_date BETWEEN dhw.effective_start_date
1740: AND dhw.effective_end_date

Line 1833: UPDATE hxt_det_hours_worked_f

1829: SET hours = l_hours_to_adjust,
1830: time_out = time_out - (p_hours_short / 24)
1831: WHERE ROWID = l_prem.prem_row_id;
1832: */
1833: UPDATE hxt_det_hours_worked_f
1834: SET hours = l_hours_to_adjust,
1835: time_out = time_out - (p_hours_short / 24)
1836: WHERE ROWID = l_prem.prem_row_id;
1837:

Line 1854: UPDATE hxt_det_hours_worked_f

1850: SET hours = l_hours_to_adjust,
1851: time_out = time_out - (p_hours_short / 24)
1852: WHERE ROWID = current_dtl_row.dhw_rowid;
1853: */
1854: UPDATE hxt_det_hours_worked_f
1855: SET hours = l_hours_to_adjust,
1856: time_out = time_out - (p_hours_short / 24)
1857: WHERE ROWID = current_dtl_row.dhw_rowid;
1858:

Line 1929: FROM hxt_det_hours_worked_f det

1925:
1926: -- det.group_id,
1927: det.earn_pol_id, det.state_name, det.county_name,
1928: det.city_name, det.zip_code
1929: FROM hxt_det_hours_worked_f det
1930: WHERE det.element_type_id = c_ovt_element --SIR 397
1931: AND det.date_worked <= c_date_worked
1932: AND session_date BETWEEN det.effective_start_date
1933: AND det.effective_end_date

Line 1977: FROM hxt_det_hours_worked_f hrw

1973: session_date DATE
1974: )
1975: IS
1976: SELECT NVL (SUM (hrw.hours), 0)
1977: FROM hxt_det_hours_worked_f hrw
1978: WHERE hrw.date_worked <= c_date_worked
1979: AND hrw.tim_id = c_tim_id
1980: AND hrw.element_type_id = c_second_elem
1981: AND session_date BETWEEN hrw.effective_start_date

Line 2152: UPDATE hxt_det_hours_worked_f

2148:
2149: --
2150: IF (l_ovt_hrs_cur.hours > l_hours_left)
2151: THEN
2152: UPDATE hxt_det_hours_worked_f
2153: SET hours = (hours - l_hours_left),
2154: time_out =
2155: time_in
2156: + ((l_ovt_hrs_cur.hours - l_hours_left) / 24)

Line 2159: UPDATE hxt_det_hours_worked_f

2155: time_in
2156: + ((l_ovt_hrs_cur.hours - l_hours_left) / 24)
2157: WHERE ROWID = l_ovt_hrs_cur.det_rowid;
2158: ELSE
2159: UPDATE hxt_det_hours_worked_f
2160: --SIR382 SET hours = (hours - l_hours_left),
2161: --SIR382 time_out = time_in + (l_hours_left/24)
2162: SET hours = 0,
2163: time_out = time_in

Line 2177: UPDATE hxt_det_hours_worked_f

2173: )
2174: LOOP
2175: IF (l_ovt_hrs_cur.hours > l_hours_left)
2176: THEN
2177: UPDATE hxt_det_hours_worked_f
2178: SET hours = (hours - l_hours_left),
2179: time_out =
2180: time_in
2181: + ((l_ovt_hrs_cur.hours - l_hours_left) / 24

Line 2185: UPDATE hxt_det_hours_worked_f

2181: + ((l_ovt_hrs_cur.hours - l_hours_left) / 24
2182: )
2183: WHERE ROWID = l_prem.prem_row_id;
2184: ELSE
2185: UPDATE hxt_det_hours_worked_f
2186: SET hours = 0,
2187: time_out = time_in
2188: WHERE ROWID = l_prem.prem_row_id;
2189: END IF;

Line 2452: UPDATE hxt_det_hours_worked_f

2448: + ((l_prem.prem_hours - deduct_premium) / 24
2449: )
2450: WHERE ROWID = l_prem.prem_row_id;
2451: */
2452: UPDATE hxt_det_hours_worked_f
2453: SET hours = l_prem.prem_hours - deduct_premium,
2454: time_out =
2455: time_in
2456: + ((l_prem.prem_hours - deduct_premium) / 24

Line 2486: DELETE FROM hxt_det_hours_worked_f

2482: /*
2483: DELETE FROM hxt_det_hours_worked
2484: WHERE ROWID = l_prem.prem_row_id;
2485: */
2486: DELETE FROM hxt_det_hours_worked_f
2487: WHERE ROWID = l_prem.prem_row_id;
2488: -- Bug 8279779
2489: -- Added this condition.
2490: IF deduct_premium <> 0

Line 2520: hxt_det_hours_worked_f dhw

2516: dhw.element_type_id,
2517: dhw.parent_id,
2518: ROWIDTOCHAR(dhw.rowid)
2519: FROM hxt_pay_element_types_f_ddf_v eltv,
2520: hxt_det_hours_worked_f dhw
2521: WHERE g_det_session_date BETWEEN dhw.effective_start_date
2522: AND dhw.effective_end_date
2523: AND eltv.element_type_id = dhw.element_type_id
2524: AND dhw.date_worked BETWEEN eltv.effective_start_date

Line 2703: UPDATE hxt_det_hours_worked_f

2699: THEN
2700: deduct_hours := FLOOR(((sdf_time(idx).time_out-sdf_time(idx).time_in)*24) /hdp_rules.time_period)
2701: *hdp_rules.hours;
2702: hr_utility.trace('adj stretch '||deduct_hours||' for '||hdp_rules.time_period);
2703: UPDATE hxt_det_hours_worked_f
2704: SET time_out = time_out - (deduct_hours/24),
2705: hours = hours - deduct_hours
2706: WHERE ROWID = CHARTOROWID(sdf_time(idx).rowid)
2707: RETURNING rowid INTO rw;

Line 2961: hxt_det_hours_worked_f dhw,

2957: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
2958: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
2959: FROM hxt_pay_element_types_f_ddf_v eltv,
2960: pay_element_types_f elt,
2961: hxt_det_hours_worked_f dhw,
2962: hxt_sum_hours_worked_f shw
2963: WHERE dhw.tim_id = g_tim_id
2964: AND dhw.date_worked = g_date_worked
2965: AND shw.id = dhw.parent_id

Line 2990: hxt_det_hours_worked_f dhw

2986: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
2987: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
2988: FROM hxt_pay_element_types_f_ddf_v eltv,
2989: pay_element_types_f elt,
2990: hxt_det_hours_worked_f dhw
2991: WHERE dhw.tim_id = g_tim_id
2992: AND dhw.parent_id = g_id
2993: AND dhw.date_worked = g_date_worked
2994: AND g_det_session_date BETWEEN dhw.effective_start_date

Line 3017: hxt_det_hours_worked_f dhw

3013: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
3014: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
3015: FROM hxt_pay_element_types_f_ddf_v eltv,
3016: pay_element_types_f elt,
3017: hxt_det_hours_worked_f dhw
3018: WHERE dhw.parent_id = g_id
3019: AND dhw.element_type_id = elt.element_type_id
3020: AND dhw.date_worked BETWEEN elt.effective_start_date
3021: AND elt.effective_end_date

Line 3042: hxt_det_hours_worked_f dhw,

3038: IS
3039: SELECT NVL (SUM (dhw.hours), 0) det_hours
3040: FROM hxt_pay_element_types_f_ddf_v eltv,
3041: pay_element_types_f elt,
3042: hxt_det_hours_worked_f dhw,
3043: hxt_sum_hours_worked_f shw
3044: WHERE shw.ID = g_id
3045: AND shw.ID = dhw.parent_id
3046: AND shw.element_type_id IS NULL

Line 3067: hxt_det_hours_worked_f dhw,

3063: IS
3064: SELECT NVL (SUM (dhw.hours), 0) det_hours
3065: FROM hxt_pay_element_types_f_ddf_v eltv,
3066: pay_element_types_f elt,
3067: hxt_det_hours_worked_f dhw,
3068: hxt_sum_hours_worked_f shw
3069: WHERE shw.ID = g_id
3070: AND shw.ID = dhw.parent_id
3071: AND shw.element_type_id IS NULL

Line 3100: hxt_det_hours_worked_f dhw,

3096: IS
3097: SELECT NVL (SUM (dhw.hours), 0) det_hours
3098: FROM hxt_pay_element_types_f_ddf_v eltv,
3099: pay_element_types_f elt,
3100: hxt_det_hours_worked_f dhw,
3101: hxt_sum_hours_worked_f shw
3102: WHERE shw.ID = g_id
3103: AND shw.ID = dhw.parent_id
3104: AND shw.element_type_id IS NULL

Line 3125: hxt_det_hours_worked_f dhw,

3121: IS
3122: SELECT NVL (SUM (dhw.hours), 0) det_hours
3123: FROM hxt_pay_element_types_f_ddf_v eltv,
3124: pay_element_types_f elt,
3125: hxt_det_hours_worked_f dhw,
3126: hxt_sum_hours_worked_f shw --<-- New Table
3127: WHERE elt.element_type_id = dhw.element_type_id
3128: AND shw.ID = dhw.parent_id --<-- New Join
3129: AND shw.element_type_id IS NULL

Line 3747: UPDATE hxt_det_hours_worked_f

3743: + ((osp_dtl_row.hours - deduct_hours) / 24
3744: )
3745: WHERE ROWID = osp_dtl_row.dhw_rowid;
3746: */
3747: UPDATE hxt_det_hours_worked_f
3748: SET hours = osp_dtl_row.hours - deduct_hours,
3749: time_out =
3750: time_in
3751: + ((osp_dtl_row.hours - deduct_hours) / 24

Line 3789: UPDATE hxt_det_hours_worked_f

3785: time_out = time_in
3786: + ((oth_dtl_row.hours - deduct_hours) / 24)
3787: WHERE ROWID = oth_dtl_row.dhw_rowid;
3788: */
3789: UPDATE hxt_det_hours_worked_f
3790: SET hours = oth_dtl_row.hours - deduct_hours,
3791: time_out = time_in
3792: + ((oth_dtl_row.hours - deduct_hours) / 24)
3793: WHERE ROWID = oth_dtl_row.dhw_rowid;

Line 3805: DELETE FROM hxt_det_hours_worked_f

3801: /*
3802: DELETE FROM hxt_det_hours_worked
3803: WHERE ROWID = current_dtl_row.dhw_rowid;
3804: */
3805: DELETE FROM hxt_det_hours_worked_f
3806: WHERE ROWID = current_dtl_row.dhw_rowid;
3807:
3808:
3809: IF g_debug

Line 3899: UPDATE hxt_det_hours_worked_f

3895: + ((osp_dtl_row.hours - deduct_hours) / 24
3896: )
3897: WHERE ROWID = osp_dtl_row.dhw_rowid;
3898: */
3899: UPDATE hxt_det_hours_worked_f
3900: SET hours = osp_dtl_row.hours - deduct_hours,
3901: time_out =
3902: time_in
3903: + ((osp_dtl_row.hours - deduct_hours) / 24

Line 3915: FROM hxt_det_hours_worked_f

3911: WHERE ROWID = osp_dtl_row.dhw_rowid;
3912: */
3913: SELECT hours
3914: INTO test_hours
3915: FROM hxt_det_hours_worked_f
3916: WHERE ROWID = osp_dtl_row.dhw_rowid;
3917:
3918:
3919: IF g_debug

Line 3958: UPDATE hxt_det_hours_worked_f

3954: time_out = time_in
3955: + ((oth_dtl_row.hours - deduct_hours) / 24)
3956: WHERE ROWID = oth_dtl_row.dhw_rowid;
3957: */
3958: UPDATE hxt_det_hours_worked_f
3959: SET hours = oth_dtl_row.hours - deduct_hours,
3960: time_out = time_in
3961: + ((oth_dtl_row.hours - deduct_hours) / 24)
3962: WHERE ROWID = oth_dtl_row.dhw_rowid;

Line 3983: UPDATE hxt_det_hours_worked_f

3979: time_in
3980: + ((current_dtl_row.hours - deduct_hours) / 24)
3981: WHERE ROWID = current_dtl_row.dhw_rowid;
3982: */
3983: UPDATE hxt_det_hours_worked_f
3984: SET hours = current_dtl_row.hours - deduct_hours,
3985: time_out =
3986: time_in
3987: + ((current_dtl_row.hours - deduct_hours) / 24)

Line 4060: hxt_det_hours_worked_f dhw,

4056: IS
4057: SELECT NVL (SUM (dhw.hours), 0) det_hours
4058: FROM hxt_pay_element_types_f_ddf_v eltv,
4059: pay_element_types_f elt,
4060: hxt_det_hours_worked_f dhw,
4061: hxt_sum_hours_worked_f shw --<-- New Table
4062: WHERE elt.element_type_id = dhw.element_type_id
4063: AND shw.ID = dhw.parent_id --<-- New Join
4064: AND shw.element_type_id IS NULL

Line 4593: FROM hxt_det_hours_worked_f det, hxt_timecards_f tim

4589:
4590: CURSOR chk_det_for_wrkd_elements (a_date_start DATE)
4591: IS
4592: SELECT det.element_type_id
4593: FROM hxt_det_hours_worked_f det, hxt_timecards_f tim
4594: WHERE det.tim_id = tim.ID
4595: AND g_det_session_date BETWEEN det.effective_start_date
4596: AND det.effective_end_date
4597: AND g_det_session_date BETWEEN tim.effective_start_date

Line 5000: hxt_det_hours_worked_f hrw

4996: shr.rate_multiple sum_rate_multiple
4997: FROM hxt_pay_element_types_f_ddf_v eltv,
4998: pay_element_types_f elt,
4999: hxt_sum_hours_worked_f shr,
5000: hxt_det_hours_worked_f hrw
5001: WHERE hrw.date_worked BETWEEN NEXT_DAY (a_date_worked - 7,
5002: start_day_of_week
5003: )
5004: AND a_date_worked

Line 5024: FROM hxt_det_hours_worked_f hrw,

5020:
5021: CURSOR clear_reg_detail_rec (c_parent_id NUMBER,session_date DATE)
5022: IS
5023: SELECT hrw.ROWID
5024: FROM hxt_det_hours_worked_f hrw,
5025: pay_element_types_f elt,
5026: hxt_pay_element_types_f_ddf_v eltv
5027: WHERE hrw.parent_id = c_parent_id
5028: AND hrw.element_type_id = elt.element_type_id

Line 5060: FROM hxt_det_hours_worked_f hrw,

5056: hrw.zip_code,
5057: shr.hourly_rate sum_hourly_rate,
5058: shr.amount sum_amount,
5059: shr.rate_multiple sum_rate_multiple
5060: FROM hxt_det_hours_worked_f hrw,
5061: hxt_sum_hours_worked_f shr,
5062: pay_element_types_f elt,
5063: hxt_pay_element_types_f_ddf_v eltv
5064: WHERE hrw.parent_id = c_parent_id

Line 5574: DELETE FROM hxt_det_hours_worked_f

5570: /*
5571: DELETE FROM hxt_det_hours_worked
5572: WHERE ROWID = l_del_rowid;
5573: */
5574: DELETE FROM hxt_det_hours_worked_f
5575: WHERE ROWID = l_del_rowid;
5576:
5577:
5578: IF g_debug

Line 6134: DELETE FROM hxt_det_hours_worked_f

6130: /*
6131: DELETE FROM hxt_det_hours_worked
6132: WHERE parent_id = g_parent_to_re_explode (j).parent_id;
6133: */
6134: DELETE FROM hxt_det_hours_worked_f
6135: WHERE parent_id = g_parent_to_re_explode (j).parent_id
6136: AND g_det_session_date BETWEEN effective_start_date
6137: AND effective_end_date;
6138:

Line 6666: FROM hxt_det_hours_worked_f hrw,

6662:
6663: CURSOR get_wkl_tot_incl_hrs_2day(effective_date DATE)
6664: IS
6665: SELECT NVL (SUM (hrw.hours), 0)
6666: FROM hxt_det_hours_worked_f hrw,
6667: hxt_timecards_f tim,
6668: hxt_earn_groups erg,
6669: hxt_earn_group_types egt,
6670: hxt_earning_policies erp,

Line 8062: hxt_det_hours_worked_f hrw,

8058: IS
8059: SELECT NVL (SUM (hrw.hours), 0)
8060: FROM hxt_pay_element_types_f_ddf_v eltv,
8061: pay_element_types_f elt2,
8062: hxt_det_hours_worked_f hrw,
8063: hxt_timecards_f tim,
8064: hxt_earn_groups erg,
8065: hxt_earn_group_types egt,
8066: hxt_earning_policies erp

Line 13830: FROM hxt_det_hours_worked_f hrw

13826:
13827: CURSOR zero_hrs_cur (c_tim_id NUMBER, c_date_worked DATE,c_session_date DATE)
13828: IS
13829: SELECT hrw.ROWID hrw_rowid
13830: FROM hxt_det_hours_worked_f hrw
13831: WHERE hrw.date_worked <= c_date_worked
13832: AND c_session_date BETWEEN hrw.effective_start_date
13833: AND hrw.effective_end_date
13834: AND hrw.tim_id = c_tim_id

Line 13868: hxt_det_hours_worked_f dhw

13864: eltv.hxt_premium_amount, eltv.hxt_earning_category,
13865: dhw.element_type_id
13866: FROM hxt_pay_element_types_f_ddf_v eltv,
13867: pay_element_types_f elt,
13868: hxt_det_hours_worked_f dhw
13869: WHERE dhw.tim_id = c_tim_id
13870: AND dhw.date_worked = c_date_worked
13871: AND elt.element_type_id = dhw.element_type_id
13872: AND dhw.date_worked BETWEEN elt.effective_start_date

Line 13883: FROM hxt_det_hours_worked_f hdw

13879: AND eltv.hxt_premium_type = 'FIXED'
13880: AND dhw.ID >
13881: (SELECT /*+ NO_UNNEST */
13882: MIN (hdw.ID)
13883: FROM hxt_det_hours_worked_f hdw
13884: WHERE hdw.tim_id = dhw.tim_id
13885: AND hdw.date_worked = c_date_worked
13886: AND hdw.element_type_id = dhw.element_type_id
13887: AND SYSDATE BETWEEN hdw.effective_start_date and hdw.effective_end_date)

Line 13927: DELETE FROM hxt_det_hours_worked_f

13923: /*
13924: DELETE FROM hxt_det_hours_worked
13925: WHERE ROWID = zero_rec.hrw_rowid;
13926: */
13927: DELETE FROM hxt_det_hours_worked_f
13928: WHERE ROWID = zero_rec.hrw_rowid;
13929:
13930: END LOOP;
13931:

Line 13953: DELETE FROM hxt_det_hours_worked_f

13949: /*
13950: DELETE FROM hxt_det_hours_worked
13951: WHERE ROWID = dup_flat_amt_rec.dhw_rowid;
13952: */
13953: DELETE FROM hxt_det_hours_worked_f
13954: WHERE ROWID = dup_flat_amt_rec.dhw_rowid;
13955:
13956: END LOOP;
13957:

Line 13999: FROM hxt_det_hours_worked_f hrw

13995: */
13996: CURSOR c_distinct_elements (a_parent_id NUMBER,session_date DATE)
13997: IS
13998: SELECT DISTINCT element_type_id
13999: FROM hxt_det_hours_worked_f hrw
14000: WHERE hrw.parent_id = a_parent_id
14001: AND session_date BETWEEN hrw.effective_start_date
14002: AND hrw.effective_end_date ;
14003: /* This cursor brings back all the detail records for an element */

Line 14019: FROM hxt_det_hours_worked_f hrw

14015: IS
14016: SELECT hrw.ROWID hrw_rowid, hrw.time_in, hrw.time_out, hrw.hours,
14017: hrw.amount, hrw.hourly_rate, hrw.rate_multiple,
14018: hrw.prev_wage_code
14019: FROM hxt_det_hours_worked_f hrw
14020: WHERE hrw.parent_id = a_parent_id
14021: AND session_date BETWEEN hrw.effective_start_date
14022: AND hrw.effective_end_date
14023: AND hrw.element_type_id = a_element_type_id

Line 14246: DELETE FROM hxt_det_hours_worked_f

14242: UPDATE hxt_det_hours_worked
14243: SET hours = ln_hours
14244: WHERE ROWID = ln_row_id;
14245: */
14246: DELETE FROM hxt_det_hours_worked_f
14247: WHERE ROWID = row_id1;
14248:
14249: UPDATE hxt_det_hours_worked_f
14250: SET hours = ln_hours

Line 14249: UPDATE hxt_det_hours_worked_f

14245: */
14246: DELETE FROM hxt_det_hours_worked_f
14247: WHERE ROWID = row_id1;
14248:
14249: UPDATE hxt_det_hours_worked_f
14250: SET hours = ln_hours
14251: WHERE ROWID = ln_row_id;
14252:
14253: END IF;

Line 14299: DELETE FROM hxt_det_hours_worked_f

14295: /*
14296: DELETE FROM hxt_det_hours_worked
14297: WHERE ROWID = row_id1;
14298: */
14299: DELETE FROM hxt_det_hours_worked_f
14300: WHERE ROWID = row_id1;
14301:
14302: IF g_debug
14303: THEN

Line 14351: UPDATE hxt_det_hours_worked_f

14347: SET time_out = ln_end_time,
14348: hours = ln_hours_worked
14349: WHERE ROWID = ln_row_id;
14350: */
14351: UPDATE hxt_det_hours_worked_f
14352: SET time_out = ln_end_time,
14353: hours = ln_hours_worked
14354: WHERE ROWID = ln_row_id;
14355:

Line 14580: FROM hxt_det_hours_worked_f

14576: IF a_hours_to_pay = 0 and (a_amount is null or a_amount = 0) /* Bug: 5744162 */
14577: THEN
14578: SELECT count(*)
14579: INTO l_det_count
14580: FROM hxt_det_hours_worked_f
14581: WHERE date_worked = a_date_worked
14582: AND assignment_id = a_assignment_id;
14583:
14584: IF l_det_count = 0 THEN

Line 15041: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,

15037:
15038: --------------------------------------------------------------------------------
15039: --BEGIN HXT11i1
15040: FUNCTION contig_hours_worked (
15041: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15042: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15043: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
15044: )
15045: RETURN hxt_det_hours_worked.hours%TYPE

Line 15043: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE

15039: --BEGIN HXT11i1
15040: FUNCTION contig_hours_worked (
15041: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15042: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15043: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
15044: )
15045: RETURN hxt_det_hours_worked.hours%TYPE
15046: IS
15047: /* Local Variable Declaration */

Line 15054: from hxt_det_hours_worked_f det,

15050:
15051: CURSOR daily_hol_total(session_date IN DATE)
15052: IS
15053: select NVL(SUM(det.hours),0)
15054: from hxt_det_hours_worked_f det,
15055: hxt_sum_hours_worked_f sum,
15056: hxt_earning_rules er
15057: WHERE det.date_worked = g_date_worked
15058: AND sum.id = det.parent_id

Line 15074: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,

15070:
15071:
15072: /*Cursor Declaration */
15073: CURSOR csr_work_hrs (
15074: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
15075: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE,
15076: session_date DATE
15077: )
15078: IS

Line 15075: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE,

15071:
15072: /*Cursor Declaration */
15073: CURSOR csr_work_hrs (
15074: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
15075: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE,
15076: session_date DATE
15077: )
15078: IS
15079: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category

Line 15080: FROM hxt_det_hours_worked_f hrw,

15076: session_date DATE
15077: )
15078: IS
15079: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category
15080: FROM hxt_det_hours_worked_f hrw,
15081: hxt_pay_element_types_f_ddf_v eltv,
15082: pay_element_types_f elt
15083: WHERE elt.element_type_id = hrw.element_type_id
15084: AND hrw.date_worked BETWEEN elt.effective_start_date

Line 15192: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,

15188: -- will pick up only those hours which are not override entries
15189: -- entered by the user.
15190:
15191: FUNCTION contig_hours_worked2 (
15192: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15193: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15194: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
15195: )
15196: RETURN hxt_det_hours_worked.hours%TYPE

Line 15194: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE

15190:
15191: FUNCTION contig_hours_worked2 (
15192: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15193: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15194: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE
15195: )
15196: RETURN hxt_det_hours_worked.hours%TYPE
15197: IS
15198: /* Local Variable Declaration */

Line 15206: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,

15202:
15203: -- Pick up all hours worked which are not override hours
15204: --
15205: CURSOR csr_work_hrs (
15206: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
15207: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE,
15208: session_date DATE
15209: )
15210: IS

Line 15207: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE,

15203: -- Pick up all hours worked which are not override hours
15204: --
15205: CURSOR csr_work_hrs (
15206: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
15207: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE,
15208: session_date DATE
15209: )
15210: IS
15211: SELECT SUM(hrw.hours)

Line 15212: FROM hxt_det_hours_worked_f hrw,

15208: session_date DATE
15209: )
15210: IS
15211: SELECT SUM(hrw.hours)
15212: FROM hxt_det_hours_worked_f hrw,
15213: hxt_pay_element_types_f_ddf_v eltv,
15214: pay_element_types_f elt,
15215: hxt_sum_hours_worked_f sum
15216: WHERE elt.element_type_id = hrw.element_type_id

Line 15275: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,

15271: --
15272: -------------------------------------------------------------------------------
15273: --
15274: PROCEDURE overtime_hoursoverride (
15275: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15276: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15277: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
15278: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
15279: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE

Line 15277: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,

15273: --
15274: PROCEDURE overtime_hoursoverride (
15275: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15276: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15277: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
15278: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
15279: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
15280: )
15281: -- RETURN hxt_det_hours_worked.hours%TYPE

Line 15278: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,

15274: PROCEDURE overtime_hoursoverride (
15275: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15276: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15277: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
15278: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
15279: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
15280: )
15281: -- RETURN hxt_det_hours_worked.hours%TYPE
15282: IS

Line 15279: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE

15275: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE,
15276: p_egt_id IN hxt_earn_groups.egt_id%TYPE,
15277: p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
15278: p_override_hrs OUT NOCOPY hxt_det_hours_worked_f.hours%TYPE,
15279: p_override_element OUT NOCOPY hxt_det_hours_worked_f.element_type_id%TYPE
15280: )
15281: -- RETURN hxt_det_hours_worked.hours%TYPE
15282: IS
15283: /* Local Variable Declaration */

Line 15293: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,

15289: -- Changed the below cursor to pick up session date from global variable
15290: -- instead of fnd_sessions table.
15291: /*
15292: CURSOR csr_override_hrs (
15293: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
15294: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE
15295: )
15296: IS
15297: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category

Line 15294: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE

15290: -- instead of fnd_sessions table.
15291: /*
15292: CURSOR csr_override_hrs (
15293: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
15294: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE
15295: )
15296: IS
15297: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category
15298: FROM hxt_sum_hours_worked hrw,

Line 15321: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,

15317: AND nvl(eltv.exclude_from_explosion, 'N') <> 'Y'; /* Bug: 4489952 */
15318:
15319:
15320: CURSOR csr_override_hrs (
15321: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
15322: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE,
15323: p_session_date DATE
15324: )
15325: IS

Line 15322: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE,

15318:
15319:
15320: CURSOR csr_override_hrs (
15321: p_date_worked hxt_det_hours_worked_f.date_worked%TYPE,
15322: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE,
15323: p_session_date DATE
15324: )
15325: IS
15326: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category