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_SUM_HOURS_WORKED_F

Line 1209: hxt_sum_hours_worked_f sum,

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
1213: AND sum.element_type_id IS NULL

Line 2534: FROM hxt_sum_hours_worked_f

2530:
2531:
2532: CURSOR get_valid_parent(p_id IN NUMBER)
2533: IS SELECT 1
2534: FROM hxt_sum_hours_worked_f
2535: WHERE id = p_id
2536: AND g_det_session_date BETWEEN effective_start_date
2537: AND effective_end_date;
2538:

Line 2923: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,

2919: AND g_date_worked BETWEEN hei.effective_start_date
2920: AND hei.effective_end_date);
2921:
2922: CURSOR csr_work_hrs (
2923: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,
2924: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE
2925: )
2926: IS
2927: SELECT shw.ID, shw.hours, shw.time_in, shw.time_out

Line 2924: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE

2920: AND hei.effective_end_date);
2921:
2922: CURSOR csr_work_hrs (
2923: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,
2924: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE
2925: )
2926: IS
2927: SELECT shw.ID, shw.hours, shw.time_in, shw.time_out
2928: FROM hxt_sum_hours_worked shw

Line 2952: -- Added hxt_sum_hours_worked_f and associated conditions

2948:
2949: */
2950:
2951: -- Bug 8534160
2952: -- Added hxt_sum_hours_worked_f and associated conditions
2953: -- so that Override elements would not be affected.
2954:
2955: CURSOR current_dtl
2956: IS

Line 2962: hxt_sum_hours_worked_f shw

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
2966: AND shw.element_type_id IS NULL

Line 3043: hxt_sum_hours_worked_f shw

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
3047: AND dhw.element_type_id = elt.element_type_id

Line 3068: hxt_sum_hours_worked_f shw

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
3072: AND dhw.element_type_id = elt.element_type_id

Line 3101: hxt_sum_hours_worked_f shw

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
3105: AND dhw.element_type_id = elt.element_type_id

Line 3126: hxt_sum_hours_worked_f shw --<-- New Table

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
3130: --<-- New check: No Hours Override

Line 3149: FROM hxt_sum_hours_worked_f shw

3145: CURSOR get_sum_hrs
3146: IS
3147: SELECT NVL (SUM (shw.hours), 0) sum_hours,
3148: COUNT(*) sum_count /*** 4969936 ***/
3149: FROM hxt_sum_hours_worked_f shw
3150: WHERE tim_id = g_tim_id
3151: AND not exists ( SELECT 'X' /* Bug: 4489952 */
3152: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw
3153: WHERE hei.element_type_id = dhw.element_type_id

Line 3177: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,

3173: AND g_date_worked BETWEEN hei.effective_start_date
3174: AND hei.effective_end_date);
3175:
3176: CURSOR csr_work_hrs (
3177: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,
3178: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE
3179: )
3180: IS
3181: SELECT shw.ID, shw.hours, shw.time_in, shw.time_out

Line 3178: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE

3174: AND hei.effective_end_date);
3175:
3176: CURSOR csr_work_hrs (
3177: p_date_worked hxt_sum_hours_worked_f.date_worked%TYPE,
3178: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE
3179: )
3180: IS
3181: SELECT shw.ID, shw.hours, shw.time_in, shw.time_out
3182: FROM hxt_sum_hours_worked_f shw

Line 3182: FROM hxt_sum_hours_worked_f shw

3178: p_tim_id hxt_sum_hours_worked_f.tim_id%TYPE
3179: )
3180: IS
3181: SELECT shw.ID, shw.hours, shw.time_in, shw.time_out
3182: FROM hxt_sum_hours_worked_f shw
3183: WHERE shw.tim_id = p_tim_id
3184: AND shw.date_worked = p_date_worked
3185: AND g_det_session_date BETWEEN shw.effective_start_date
3186: AND shw.effective_end_date

Line 4061: hxt_sum_hours_worked_f shw --<-- New Table

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
4065: --<-- New check: No Hours Override

Line 4093: FROM hxt_sum_hours_worked_f

4089:
4090: CURSOR get_sum_time_out
4091: IS
4092: SELECT time_in, time_out
4093: FROM hxt_sum_hours_worked_f
4094: WHERE ID = g_id
4095: AND g_det_session_date BETWEEN effective_start_date
4096: AND effective_end_date
4097: ;

Line 4403: FROM hxt_sum_hours_worked_f sm

4399: session_date DATE
4400: )
4401: IS
4402: SELECT sm.date_worked
4403: FROM hxt_sum_hours_worked_f sm
4404: , hxt_timecards_f tim
4405: WHERE tim.for_person_id = g_person_id
4406: AND sm.tim_id = tim.ID
4407: AND session_date BETWEEN sm.effective_start_date

Line 4570: FROM hxt_sum_hours_worked_f sm, hxt_timecards_f tim

4566: a_date_worked DATE
4567: )
4568: IS
4569: SELECT sm.date_worked
4570: FROM hxt_sum_hours_worked_f sm, hxt_timecards_f tim
4571: WHERE tim.for_person_id = g_person_id
4572: AND sm.tim_id = tim.ID
4573: AND g_det_session_date BETWEEN sm.effective_start_date
4574: AND sm.effective_end_date

Line 4999: hxt_sum_hours_worked_f shr,

4995: shr.amount sum_amount,
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: )

Line 5061: hxt_sum_hours_worked_f shr,

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
5065: AND hrw.element_type_id = elt.element_type_id

Line 5247: hxt_sum_hours_worked_f shr,

5243: SELECT COUNT (*)
5244: INTO l_abs_count
5245: FROM hxt_pay_element_types_f_ddf_v eltv,
5246: pay_element_types_f elt,
5247: hxt_sum_hours_worked_f shr,
5248: hxt_timecards_f tim
5249: WHERE shr.date_worked BETWEEN NEXT_DAY (c_date_worked - 7,
5250: start_day_of_week
5251: )

Line 15055: hxt_sum_hours_worked_f sum,

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
15059: AND sum.element_type_id IS NULL

Line 15215: hxt_sum_hours_worked_f sum

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
15217: AND hrw.date_worked BETWEEN elt.effective_start_date
15218: AND elt.effective_end_date
15219: AND session_date BETWEEN hrw.effective_start_date

Line 15327: FROM hxt_sum_hours_worked_f hrw,

15323: p_session_date DATE
15324: )
15325: IS
15326: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category
15327: FROM hxt_sum_hours_worked_f hrw,
15328: hxt_pay_element_types_f_ddf_v eltv,
15329: pay_element_types_f elt
15330: WHERE elt.element_type_id = hrw.element_type_id
15331: AND hrw.date_worked BETWEEN elt.effective_start_date