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_HOUR_DEDUCTION_RULES

Line 2032: FROM hxt_hour_deduction_rules thdr

2028:
2029: CURSOR hdp_rule_cursor
2030: IS
2031: SELECT hours, time_period
2032: FROM hxt_hour_deduction_rules thdr
2033: WHERE thdr.hdp_id = g_hdp_id
2034: AND g_date_worked BETWEEN thdr.effective_start_date
2035: AND thdr.effective_end_date;
2036:

Line 2149: FROM hxt_hour_deduction_rules thdr

2145: CURSOR hdp_rules
2146: IS
2147: SELECT SUM(thdr.time_period) time_period,
2148: COUNT(*) hdp_count
2149: FROM hxt_hour_deduction_rules thdr
2150: WHERE thdr.hdp_id = g_hdp_id
2151: AND g_date_worked BETWEEN thdr.effective_start_date
2152: AND thdr.effective_end_date;
2153:

Line 2865: FROM hxt_hour_deduction_rules thdr

2861: -- hours from the hour deduction policy.
2862: CURSOR hdp_rule_cursor
2863: IS
2864: SELECT hours, time_period
2865: FROM hxt_hour_deduction_rules thdr
2866: WHERE thdr.hdp_id = g_hdp_id
2867: AND g_date_worked BETWEEN thdr.effective_start_date
2868: AND thdr.effective_end_date;
2869: