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.

[Home] [Help]

APPS.HXT_TIME_DETAIL dependencies on HXT_SUM_HOURS_WORKED

Line 1993: hxt_sum_hours_worked shw

1989: SELECT NVL (SUM (dhw.hours), 0) det_hours
1990: FROM hxt_pay_element_types_f_ddf_v eltv,
1991: pay_element_types_f elt,
1992: hxt_det_hours_worked dhw,
1993: hxt_sum_hours_worked shw
1994: WHERE shw.ID = g_id
1995: AND shw.ID = dhw.parent_id
1996: AND shw.element_type_id IS NULL
1997: AND dhw.element_type_id = elt.element_type_id

Line 2014: hxt_sum_hours_worked shw

2010: SELECT NVL (SUM (dhw.hours), 0) det_hours
2011: FROM hxt_pay_element_types_f_ddf_v eltv,
2012: pay_element_types_f elt,
2013: hxt_det_hours_worked dhw,
2014: hxt_sum_hours_worked shw
2015: WHERE shw.ID = g_id
2016: AND shw.ID = dhw.parent_id
2017: AND shw.element_type_id IS NULL
2018: AND dhw.element_type_id = elt.element_type_id

Line 2043: hxt_sum_hours_worked shw

2039: SELECT NVL (SUM (dhw.hours), 0) det_hours
2040: FROM hxt_pay_element_types_f_ddf_v eltv,
2041: pay_element_types_f elt,
2042: hxt_det_hours_worked dhw,
2043: hxt_sum_hours_worked shw
2044: WHERE shw.ID = g_id
2045: AND shw.ID = dhw.parent_id
2046: AND shw.element_type_id IS NULL
2047: AND dhw.element_type_id = elt.element_type_id

Line 2064: hxt_sum_hours_worked shw --<-- New Table

2060: SELECT NVL (SUM (dhw.hours), 0) det_hours
2061: FROM hxt_pay_element_types_f_ddf_v eltv,
2062: pay_element_types_f elt,
2063: hxt_det_hours_worked dhw,
2064: hxt_sum_hours_worked shw --<-- New Table
2065: WHERE elt.element_type_id = dhw.element_type_id
2066: AND shw.ID = dhw.parent_id --<-- New Join
2067: AND shw.element_type_id IS NULL
2068: --<-- New check: No Hours Override

Line 2083: FROM hxt_sum_hours_worked shw

2079: CURSOR get_sum_hrs
2080: IS
2081: SELECT NVL (SUM (shw.hours), 0) sum_hours,
2082: COUNT(*) sum_count /*** 4969936 ***/
2083: FROM hxt_sum_hours_worked shw
2084: WHERE tim_id = g_tim_id AND shw.date_worked = g_date_worked
2085: AND not exists ( SELECT 'X' /* Bug: 4489952 */
2086: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw
2087: WHERE hei.element_type_id = dhw.element_type_id

Line 2096: FROM hxt_sum_hours_worked shw

2092:
2093: CURSOR get_sum_time_out
2094: IS
2095: SELECT hours, time_in, time_out
2096: FROM hxt_sum_hours_worked shw
2097: WHERE ID = g_id
2098: AND not exists ( SELECT 'X' /* Bug: 4489952 */
2099: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw
2100: WHERE hei.element_type_id = dhw.element_type_id

Line 2107: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,

2103: AND g_date_worked BETWEEN hei.effective_start_date
2104: AND hei.effective_end_date);
2105:
2106: CURSOR csr_work_hrs (
2107: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,
2108: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE
2109: )
2110: IS
2111: SELECT shw.ID, shw.hours, shw.time_in, shw.time_out

Line 2108: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE

2104: AND hei.effective_end_date);
2105:
2106: CURSOR csr_work_hrs (
2107: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,
2108: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE
2109: )
2110: IS
2111: SELECT shw.ID, shw.hours, shw.time_in, shw.time_out
2112: FROM hxt_sum_hours_worked shw

Line 2112: FROM hxt_sum_hours_worked shw

2108: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE
2109: )
2110: IS
2111: SELECT shw.ID, shw.hours, shw.time_in, shw.time_out
2112: FROM hxt_sum_hours_worked shw
2113: WHERE shw.tim_id = p_tim_id
2114: AND shw.date_worked = p_date_worked
2115: AND (( shw.time_in IS NOT NULL
2116: AND shw.time_out IS NOT NULL

Line 2876: hxt_sum_hours_worked shw --<-- New Table

2872: SELECT NVL (SUM (dhw.hours), 0) det_hours
2873: FROM hxt_pay_element_types_f_ddf_v eltv,
2874: pay_element_types_f elt,
2875: hxt_det_hours_worked dhw,
2876: hxt_sum_hours_worked shw --<-- New Table
2877: WHERE elt.element_type_id = dhw.element_type_id
2878: AND shw.ID = dhw.parent_id --<-- New Join
2879: AND shw.element_type_id IS NULL
2880: --<-- New check: No Hours Override

Line 2903: FROM hxt_sum_hours_worked

2899:
2900: CURSOR get_sum_time_out
2901: IS
2902: SELECT time_in, time_out
2903: FROM hxt_sum_hours_worked
2904: WHERE ID = g_id;
2905:
2906: addback_hours NUMBER := 0;
2907: deduct_hours NUMBER := 0;

Line 3183: FROM hxt_sum_hours_worked sm

3179: a_date_worked DATE
3180: )
3181: IS
3182: SELECT sm.date_worked
3183: FROM hxt_sum_hours_worked sm
3184: --Added this join to support the OTLR Recurring Preiod Preference
3185: , hxt_timecards tim
3186: --WHERE sm.tim_id = c_tim_id
3187:

Line 3303: FROM hxt_sum_hours_worked sm, hxt_timecards tim

3299: a_date_worked DATE
3300: )
3301: IS
3302: SELECT sm.date_worked
3303: FROM hxt_sum_hours_worked sm, hxt_timecards tim
3304: WHERE tim.for_person_id = g_person_id
3305: AND sm.tim_id = tim.ID
3306: AND sm.hours > 0
3307: AND sm.date_worked = c_date_worked

Line 3621: hxt_sum_hours_worked shr,

3617: hrw.job_id, hrw.state_name, hrw.county_name,
3618: hrw.city_name, hrw.zip_code
3619: FROM hxt_pay_element_types_f_ddf_v eltv,
3620: pay_element_types_f elt,
3621: hxt_sum_hours_worked shr,
3622: hxt_det_hours_worked hrw
3623: WHERE hrw.date_worked BETWEEN NEXT_DAY (a_date_worked - 7,
3624: start_day_of_week
3625: )

Line 3670: hxt_sum_hours_worked shr,

3666: hrw.effective_start_date, hrw.effective_end_date,
3667: hrw.job_id, hrw.state_name, hrw.county_name, hrw.city_name,
3668: hrw.zip_code
3669: FROM hxt_det_hours_worked hrw,
3670: hxt_sum_hours_worked shr,
3671: pay_element_types_f elt,
3672: hxt_pay_element_types_f_ddf_v eltv
3673: WHERE hrw.parent_id = c_parent_id
3674: AND hrw.element_type_id = elt.element_type_id

Line 3804: hxt_sum_hours_worked shr,

3800: SELECT COUNT (*)
3801: INTO l_abs_count
3802: FROM hxt_pay_element_types_f_ddf_v eltv,
3803: pay_element_types_f elt,
3804: hxt_sum_hours_worked shr,
3805: hxt_timecards tim
3806: WHERE shr.date_worked BETWEEN NEXT_DAY (c_date_worked - 7,
3807: start_day_of_week
3808: )

Line 13248: FROM hxt_sum_hours_worked hrw,

13244: p_tim_id hxt_det_hours_worked_f.tim_id%TYPE
13245: )
13246: IS
13247: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category
13248: FROM hxt_sum_hours_worked hrw,
13249: hxt_pay_element_types_f_ddf_v eltv,
13250: pay_element_types_f elt
13251: WHERE elt.element_type_id = hrw.element_type_id
13252: AND hrw.date_worked BETWEEN elt.effective_start_date