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 PAY_ELEMENT_TYPES_F

Line 125: FROM hxt_pay_element_types_f_ddf_v eltv,

121: IS
122: SELECT hrw.ROWID prem_row_id, hrw.seqno, hrw.time_in prem_time_in,
123: hrw.time_out prem_time_out, hrw.hours prem_hours,
124: elt.element_name
125: FROM hxt_pay_element_types_f_ddf_v eltv,
126: pay_element_types_f elt,
127: hxt_det_hours_worked hrw
128: WHERE hrw.tim_id = a_tim_id
129: AND hrw.parent_id = a_parent_id

Line 126: pay_element_types_f elt,

122: SELECT hrw.ROWID prem_row_id, hrw.seqno, hrw.time_in prem_time_in,
123: hrw.time_out prem_time_out, hrw.hours prem_hours,
124: elt.element_name
125: FROM hxt_pay_element_types_f_ddf_v eltv,
126: pay_element_types_f elt,
127: hxt_det_hours_worked hrw
128: WHERE hrw.tim_id = a_tim_id
129: AND hrw.parent_id = a_parent_id
130: AND hrw.seqno > a_seqno

Line 139: FROM hxt_pay_element_types_f_ddf_v eltv2,

135: AND ( -- Be sure we stay with premiums for the detail record being
136: -- dealt with
137: (hrw.seqno <
138: (SELECT MIN (det.seqno)
139: FROM hxt_pay_element_types_f_ddf_v eltv2,
140: pay_element_types_f elt2,
141: hxt_det_hours_worked det
142: WHERE det.tim_id = a_tim_id
143: AND det.parent_id = a_parent_id

Line 140: pay_element_types_f elt2,

136: -- dealt with
137: (hrw.seqno <
138: (SELECT MIN (det.seqno)
139: FROM hxt_pay_element_types_f_ddf_v eltv2,
140: pay_element_types_f elt2,
141: hxt_det_hours_worked det
142: WHERE det.tim_id = a_tim_id
143: AND det.parent_id = a_parent_id
144: AND det.seqno > a_seqno

Line 158: FROM hxt_pay_element_types_f_ddf_v eltv2,

154:
155: -- detail records
156: (NOT EXISTS (
157: SELECT det.seqno
158: FROM hxt_pay_element_types_f_ddf_v eltv2,
159: pay_element_types_f elt2,
160: hxt_det_hours_worked det
161: WHERE det.tim_id = a_tim_id
162: AND det.parent_id = a_parent_id

Line 159: pay_element_types_f elt2,

155: -- detail records
156: (NOT EXISTS (
157: SELECT det.seqno
158: FROM hxt_pay_element_types_f_ddf_v eltv2,
159: pay_element_types_f elt2,
160: hxt_det_hours_worked det
161: WHERE det.tim_id = a_tim_id
162: AND det.parent_id = a_parent_id
163: AND det.seqno > a_seqno

Line 194: FROM hxt_pay_element_types_f_ddf_v eltv,

190: IS
191: SELECT hrw.ROWID prem_row_id, hrw.seqno, hrw.time_in prem_time_in,
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

Line 195: pay_element_types_f elt,

191: SELECT hrw.ROWID prem_row_id, hrw.seqno, hrw.time_in prem_time_in,
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

Line 206: FROM hxt_pay_element_types_f_ddf_v eltv2,

202: AND ( -- Be sure we stay with premiums for the detail record being
203: -- dealt with
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

Line 207: pay_element_types_f elt2,

203: -- dealt with
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

Line 225: FROM hxt_pay_element_types_f_ddf_v eltv2,

221: )
222: OR -- Proceed if no REG and OVT elements exist for other
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

Line 226: pay_element_types_f elt2,

222: OR -- Proceed if no REG and OVT elements exist for other
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

Line 862: FROM hxt_pay_element_types_f_ddf_v eltv,

858: /*
859: CURSOR weekly_total_to_date
860: IS
861: SELECT NVL (SUM (hrw.hours), 0)
862: FROM hxt_pay_element_types_f_ddf_v eltv,
863: pay_element_types_f elt,
864: hxt_earning_policies egp,
865: hxt_per_aei_ddf_v asmv,
866: per_assignments_f asm,

Line 863: pay_element_types_f elt,

859: CURSOR weekly_total_to_date
860: IS
861: SELECT NVL (SUM (hrw.hours), 0)
862: FROM hxt_pay_element_types_f_ddf_v eltv,
863: pay_element_types_f elt,
864: hxt_earning_policies egp,
865: hxt_per_aei_ddf_v asmv,
866: per_assignments_f asm,
867: hxt_det_hours_worked hrw,

Line 913: FROM hxt_pay_element_types_f_ddf_v eltv,

909: */
910: CURSOR weekly_total_to_date(session_date IN DATE)
911: IS
912: SELECT NVL (SUM (hrw.hours), 0)
913: FROM hxt_pay_element_types_f_ddf_v eltv,
914: pay_element_types_f elt,
915: hxt_earning_policies egp,
916: hxt_per_aei_ddf_v asmv,
917: per_assignments_f asm,

Line 914: pay_element_types_f elt,

910: CURSOR weekly_total_to_date(session_date IN DATE)
911: IS
912: SELECT NVL (SUM (hrw.hours), 0)
913: FROM hxt_pay_element_types_f_ddf_v eltv,
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,

Line 993: FROM hxt_pay_element_types_f_ddf_v eltv,

989: /*
990: CURSOR weekly_total_to_date
991: IS
992: SELECT NVL (SUM (hrw.hours), 0)
993: FROM hxt_pay_element_types_f_ddf_v eltv,
994: pay_element_types_f elt,
995: hxt_earn_groups erg,
996: hxt_earning_policies egp,
997: hxt_per_aei_ddf_v asmv,

Line 994: pay_element_types_f elt,

990: CURSOR weekly_total_to_date
991: IS
992: SELECT NVL (SUM (hrw.hours), 0)
993: FROM hxt_pay_element_types_f_ddf_v eltv,
994: pay_element_types_f elt,
995: hxt_earn_groups erg,
996: hxt_earning_policies egp,
997: hxt_per_aei_ddf_v asmv,
998: per_assignments_f asm,

Line 1033: FROM hxt_pay_element_types_f_ddf_v eltv,

1029:
1030: CURSOR weekly_total_to_date(session_date DATE)
1031: IS
1032: SELECT NVL (SUM (hrw.hours), 0)
1033: FROM hxt_pay_element_types_f_ddf_v eltv,
1034: pay_element_types_f elt,
1035: hxt_earn_groups erg,
1036: hxt_earning_policies egp,
1037: hxt_per_aei_ddf_v asmv,

Line 1034: pay_element_types_f elt,

1030: CURSOR weekly_total_to_date(session_date DATE)
1031: IS
1032: SELECT NVL (SUM (hrw.hours), 0)
1033: FROM hxt_pay_element_types_f_ddf_v eltv,
1034: pay_element_types_f elt,
1035: hxt_earn_groups erg,
1036: hxt_earning_policies egp,
1037: hxt_per_aei_ddf_v asmv,
1038: per_assignments_f asm,

Line 1105: FROM hxt_pay_element_types_f_ddf_v eltv,

1101: /*
1102: CURSOR daily_total
1103: IS
1104: SELECT NVL (SUM (hrw.hours), 0)
1105: FROM hxt_pay_element_types_f_ddf_v eltv,
1106: pay_element_types_f elt,
1107: hxt_earning_policies egp,
1108: hxt_per_aei_ddf_v asmv,
1109: per_assignments_f asm,

Line 1106: pay_element_types_f elt,

1102: CURSOR daily_total
1103: IS
1104: SELECT NVL (SUM (hrw.hours), 0)
1105: FROM hxt_pay_element_types_f_ddf_v eltv,
1106: pay_element_types_f elt,
1107: hxt_earning_policies egp,
1108: hxt_per_aei_ddf_v asmv,
1109: per_assignments_f asm,
1110: hxt_det_hours_worked hrw,

Line 1155: FROM hxt_pay_element_types_f_ddf_v eltv,

1151:
1152: CURSOR daily_total(session_date DATE)
1153: IS
1154: SELECT NVL (SUM (hrw.hours), 0)
1155: FROM hxt_pay_element_types_f_ddf_v eltv,
1156: pay_element_types_f elt,
1157: hxt_earning_policies egp,
1158: hxt_per_aei_ddf_v asmv,
1159: per_assignments_f asm,

Line 1156: pay_element_types_f elt,

1152: CURSOR daily_total(session_date DATE)
1153: IS
1154: SELECT NVL (SUM (hrw.hours), 0)
1155: FROM hxt_pay_element_types_f_ddf_v eltv,
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,

Line 1287: -- FROM pay_element_types_f_dfv eltv,

1283: /*
1284: CURSOR overtime_cur
1285: IS
1286: SELECT hrw.ROWID hrw_rowid, hrw.hours
1287: -- FROM pay_element_types_f_dfv eltv,
1288: FROM hxt_pay_element_types_f_ddf_v eltv,
1289: pay_element_types_f elt,
1290: hxt_det_hours_worked hrw, --C421
1291: hxt_timecards tim

Line 1288: FROM hxt_pay_element_types_f_ddf_v eltv,

1284: CURSOR overtime_cur
1285: IS
1286: SELECT hrw.ROWID hrw_rowid, hrw.hours
1287: -- FROM pay_element_types_f_dfv eltv,
1288: FROM hxt_pay_element_types_f_ddf_v eltv,
1289: pay_element_types_f elt,
1290: hxt_det_hours_worked hrw, --C421
1291: hxt_timecards tim
1292: WHERE hrw.date_worked = g_date_worked

Line 1289: pay_element_types_f elt,

1285: IS
1286: SELECT hrw.ROWID hrw_rowid, hrw.hours
1287: -- FROM pay_element_types_f_dfv eltv,
1288: FROM hxt_pay_element_types_f_ddf_v eltv,
1289: pay_element_types_f elt,
1290: hxt_det_hours_worked hrw, --C421
1291: hxt_timecards tim
1292: WHERE hrw.date_worked = g_date_worked
1293: AND tim_id = g_tim_id

Line 1307: FROM hxt_pay_element_types_f_ddf_v eltv,

1303:
1304: CURSOR overtime_cur(session_date DATE)
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

Line 1308: pay_element_types_f elt,

1304: CURSOR overtime_cur(session_date DATE)
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

Line 1473: FROM hxt_pay_element_types_f_ddf_v eltv,

1469: /*
1470: CURSOR weekly_total_to_date
1471: IS
1472: SELECT NVL (SUM (hrw.hours), 0)
1473: FROM hxt_pay_element_types_f_ddf_v eltv,
1474: pay_element_types_f elt,
1475: hxt_earning_policies egp,
1476: hxt_per_aei_ddf_v asmv,
1477: per_assignments_f asm,

Line 1474: pay_element_types_f elt,

1470: CURSOR weekly_total_to_date
1471: IS
1472: SELECT NVL (SUM (hrw.hours), 0)
1473: FROM hxt_pay_element_types_f_ddf_v eltv,
1474: pay_element_types_f elt,
1475: hxt_earning_policies egp,
1476: hxt_per_aei_ddf_v asmv,
1477: per_assignments_f asm,
1478: hxt_det_hours_worked hrw,

Line 1522: FROM hxt_pay_element_types_f_ddf_v eltv,

1518:
1519: CURSOR weekly_total_to_date(session_date DATE)
1520: IS
1521: SELECT NVL (SUM (hrw.hours), 0)
1522: FROM hxt_pay_element_types_f_ddf_v eltv,
1523: pay_element_types_f elt,
1524: hxt_earning_policies egp,
1525: hxt_per_aei_ddf_v asmv,
1526: per_assignments_f asm,

Line 1523: pay_element_types_f elt,

1519: CURSOR weekly_total_to_date(session_date DATE)
1520: IS
1521: SELECT NVL (SUM (hrw.hours), 0)
1522: FROM hxt_pay_element_types_f_ddf_v eltv,
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,

Line 1734: FROM hxt_pay_element_types_f_ddf_v eltv,

1730: session_date DATE)
1731: IS
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

Line 1735: pay_element_types_f elt,

1731: IS
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

Line 1988: FROM hxt_pay_element_types_f_ddf_v eltv

1984:
1985: CURSOR prem_amount_cur (c_date_worked DATE, c_elem NUMBER)
1986: IS
1987: SELECT NVL (hxt_premium_amount, 0)
1988: FROM hxt_pay_element_types_f_ddf_v eltv
1989: WHERE c_date_worked BETWEEN eltv.effective_start_date
1990: AND eltv.effective_end_date
1991: AND eltv.element_type_id = c_elem;
1992:

Line 2369: FROM hxt_shift_diff_rules sdr, pay_element_types_f elt

2365: CURSOR sdp_rule_cursor
2366: IS
2367: SELECT sdr.start_time, sdr.stop_time, sdr.carryover_time,
2368: elt.element_name
2369: FROM hxt_shift_diff_rules sdr, pay_element_types_f elt
2370: WHERE sdr.sdp_id = g_sdp_id
2371: AND sdr.element_type_id = elt.element_type_id
2372: AND trunc(p_sum_time_in) BETWEEN elt.effective_start_date
2373: AND elt.effective_end_date;

Line 2519: FROM hxt_pay_element_types_f_ddf_v eltv,

2515: dhw.time_out,
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

Line 2736: FROM hxt_pay_element_types_f_ddf_v eltv,

2732: CURSOR current_dtl
2733: IS
2734: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
2735: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
2736: FROM hxt_pay_element_types_f_ddf_v eltv,
2737: pay_element_types_f elt,
2738: hxt_det_hours_worked dhw
2739: WHERE dhw.tim_id = g_tim_id
2740: AND dhw.date_worked = g_date_worked

Line 2737: pay_element_types_f elt,

2733: IS
2734: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
2735: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
2736: FROM hxt_pay_element_types_f_ddf_v eltv,
2737: pay_element_types_f elt,
2738: hxt_det_hours_worked dhw
2739: WHERE dhw.tim_id = g_tim_id
2740: AND dhw.date_worked = g_date_worked
2741: AND elt.element_type_id = dhw.element_type_id

Line 2758: FROM hxt_pay_element_types_f_ddf_v eltv,

2754: CURSOR day_of_wk_prem_dtl
2755: IS
2756: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
2757: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
2758: FROM hxt_pay_element_types_f_ddf_v eltv,
2759: pay_element_types_f elt,
2760: hxt_det_hours_worked dhw
2761: WHERE dhw.tim_id = g_tim_id
2762: AND dhw.parent_id = g_id

Line 2759: pay_element_types_f elt,

2755: IS
2756: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
2757: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
2758: FROM hxt_pay_element_types_f_ddf_v eltv,
2759: pay_element_types_f elt,
2760: hxt_det_hours_worked dhw
2761: WHERE dhw.tim_id = g_tim_id
2762: AND dhw.parent_id = g_id
2763: AND dhw.date_worked = g_date_worked

Line 2783: FROM hxt_pay_element_types_f_ddf_v eltv,

2779: CURSOR oth_prem_dtl -- Bug 5447600
2780: IS
2781: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
2782: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
2783: FROM hxt_pay_element_types_f_ddf_v eltv,
2784: pay_element_types_f elt,
2785: hxt_det_hours_worked dhw
2786: WHERE dhw.parent_id = g_id
2787: AND dhw.element_type_id = elt.element_type_id

Line 2784: pay_element_types_f elt,

2780: IS
2781: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
2782: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
2783: FROM hxt_pay_element_types_f_ddf_v eltv,
2784: pay_element_types_f elt,
2785: hxt_det_hours_worked dhw
2786: WHERE dhw.parent_id = g_id
2787: AND dhw.element_type_id = elt.element_type_id
2788: AND dhw.date_worked BETWEEN elt.effective_start_date

Line 2806: FROM hxt_pay_element_types_f_ddf_v eltv,

2802:
2803: CURSOR sdf_prem_detail_hours
2804: IS
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

Line 2807: pay_element_types_f elt,

2803: CURSOR sdf_prem_detail_hours
2804: IS
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

Line 2827: FROM hxt_pay_element_types_f_ddf_v eltv,

2823:
2824: CURSOR oth_prem_detail_hours -- Bug 5447600
2825: IS
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

Line 2828: pay_element_types_f elt,

2824: CURSOR oth_prem_detail_hours -- Bug 5447600
2825: IS
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

Line 2856: FROM hxt_pay_element_types_f_ddf_v eltv,

2852:
2853: CURSOR detail_hours_today
2854: IS
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

Line 2857: pay_element_types_f elt,

2853: CURSOR detail_hours_today
2854: IS
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

Line 2877: FROM hxt_pay_element_types_f_ddf_v eltv,

2873:
2874: CURSOR detail_hours_incl_prev_rows
2875: IS
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

Line 2878: pay_element_types_f elt,

2874: CURSOR detail_hours_incl_prev_rows
2875: IS
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

Line 2959: FROM hxt_pay_element_types_f_ddf_v eltv,

2955: CURSOR current_dtl
2956: IS
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

Line 2960: pay_element_types_f elt,

2956: IS
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

Line 2988: FROM hxt_pay_element_types_f_ddf_v eltv,

2984: CURSOR day_of_wk_prem_dtl
2985: IS
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

Line 2989: pay_element_types_f elt,

2985: IS
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

Line 3015: FROM hxt_pay_element_types_f_ddf_v eltv,

3011: CURSOR oth_prem_dtl -- Bug 5447600
3012: IS
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

Line 3016: pay_element_types_f elt,

3012: IS
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

Line 3040: FROM hxt_pay_element_types_f_ddf_v eltv,

3036:
3037: CURSOR sdf_prem_detail_hours
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

Line 3041: pay_element_types_f elt,

3037: CURSOR sdf_prem_detail_hours
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

Line 3065: FROM hxt_pay_element_types_f_ddf_v eltv,

3061:
3062: CURSOR oth_prem_detail_hours -- Bug 5447600
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

Line 3066: pay_element_types_f elt,

3062: CURSOR oth_prem_detail_hours -- Bug 5447600
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

Line 3098: FROM hxt_pay_element_types_f_ddf_v eltv,

3094:
3095: CURSOR detail_hours_today
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

Line 3099: pay_element_types_f elt,

3095: CURSOR detail_hours_today
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

Line 3123: FROM hxt_pay_element_types_f_ddf_v eltv,

3119:
3120: CURSOR detail_hours_incl_prev_rows
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

Line 3124: pay_element_types_f elt,

3120: CURSOR detail_hours_incl_prev_rows
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

Line 4036: FROM hxt_pay_element_types_f_ddf_v eltv,

4032: /*
4033: CURSOR detail_hours_today
4034: IS
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

Line 4037: pay_element_types_f elt,

4033: CURSOR detail_hours_today
4034: IS
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

Line 4058: FROM hxt_pay_element_types_f_ddf_v eltv,

4054:
4055: CURSOR detail_hours_today
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

Line 4059: pay_element_types_f elt,

4055: CURSOR detail_hours_today
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

Line 4909: FROM hxt_pay_element_types_f_ddf_v eltv,

4905: hrw.last_update_date, hrw.last_update_login,
4906: hrw.effective_start_date, hrw.effective_end_date,
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,

Line 4910: pay_element_types_f elt,

4906: hrw.effective_start_date, hrw.effective_end_date,
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

Line 4933: pay_element_types_f elt,

4929: CURSOR clear_reg_detail_rec (c_parent_id NUMBER)
4930: IS
4931: SELECT hrw.ROWID
4932: FROM hxt_det_hours_worked hrw,
4933: pay_element_types_f elt,
4934: hxt_pay_element_types_f_ddf_v eltv
4935: WHERE hrw.parent_id = c_parent_id
4936: AND hrw.element_type_id = elt.element_type_id
4937: AND hrw.date_worked BETWEEN elt.effective_start_date

Line 4934: hxt_pay_element_types_f_ddf_v eltv

4930: IS
4931: SELECT hrw.ROWID
4932: FROM hxt_det_hours_worked hrw,
4933: pay_element_types_f elt,
4934: hxt_pay_element_types_f_ddf_v eltv
4935: WHERE hrw.parent_id = c_parent_id
4936: AND hrw.element_type_id = elt.element_type_id
4937: AND hrw.date_worked BETWEEN elt.effective_start_date
4938: AND elt.effective_end_date

Line 4961: pay_element_types_f elt,

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
4965: AND hrw.date_worked BETWEEN elt.effective_start_date

Line 4962: hxt_pay_element_types_f_ddf_v eltv

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
4965: AND hrw.date_worked BETWEEN elt.effective_start_date
4966: AND elt.effective_end_date

Line 4997: FROM hxt_pay_element_types_f_ddf_v eltv,

4993: hrw.city_name, hrw.zip_code,
4994: shr.hourly_rate sum_hourly_rate,
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,

Line 4998: pay_element_types_f elt,

4994: shr.hourly_rate sum_hourly_rate,
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

Line 5025: pay_element_types_f elt,

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
5029: AND session_date BETWEEN hrw.effective_start_date

Line 5026: hxt_pay_element_types_f_ddf_v eltv

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
5029: AND session_date BETWEEN hrw.effective_start_date
5030: AND hrw.effective_end_date

Line 5062: pay_element_types_f elt,

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
5066: AND session_date BETWEEN hrw.effective_start_date

Line 5063: hxt_pay_element_types_f_ddf_v eltv

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
5066: AND session_date BETWEEN hrw.effective_start_date
5067: AND hrw.effective_end_date

Line 5224: FROM hxt_pay_element_types_f_ddf_v eltv,

5220:
5221: /*
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,

Line 5225: pay_element_types_f elt,

5221: /*
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

Line 5245: FROM hxt_pay_element_types_f_ddf_v eltv,

5241: */
5242:
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,

Line 5246: pay_element_types_f elt,

5242:
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

Line 8029: FROM hxt_pay_element_types_f_ddf_v eltv,

8025: /*
8026: CURSOR weekly_earn_category_total --(cp_earning_category VARCHAR2) BUG 5499459
8027: IS
8028: SELECT NVL (SUM (hrw.hours), 0)
8029: FROM hxt_pay_element_types_f_ddf_v eltv,
8030: pay_element_types_f elt2,
8031: hxt_det_hours_worked hrw,
8032: hxt_timecards tim,
8033: hxt_earn_groups erg,

Line 8030: pay_element_types_f elt2,

8026: CURSOR weekly_earn_category_total --(cp_earning_category VARCHAR2) BUG 5499459
8027: IS
8028: SELECT NVL (SUM (hrw.hours), 0)
8029: FROM hxt_pay_element_types_f_ddf_v eltv,
8030: pay_element_types_f elt2,
8031: hxt_det_hours_worked hrw,
8032: hxt_timecards tim,
8033: hxt_earn_groups erg,
8034: hxt_earn_group_types egt,

Line 8060: FROM hxt_pay_element_types_f_ddf_v eltv,

8056:
8057: CURSOR weekly_earn_category_total --(cp_earning_category VARCHAR2) BUG 5499459
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,

Line 8061: pay_element_types_f elt2,

8057: CURSOR weekly_earn_category_total --(cp_earning_category VARCHAR2) BUG 5499459
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,

Line 8165: l_dy_wk_reg_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,

8161: l_use_weekly_reg IN VARCHAR2,
8162: l_use_weekly_ot IN VARCHAR2,
8163: l_use_weekly_dt IN VARCHAR2,
8164: l_weekly_reg_cap IN NUMBER,
8165: l_dy_wk_reg_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
8166: l_dy_wk_ovt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
8167: l_dy_wk_dt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
8168: l_use_daily_reg OUT NOCOPY VARCHAR2,
8169: l_use_daily_ot OUT NOCOPY VARCHAR2,

Line 8166: l_dy_wk_ovt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,

8162: l_use_weekly_ot IN VARCHAR2,
8163: l_use_weekly_dt IN VARCHAR2,
8164: l_weekly_reg_cap IN NUMBER,
8165: l_dy_wk_reg_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
8166: l_dy_wk_ovt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
8167: l_dy_wk_dt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
8168: l_use_daily_reg OUT NOCOPY VARCHAR2,
8169: l_use_daily_ot OUT NOCOPY VARCHAR2,
8170: l_use_daily_dt OUT NOCOPY VARCHAR2,

Line 8167: l_dy_wk_dt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,

8163: l_use_weekly_dt IN VARCHAR2,
8164: l_weekly_reg_cap IN NUMBER,
8165: l_dy_wk_reg_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
8166: l_dy_wk_ovt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
8167: l_dy_wk_dt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
8168: l_use_daily_reg OUT NOCOPY VARCHAR2,
8169: l_use_daily_ot OUT NOCOPY VARCHAR2,
8170: l_use_daily_dt OUT NOCOPY VARCHAR2,
8171: l_reg_for_day OUT NOCOPY NUMBER,

Line 11860: hxt_pay_element_types_f_ddf_v elem

11856: p_date IN DATE)
11857: IS SELECT DISTINCT
11858: er.element_type_id
11859: FROM hxt_earning_rules er,
11860: hxt_pay_element_types_f_ddf_v elem
11861: WHERE er.egp_id = p_ep_id
11862: AND p_date BETWEEN er.effective_start_date
11863: AND er.effective_end_date
11864: AND elem.element_type_id = er.element_type_id

Line 13866: FROM hxt_pay_element_types_f_ddf_v eltv,

13862: SELECT dhw.ROWID dhw_rowid, dhw.ID, dhw.parent_id, dhw.tim_id,
13863: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno,
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

Line 13867: pay_element_types_f elt,

13863: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno,
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

Line 15081: hxt_pay_element_types_f_ddf_v eltv,

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
15085: AND elt.effective_end_date

Line 15082: pay_element_types_f elt

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
15085: AND elt.effective_end_date
15086: AND session_date BETWEEN hrw.effective_start_date

Line 15213: hxt_pay_element_types_f_ddf_v eltv,

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

Line 15214: pay_element_types_f elt,

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

Line 15299: hxt_pay_element_types_f_ddf_v eltv,

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
15303: AND elt.effective_end_date

Line 15300: pay_element_types_f elt

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
15303: AND elt.effective_end_date
15304: AND eltv.element_type_id = elt.element_type_id

Line 15328: hxt_pay_element_types_f_ddf_v eltv,

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
15332: AND elt.effective_end_date

Line 15329: pay_element_types_f elt

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
15332: AND elt.effective_end_date
15333: AND p_session_date BETWEEN hrw.effective_start_date