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 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 2809: hxt_sum_hours_worked shw

2805: SELECT NVL (SUM (dhw.hours), 0) det_hours
2806: FROM hxt_pay_element_types_f_ddf_v eltv,
2807: pay_element_types_f elt,
2808: hxt_det_hours_worked dhw,
2809: hxt_sum_hours_worked shw
2810: WHERE shw.ID = g_id
2811: AND shw.ID = dhw.parent_id
2812: AND shw.element_type_id IS NULL
2813: AND dhw.element_type_id = elt.element_type_id

Line 2830: hxt_sum_hours_worked shw

2826: SELECT NVL (SUM (dhw.hours), 0) det_hours
2827: FROM hxt_pay_element_types_f_ddf_v eltv,
2828: pay_element_types_f elt,
2829: hxt_det_hours_worked dhw,
2830: hxt_sum_hours_worked shw
2831: WHERE shw.ID = g_id
2832: AND shw.ID = dhw.parent_id
2833: AND shw.element_type_id IS NULL
2834: AND dhw.element_type_id = elt.element_type_id

Line 2859: hxt_sum_hours_worked shw

2855: SELECT NVL (SUM (dhw.hours), 0) det_hours
2856: FROM hxt_pay_element_types_f_ddf_v eltv,
2857: pay_element_types_f elt,
2858: hxt_det_hours_worked dhw,
2859: hxt_sum_hours_worked shw
2860: WHERE shw.ID = g_id
2861: AND shw.ID = dhw.parent_id
2862: AND shw.element_type_id IS NULL
2863: AND dhw.element_type_id = elt.element_type_id

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

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

Line 2899: FROM hxt_sum_hours_worked shw

2895: CURSOR get_sum_hrs
2896: IS
2897: SELECT NVL (SUM (shw.hours), 0) sum_hours,
2898: COUNT(*) sum_count /*** 4969936 **
2899: FROM hxt_sum_hours_worked shw
2900: WHERE tim_id = g_tim_id AND shw.date_worked = g_date_worked
2901: AND not exists ( SELECT 'X' /* Bug: 4489952 *
2902: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw
2903: WHERE hei.element_type_id = dhw.element_type_id

Line 2912: FROM hxt_sum_hours_worked shw

2908:
2909: CURSOR get_sum_time_out
2910: IS
2911: SELECT hours, time_in, time_out
2912: FROM hxt_sum_hours_worked shw
2913: WHERE ID = g_id
2914: AND not exists ( SELECT 'X' /* Bug: 4489952 *
2915: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw
2916: WHERE hei.element_type_id = dhw.element_type_id

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 2928: FROM hxt_sum_hours_worked shw

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
2929: WHERE shw.tim_id = p_tim_id
2930: AND shw.date_worked = p_date_worked
2931: AND (( shw.time_in IS NOT NULL
2932: AND shw.time_out IS NOT NULL

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 3166: FROM hxt_sum_hours_worked shw

3162:
3163: CURSOR get_sum_time_out
3164: IS
3165: SELECT hours, time_in, time_out
3166: FROM hxt_sum_hours_worked shw
3167: WHERE ID = g_id
3168: AND not exists ( SELECT 'X' /* Bug: 4489952 */
3169: FROM hxt_add_elem_info_f hei, hxt_det_hours_worked dhw
3170: 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 4039: hxt_sum_hours_worked shw --<-- New Table

4035: SELECT NVL (SUM (dhw.hours), 0) det_hours
4036: FROM hxt_pay_element_types_f_ddf_v eltv,
4037: pay_element_types_f elt,
4038: hxt_det_hours_worked dhw,
4039: hxt_sum_hours_worked shw --<-- New Table
4040: WHERE elt.element_type_id = dhw.element_type_id
4041: AND shw.ID = dhw.parent_id --<-- New Join
4042: AND shw.element_type_id IS NULL
4043: --<-- New check: No Hours Override

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 4381: FROM hxt_sum_hours_worked sm

4377: a_date_worked DATE
4378: )
4379: IS
4380: SELECT sm.date_worked
4381: FROM hxt_sum_hours_worked sm
4382: --Added this join to support the OTLR Recurring Preiod Preference
4383: , hxt_timecards tim
4384: --WHERE sm.tim_id = c_tim_id
4385:

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 4537: FROM hxt_sum_hours_worked sm, hxt_timecards tim

4533: a_date_worked DATE
4534: )
4535: IS
4536: SELECT sm.date_worked
4537: FROM hxt_sum_hours_worked sm, hxt_timecards tim
4538: WHERE tim.for_person_id = g_person_id
4539: AND sm.tim_id = tim.ID
4540: AND sm.hours > 0
4541: AND sm.date_worked = c_date_worked

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 4911: hxt_sum_hours_worked shr,

4907: hrw.job_id, hrw.state_name, hrw.county_name,
4908: hrw.city_name, hrw.zip_code
4909: FROM hxt_pay_element_types_f_ddf_v eltv,
4910: pay_element_types_f elt,
4911: hxt_sum_hours_worked shr,
4912: hxt_det_hours_worked hrw
4913: WHERE hrw.date_worked BETWEEN NEXT_DAY (a_date_worked - 7,
4914: start_day_of_week
4915: )

Line 4960: hxt_sum_hours_worked shr,

4956: hrw.effective_start_date, hrw.effective_end_date,
4957: hrw.job_id, hrw.state_name, hrw.county_name, hrw.city_name,
4958: hrw.zip_code
4959: FROM hxt_det_hours_worked hrw,
4960: hxt_sum_hours_worked shr,
4961: pay_element_types_f elt,
4962: hxt_pay_element_types_f_ddf_v eltv
4963: WHERE hrw.parent_id = c_parent_id
4964: AND hrw.element_type_id = elt.element_type_id

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 5226: hxt_sum_hours_worked shr,

5222: SELECT COUNT (*)
5223: INTO l_abs_count
5224: FROM hxt_pay_element_types_f_ddf_v eltv,
5225: pay_element_types_f elt,
5226: hxt_sum_hours_worked shr,
5227: hxt_timecards tim
5228: WHERE shr.date_worked BETWEEN NEXT_DAY (c_date_worked - 7,
5229: start_day_of_week
5230: )

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 15298: FROM hxt_sum_hours_worked hrw,

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,
15299: hxt_pay_element_types_f_ddf_v eltv,
15300: pay_element_types_f elt
15301: WHERE elt.element_type_id = hrw.element_type_id
15302: AND hrw.date_worked BETWEEN elt.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