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

Line 1055: hxt_det_hours_worked_f hrw,

1051: IS
1052: SELECT hrw.hours hours_worked, hrw.ROWID hrw_rowid -- OHM199
1053: FROM hxt_timecards_x tim,
1054: per_time_periods ptp,
1055: hxt_det_hours_worked_f hrw,
1056: per_assignments_f asm,
1057: pay_element_types_f elt
1058: WHERE hrw.assignment_id = p_assignment_id
1059: AND asm.assignment_id = hrw.assignment_id

Line 1175: hxt_det_hours_worked_f hrw,

1171: IS
1172: SELECT hrw.amount amount, hrw.ROWID hrw_rowid -- OHM199
1173: FROM hxt_timecards_x tim,
1174: per_time_periods ptp,
1175: hxt_det_hours_worked_f hrw,
1176: per_assignments_f asm,
1177: pay_element_types_f elt
1178: WHERE hrw.assignment_id = p_assignment_id
1179: AND asm.assignment_id = hrw.assignment_id

Line 1354: UPDATE hxt_det_hours_worked_f

1350:
1351: -- begin OHM199
1352: IF l_hours_to_send = 0
1353: THEN
1354: UPDATE hxt_det_hours_worked_f
1355: SET pay_status = 'D',
1356: last_update_date = SYSDATE
1357: WHERE ROWID = l_prev_hours_rec.hrw_rowid
1358: -- ADDED BY MV: IF THERE IS ONLY ONE ROW, PREV and CURR records

Line 1362: UPDATE hxt_det_hours_worked_f

1358: -- ADDED BY MV: IF THERE IS ONLY ONE ROW, PREV and CURR records
1359: -- are the same; we should not update such records.
1360: AND l_prev_hours_rec.hrw_rowid <> l_hours_rec.hrw_rowid;
1361: ELSE
1362: UPDATE hxt_det_hours_worked_f
1363: SET pay_status = 'A',
1364: last_update_date = SYSDATE
1365: WHERE ROWID = l_prev_hours_rec.hrw_rowid;
1366: END IF;

Line 1541: UPDATE hxt_det_hours_worked_f

1537: l_location := 'Step 1E';
1538:
1539:
1540: -- begin OHM180
1541: UPDATE hxt_det_hours_worked_f
1542: SET retro_pbl_line_id = l_batch_line_id
1543: WHERE ROWID = l_hours_rec.hrw_rowid;
1544:
1545: -- end OHM180

Line 1614: UPDATE hxt_det_hours_worked_f

1610:
1611: -- begin OHM199
1612: IF l_amount_to_send = 0
1613: THEN
1614: UPDATE hxt_det_hours_worked_f
1615: SET pay_status = 'D',
1616: last_update_date = SYSDATE
1617: WHERE ROWID = l_prev_amount_rec.hrw_rowid
1618: -- ADDED BY MV: IF THERE IS ONLY ONE ROW, PREV and CURR records

Line 1622: UPDATE hxt_det_hours_worked_f

1618: -- ADDED BY MV: IF THERE IS ONLY ONE ROW, PREV and CURR records
1619: -- are the same; we should not update such records.
1620: AND l_prev_amount_rec.hrw_rowid <> l_amount_rec.hrw_rowid;
1621: ELSE
1622: UPDATE hxt_det_hours_worked_f
1623: SET pay_status = 'A',
1624: last_update_date = SYSDATE
1625: WHERE ROWID = l_prev_amount_rec.hrw_rowid;
1626: END IF;

Line 1763: UPDATE hxt_det_hours_worked_f

1759: hxt_util.DEBUG (' insert amount to paymix.'); -- debug only --HXT115
1760:
1761:
1762: -- begin OHM180
1763: UPDATE hxt_det_hours_worked_f
1764: SET retro_pbl_line_id = l_batch_line_id
1765: WHERE ROWID = l_amount_rec.hrw_rowid;
1766:
1767: -- end OHM180

Line 1860: UPDATE hxt_det_hours_worked_f

1856:
1857: PROCEDURE mark_prev_hours_rows (p_tim_id IN NUMBER)
1858: IS
1859: BEGIN
1860: UPDATE hxt_det_hours_worked_f
1861: SET pay_status = 'D',
1862: last_update_date = SYSDATE
1863: WHERE ROWID IN
1864: (SELECT hrw.ROWID

Line 1865: FROM hxt_det_hours_worked_f hrw

1861: SET pay_status = 'D',
1862: last_update_date = SYSDATE
1863: WHERE ROWID IN
1864: (SELECT hrw.ROWID
1865: FROM hxt_det_hours_worked_f hrw
1866: WHERE hrw.tim_id = p_tim_id
1867: AND hrw.pay_status = 'C'
1868: AND hrw.amount IS NULL
1869: AND hrw.parent_id > 0

Line 1939: UPDATE hxt_det_hours_worked_f

1935: retro.fcl_tax_rule_code,
1936: 'ZZZZZZZZZZ'
1937: )));
1938:
1939: UPDATE hxt_det_hours_worked_f
1940: SET pay_status = 'A',
1941: last_update_date = SYSDATE
1942: WHERE ROWID IN
1943: (SELECT hrw.ROWID

Line 1944: FROM hxt_det_hours_worked_f hrw

1940: SET pay_status = 'A',
1941: last_update_date = SYSDATE
1942: WHERE ROWID IN
1943: (SELECT hrw.ROWID
1944: FROM hxt_det_hours_worked_f hrw
1945: WHERE hrw.tim_id = p_tim_id
1946: AND hrw.pay_status = 'C'
1947: AND hrw.amount IS NULL
1948: AND hrw.parent_id > 0

Line 2022: UPDATE hxt_det_hours_worked_f

2018:
2019: PROCEDURE mark_prev_amount_rows (p_tim_id IN NUMBER)
2020: IS
2021: BEGIN
2022: UPDATE hxt_det_hours_worked_f
2023: SET pay_status = 'D',
2024: last_update_date = SYSDATE
2025: WHERE ROWID IN
2026: (SELECT hrw.ROWID

Line 2027: FROM hxt_det_hours_worked_f hrw

2023: SET pay_status = 'D',
2024: last_update_date = SYSDATE
2025: WHERE ROWID IN
2026: (SELECT hrw.ROWID
2027: FROM hxt_det_hours_worked_f hrw
2028: WHERE hrw.tim_id = p_tim_id
2029: AND hrw.pay_status = 'C'
2030: AND hrw.amount IS NOT NULL
2031: AND hrw.parent_id > 0

Line 2102: UPDATE hxt_det_hours_worked_f

2098: retro.fcl_tax_rule_code,
2099: 'ZZZZZZZZZZ'
2100: )));
2101:
2102: UPDATE hxt_det_hours_worked_f
2103: SET pay_status = 'A',
2104: last_update_date = SYSDATE
2105: WHERE ROWID IN
2106: (SELECT hrw.ROWID

Line 2107: FROM hxt_det_hours_worked_f hrw

2103: SET pay_status = 'A',
2104: last_update_date = SYSDATE
2105: WHERE ROWID IN
2106: (SELECT hrw.ROWID
2107: FROM hxt_det_hours_worked_f hrw
2108: WHERE hrw.tim_id = p_tim_id
2109: AND hrw.pay_status = 'C'
2110: AND hrw.amount IS NOT NULL
2111: AND hrw.parent_id > 0

Line 2186: UPDATE hxt_det_hours_worked_f

2182:
2183: PROCEDURE mark_retro_rows_complete (p_tim_id NUMBER)
2184: IS
2185: BEGIN
2186: UPDATE hxt_det_hours_worked_f
2187: SET pay_status = 'C',
2188: last_update_date = SYSDATE
2189: WHERE ROWID IN (SELECT hrw.ROWID
2190: FROM hxt_det_hours_worked_x hrw

Line 2273: hxt_det_hours_worked_f hrw,

2269: hrw.city_name,
2270: hrw.zip_code
2271: FROM hxt_timecards_x tim, /* SIR416 PWM 21MAR00 */
2272: per_time_periods ptp,
2273: hxt_det_hours_worked_f hrw,
2274: hr_lookups hcl, --GLOBAL
2275: per_assignments_f asm,
2276: pay_element_types_f elt,
2277: hxt_pay_element_types_f_ddf_v eltv, --SIR65

Line 2337: l_hourly_rate hxt_det_hours_worked_f.hourly_rate%TYPE := NULL;

2333: l_retcode NUMBER; /* BSE107 */
2334:
2335: --BEGIN GLOBAL
2336: -- l_hourly_rate pay_pdt_batch_lines.hourly_rate%TYPE := NULL; --SIR65
2337: l_hourly_rate hxt_det_hours_worked_f.hourly_rate%TYPE := NULL;
2338:
2339:
2340: --CURSOR rate_paid_cur(c_line_id NUMBER) IS --SIR65
2341: --SELECT pbl.hourly_rate --SIR65

Line 2671: UPDATE hxt_det_hours_worked_f

2667: );
2668:
2669:
2670: --END GLOBAL
2671: UPDATE hxt_det_hours_worked_f
2672: SET pay_status = 'B',
2673: last_update_date = SYSDATE,
2674: retro_pbl_line_id = l_batch_line_id -- OHM180
2675: WHERE ROWID = l_leftover.hrw_rowid;

Line 2754: hxt_det_hours_worked_f hrw,

2750: hrw.zip_code
2751: /* BSE107 */
2752: FROM hxt_timecards_x tim, /* SIR416 PWM 21MAR00 */
2753: per_time_periods ptp,
2754: hxt_det_hours_worked_f hrw,
2755: hr_lookups hcl, --GLOBAL
2756: per_assignments_f asm,
2757: pay_element_types_f elt,
2758: pay_cost_allocation_keyflex pcak,

Line 2940: UPDATE hxt_det_hours_worked_f

2936: );
2937:
2938:
2939: --END GLOBAL
2940: UPDATE hxt_det_hours_worked_f
2941: SET pay_status = 'B',
2942: last_update_date = SYSDATE,
2943: retro_pbl_line_id = l_batch_line_id -- OHM180
2944: WHERE ROWID = l_leftover.hrw_rowid;