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 110: FROM hxt_pay_element_types_f_ddf_v eltv,

106: IS
107: SELECT hrw.ROWID prem_row_id, hrw.seqno, hrw.time_in prem_time_in,
108: hrw.time_out prem_time_out, hrw.hours prem_hours,
109: elt.element_name
110: FROM hxt_pay_element_types_f_ddf_v eltv,
111: pay_element_types_f elt,
112: hxt_det_hours_worked hrw
113: WHERE hrw.tim_id = a_tim_id
114: AND hrw.parent_id = a_parent_id

Line 111: pay_element_types_f elt,

107: SELECT hrw.ROWID prem_row_id, hrw.seqno, hrw.time_in prem_time_in,
108: hrw.time_out prem_time_out, hrw.hours prem_hours,
109: elt.element_name
110: FROM hxt_pay_element_types_f_ddf_v eltv,
111: pay_element_types_f elt,
112: hxt_det_hours_worked hrw
113: WHERE hrw.tim_id = a_tim_id
114: AND hrw.parent_id = a_parent_id
115: AND hrw.seqno > a_seqno

Line 124: FROM hxt_pay_element_types_f_ddf_v eltv2,

120: AND ( -- Be sure we stay with premiums for the detail record being
121: -- dealt with
122: (hrw.seqno <
123: (SELECT MIN (det.seqno)
124: FROM hxt_pay_element_types_f_ddf_v eltv2,
125: pay_element_types_f elt2,
126: hxt_det_hours_worked det
127: WHERE det.tim_id = a_tim_id
128: AND det.parent_id = a_parent_id

Line 125: pay_element_types_f elt2,

121: -- dealt with
122: (hrw.seqno <
123: (SELECT MIN (det.seqno)
124: FROM hxt_pay_element_types_f_ddf_v eltv2,
125: pay_element_types_f elt2,
126: hxt_det_hours_worked det
127: WHERE det.tim_id = a_tim_id
128: AND det.parent_id = a_parent_id
129: AND det.seqno > a_seqno

Line 143: FROM hxt_pay_element_types_f_ddf_v eltv2,

139:
140: -- detail records
141: (NOT EXISTS (
142: SELECT det.seqno
143: FROM hxt_pay_element_types_f_ddf_v eltv2,
144: pay_element_types_f elt2,
145: hxt_det_hours_worked det
146: WHERE det.tim_id = a_tim_id
147: AND det.parent_id = a_parent_id

Line 144: pay_element_types_f elt2,

140: -- detail records
141: (NOT EXISTS (
142: SELECT det.seqno
143: FROM hxt_pay_element_types_f_ddf_v eltv2,
144: pay_element_types_f elt2,
145: hxt_det_hours_worked det
146: WHERE det.tim_id = a_tim_id
147: AND det.parent_id = a_parent_id
148: AND det.seqno > a_seqno

Line 738: FROM hxt_pay_element_types_f_ddf_v eltv,

734: IS
735: CURSOR weekly_total_to_date
736: IS
737: SELECT NVL (SUM (hrw.hours), 0)
738: FROM hxt_pay_element_types_f_ddf_v eltv,
739: pay_element_types_f elt,
740: hxt_earning_policies egp,
741: hxt_per_aei_ddf_v asmv,
742: per_assignments_f asm,

Line 739: pay_element_types_f elt,

735: CURSOR weekly_total_to_date
736: IS
737: SELECT NVL (SUM (hrw.hours), 0)
738: FROM hxt_pay_element_types_f_ddf_v eltv,
739: pay_element_types_f elt,
740: hxt_earning_policies egp,
741: hxt_per_aei_ddf_v asmv,
742: per_assignments_f asm,
743: hxt_det_hours_worked hrw,

Line 806: FROM hxt_pay_element_types_f_ddf_v eltv,

802: IS
803: CURSOR weekly_total_to_date
804: IS
805: SELECT NVL (SUM (hrw.hours), 0)
806: FROM hxt_pay_element_types_f_ddf_v eltv,
807: pay_element_types_f elt,
808: hxt_earn_groups erg,
809: hxt_earning_policies egp,
810: hxt_per_aei_ddf_v asmv,

Line 807: pay_element_types_f elt,

803: CURSOR weekly_total_to_date
804: IS
805: SELECT NVL (SUM (hrw.hours), 0)
806: FROM hxt_pay_element_types_f_ddf_v eltv,
807: pay_element_types_f elt,
808: hxt_earn_groups erg,
809: hxt_earning_policies egp,
810: hxt_per_aei_ddf_v asmv,
811: per_assignments_f asm,

Line 860: FROM hxt_pay_element_types_f_ddf_v eltv,

856: IS
857: CURSOR daily_total
858: IS
859: SELECT NVL (SUM (hrw.hours), 0)
860: FROM hxt_pay_element_types_f_ddf_v eltv,
861: pay_element_types_f elt,
862: hxt_earning_policies egp,
863: hxt_per_aei_ddf_v asmv,
864: per_assignments_f asm,

Line 861: pay_element_types_f elt,

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

Line 938: -- FROM pay_element_types_f_dfv eltv,

934: IS
935: CURSOR overtime_cur
936: IS
937: SELECT hrw.ROWID hrw_rowid, hrw.hours
938: -- FROM pay_element_types_f_dfv eltv,
939: FROM hxt_pay_element_types_f_ddf_v eltv,
940: pay_element_types_f elt,
941: hxt_det_hours_worked hrw, --C421
942: hxt_timecards tim

Line 939: FROM hxt_pay_element_types_f_ddf_v eltv,

935: CURSOR overtime_cur
936: IS
937: SELECT hrw.ROWID hrw_rowid, hrw.hours
938: -- FROM pay_element_types_f_dfv eltv,
939: FROM hxt_pay_element_types_f_ddf_v eltv,
940: pay_element_types_f elt,
941: hxt_det_hours_worked hrw, --C421
942: hxt_timecards tim
943: WHERE hrw.date_worked = g_date_worked

Line 940: pay_element_types_f elt,

936: IS
937: SELECT hrw.ROWID hrw_rowid, hrw.hours
938: -- FROM pay_element_types_f_dfv eltv,
939: FROM hxt_pay_element_types_f_ddf_v eltv,
940: pay_element_types_f elt,
941: hxt_det_hours_worked hrw, --C421
942: hxt_timecards tim
943: WHERE hrw.date_worked = g_date_worked
944: AND tim_id = g_tim_id

Line 1089: FROM hxt_pay_element_types_f_ddf_v eltv,

1085: IS
1086: CURSOR weekly_total_to_date
1087: IS
1088: SELECT NVL (SUM (hrw.hours), 0)
1089: FROM hxt_pay_element_types_f_ddf_v eltv,
1090: pay_element_types_f elt,
1091: hxt_earning_policies egp,
1092: hxt_per_aei_ddf_v asmv,
1093: per_assignments_f asm,

Line 1090: pay_element_types_f elt,

1086: CURSOR weekly_total_to_date
1087: IS
1088: SELECT NVL (SUM (hrw.hours), 0)
1089: FROM hxt_pay_element_types_f_ddf_v eltv,
1090: pay_element_types_f elt,
1091: hxt_earning_policies egp,
1092: hxt_per_aei_ddf_v asmv,
1093: per_assignments_f asm,
1094: hxt_det_hours_worked hrw,

Line 1289: FROM hxt_pay_element_types_f_ddf_v eltv,

1285: CURSOR current_dtl (c_hours_short NUMBER)
1286: IS
1287: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
1288: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
1289: FROM hxt_pay_element_types_f_ddf_v eltv,
1290: pay_element_types_f elt,
1291: hxt_det_hours_worked dhw
1292: WHERE dhw.tim_id = g_tim_id
1293: AND dhw.date_worked = g_date_worked

Line 1290: pay_element_types_f elt,

1286: IS
1287: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
1288: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
1289: FROM hxt_pay_element_types_f_ddf_v eltv,
1290: pay_element_types_f elt,
1291: hxt_det_hours_worked dhw
1292: WHERE dhw.tim_id = g_tim_id
1293: AND dhw.date_worked = g_date_worked
1294: AND dhw.hours > c_hours_short

Line 1454: FROM hxt_pay_element_types_f_ddf_v eltv

1450:
1451: CURSOR prem_amount_cur (c_date_worked DATE, c_elem NUMBER)
1452: IS
1453: SELECT NVL (hxt_premium_amount, 0)
1454: FROM hxt_pay_element_types_f_ddf_v eltv
1455: WHERE c_date_worked BETWEEN eltv.effective_start_date
1456: AND eltv.effective_end_date
1457: AND eltv.element_type_id = c_elem;
1458:

Line 1823: FROM hxt_shift_diff_rules sdr, pay_element_types_f elt

1819: CURSOR sdp_rule_cursor
1820: IS
1821: SELECT sdr.start_time, sdr.stop_time, sdr.carryover_time,
1822: elt.element_name
1823: FROM hxt_shift_diff_rules sdr, pay_element_types_f elt
1824: WHERE sdr.sdp_id = g_sdp_id
1825: AND sdr.element_type_id = elt.element_type_id
1826: AND trunc(p_sum_time_in) BETWEEN elt.effective_start_date
1827: AND elt.effective_end_date;

Line 1920: FROM hxt_pay_element_types_f_ddf_v eltv,

1916: CURSOR current_dtl
1917: IS
1918: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
1919: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
1920: FROM hxt_pay_element_types_f_ddf_v eltv,
1921: pay_element_types_f elt,
1922: hxt_det_hours_worked dhw
1923: WHERE dhw.tim_id = g_tim_id
1924: AND dhw.date_worked = g_date_worked

Line 1921: pay_element_types_f elt,

1917: IS
1918: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
1919: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
1920: FROM hxt_pay_element_types_f_ddf_v eltv,
1921: pay_element_types_f elt,
1922: hxt_det_hours_worked dhw
1923: WHERE dhw.tim_id = g_tim_id
1924: AND dhw.date_worked = g_date_worked
1925: AND elt.element_type_id = dhw.element_type_id

Line 1942: FROM hxt_pay_element_types_f_ddf_v eltv,

1938: CURSOR day_of_wk_prem_dtl
1939: IS
1940: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
1941: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
1942: FROM hxt_pay_element_types_f_ddf_v eltv,
1943: pay_element_types_f elt,
1944: hxt_det_hours_worked dhw
1945: WHERE dhw.tim_id = g_tim_id
1946: AND dhw.parent_id = g_id

Line 1943: pay_element_types_f elt,

1939: IS
1940: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
1941: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
1942: FROM hxt_pay_element_types_f_ddf_v eltv,
1943: pay_element_types_f elt,
1944: hxt_det_hours_worked dhw
1945: WHERE dhw.tim_id = g_tim_id
1946: AND dhw.parent_id = g_id
1947: AND dhw.date_worked = g_date_worked

Line 1967: FROM hxt_pay_element_types_f_ddf_v eltv,

1963: CURSOR oth_prem_dtl -- Bug 5447600
1964: IS
1965: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
1966: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
1967: FROM hxt_pay_element_types_f_ddf_v eltv,
1968: pay_element_types_f elt,
1969: hxt_det_hours_worked dhw
1970: WHERE dhw.parent_id = g_id
1971: AND dhw.element_type_id = elt.element_type_id

Line 1968: pay_element_types_f elt,

1964: IS
1965: SELECT dhw.ROWID dhw_rowid, dhw.parent_id, dhw.tim_id,
1966: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno
1967: FROM hxt_pay_element_types_f_ddf_v eltv,
1968: pay_element_types_f elt,
1969: hxt_det_hours_worked dhw
1970: WHERE dhw.parent_id = g_id
1971: AND dhw.element_type_id = elt.element_type_id
1972: AND dhw.date_worked BETWEEN elt.effective_start_date

Line 1990: FROM hxt_pay_element_types_f_ddf_v eltv,

1986:
1987: CURSOR sdf_prem_detail_hours
1988: IS
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

Line 1991: pay_element_types_f elt,

1987: CURSOR sdf_prem_detail_hours
1988: IS
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

Line 2011: FROM hxt_pay_element_types_f_ddf_v eltv,

2007:
2008: CURSOR oth_prem_detail_hours -- Bug 5447600
2009: IS
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

Line 2012: pay_element_types_f elt,

2008: CURSOR oth_prem_detail_hours -- Bug 5447600
2009: IS
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

Line 2040: FROM hxt_pay_element_types_f_ddf_v eltv,

2036:
2037: CURSOR detail_hours_today
2038: IS
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

Line 2041: pay_element_types_f elt,

2037: CURSOR detail_hours_today
2038: IS
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

Line 2061: FROM hxt_pay_element_types_f_ddf_v eltv,

2057:
2058: CURSOR detail_hours_incl_prev_rows
2059: IS
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

Line 2062: pay_element_types_f elt,

2058: CURSOR detail_hours_incl_prev_rows
2059: IS
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

Line 2873: FROM hxt_pay_element_types_f_ddf_v eltv,

2869:
2870: CURSOR detail_hours_today
2871: IS
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

Line 2874: pay_element_types_f elt,

2870: CURSOR detail_hours_today
2871: IS
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

Line 3619: FROM hxt_pay_element_types_f_ddf_v eltv,

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

Line 3620: pay_element_types_f elt,

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

Line 3643: pay_element_types_f elt,

3639: CURSOR clear_reg_detail_rec (c_parent_id NUMBER)
3640: IS
3641: SELECT hrw.ROWID
3642: FROM hxt_det_hours_worked hrw,
3643: pay_element_types_f elt,
3644: hxt_pay_element_types_f_ddf_v eltv
3645: WHERE hrw.parent_id = c_parent_id
3646: AND hrw.element_type_id = elt.element_type_id
3647: AND hrw.date_worked BETWEEN elt.effective_start_date

Line 3644: hxt_pay_element_types_f_ddf_v eltv

3640: IS
3641: SELECT hrw.ROWID
3642: FROM hxt_det_hours_worked hrw,
3643: pay_element_types_f elt,
3644: hxt_pay_element_types_f_ddf_v eltv
3645: WHERE hrw.parent_id = c_parent_id
3646: AND hrw.element_type_id = elt.element_type_id
3647: AND hrw.date_worked BETWEEN elt.effective_start_date
3648: AND elt.effective_end_date

Line 3671: pay_element_types_f elt,

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

Line 3672: hxt_pay_element_types_f_ddf_v eltv

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

Line 3802: FROM hxt_pay_element_types_f_ddf_v eltv,

3798: END IF;
3799:
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,

Line 3803: pay_element_types_f elt,

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

Line 6445: FROM hxt_pay_element_types_f_ddf_v eltv,

6441:
6442: CURSOR weekly_earn_category_total --(cp_earning_category VARCHAR2) BUG 5499459
6443: IS
6444: SELECT NVL (SUM (hrw.hours), 0)
6445: FROM hxt_pay_element_types_f_ddf_v eltv,
6446: pay_element_types_f elt2,
6447: hxt_det_hours_worked hrw,
6448: hxt_timecards tim,
6449: hxt_earn_groups erg,

Line 6446: pay_element_types_f elt2,

6442: CURSOR weekly_earn_category_total --(cp_earning_category VARCHAR2) BUG 5499459
6443: IS
6444: SELECT NVL (SUM (hrw.hours), 0)
6445: FROM hxt_pay_element_types_f_ddf_v eltv,
6446: pay_element_types_f elt2,
6447: hxt_det_hours_worked hrw,
6448: hxt_timecards tim,
6449: hxt_earn_groups erg,
6450: hxt_earn_group_types egt,

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

6541: l_use_weekly_reg IN VARCHAR2,
6542: l_use_weekly_ot IN VARCHAR2,
6543: l_use_weekly_dt IN VARCHAR2,
6544: l_weekly_reg_cap IN NUMBER,
6545: l_dy_wk_reg_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
6546: l_dy_wk_ovt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
6547: l_dy_wk_dt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
6548: l_use_daily_reg OUT NOCOPY VARCHAR2,
6549: l_use_daily_ot OUT NOCOPY VARCHAR2,

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

6542: l_use_weekly_ot IN VARCHAR2,
6543: l_use_weekly_dt IN VARCHAR2,
6544: l_weekly_reg_cap IN NUMBER,
6545: l_dy_wk_reg_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
6546: l_dy_wk_ovt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
6547: l_dy_wk_dt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
6548: l_use_daily_reg OUT NOCOPY VARCHAR2,
6549: l_use_daily_ot OUT NOCOPY VARCHAR2,
6550: l_use_daily_dt OUT NOCOPY VARCHAR2,

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

6543: l_use_weekly_dt IN VARCHAR2,
6544: l_weekly_reg_cap IN NUMBER,
6545: l_dy_wk_reg_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
6546: l_dy_wk_ovt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
6547: l_dy_wk_dt_elem_id OUT NOCOPY pay_element_types_f.element_type_id%TYPE,
6548: l_use_daily_reg OUT NOCOPY VARCHAR2,
6549: l_use_daily_ot OUT NOCOPY VARCHAR2,
6550: l_use_daily_dt OUT NOCOPY VARCHAR2,
6551: l_reg_for_day OUT NOCOPY NUMBER,

Line 12069: FROM hxt_pay_element_types_f_ddf_v eltv,

12065: SELECT dhw.ROWID dhw_rowid, dhw.ID, dhw.parent_id, dhw.tim_id,
12066: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno,
12067: eltv.hxt_premium_amount, eltv.hxt_earning_category,
12068: dhw.element_type_id
12069: FROM hxt_pay_element_types_f_ddf_v eltv,
12070: pay_element_types_f elt,
12071: hxt_det_hours_worked_f dhw
12072: WHERE dhw.tim_id = c_tim_id
12073: AND dhw.date_worked = c_date_worked

Line 12070: pay_element_types_f elt,

12066: dhw.hours, dhw.time_in, dhw.time_out, dhw.seqno,
12067: eltv.hxt_premium_amount, eltv.hxt_earning_category,
12068: dhw.element_type_id
12069: FROM hxt_pay_element_types_f_ddf_v eltv,
12070: pay_element_types_f elt,
12071: hxt_det_hours_worked_f dhw
12072: WHERE dhw.tim_id = c_tim_id
12073: AND dhw.date_worked = c_date_worked
12074: AND elt.element_type_id = dhw.element_type_id

Line 13151: hxt_pay_element_types_f_ddf_v eltv,

13147: )
13148: IS
13149: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category
13150: FROM hxt_det_hours_worked hrw,
13151: hxt_pay_element_types_f_ddf_v eltv,
13152: pay_element_types_f elt
13153: WHERE elt.element_type_id = hrw.element_type_id
13154: AND hrw.date_worked BETWEEN elt.effective_start_date
13155: AND elt.effective_end_date

Line 13152: pay_element_types_f elt

13148: IS
13149: SELECT hrw.hours, hrw.element_type_id, eltv.hxt_earning_category
13150: FROM hxt_det_hours_worked hrw,
13151: hxt_pay_element_types_f_ddf_v eltv,
13152: pay_element_types_f elt
13153: WHERE elt.element_type_id = hrw.element_type_id
13154: AND hrw.date_worked BETWEEN elt.effective_start_date
13155: AND elt.effective_end_date
13156: AND eltv.element_type_id = elt.element_type_id

Line 13249: hxt_pay_element_types_f_ddf_v eltv,

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

Line 13250: pay_element_types_f elt

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