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 2542: FROM hxt_hour_deduction_rules thdr

2538:
2539:
2540: CURSOR get_hdp_rules IS
2541: SELECT hours, time_period
2542: FROM hxt_hour_deduction_rules thdr
2543: WHERE thdr.hdp_id = g_hdp_id
2544: AND g_date_worked BETWEEN thdr.effective_start_date
2545: AND thdr.effective_end_date
2546: ORDER BY time_period desc;

Line 2848: FROM hxt_hour_deduction_rules thdr

2844:
2845: CURSOR hdp_rule_cursor
2846: IS
2847: SELECT hours, time_period
2848: FROM hxt_hour_deduction_rules thdr
2849: WHERE thdr.hdp_id = g_hdp_id
2850: AND g_date_worked BETWEEN thdr.effective_start_date
2851: AND thdr.effective_end_date;
2852:

Line 3090: FROM hxt_hour_deduction_rules thdr

3086:
3087: CURSOR hdp_rule_cursor
3088: IS
3089: SELECT hours, time_period
3090: FROM hxt_hour_deduction_rules thdr
3091: WHERE thdr.hdp_id = g_hdp_id
3092: AND g_date_worked BETWEEN thdr.effective_start_date
3093: AND thdr.effective_end_date;
3094:

Line 3224: FROM hxt_hour_deduction_rules thdr

3220: CURSOR hdp_rules
3221: IS
3222: SELECT SUM(thdr.time_period) time_period,
3223: COUNT(*) hdp_count
3224: FROM hxt_hour_deduction_rules thdr
3225: WHERE thdr.hdp_id = g_hdp_id
3226: AND g_date_worked BETWEEN thdr.effective_start_date
3227: AND thdr.effective_end_date;
3228:

Line 4023: FROM hxt_hour_deduction_rules thdr

4019: -- hours from the hour deduction policy.
4020: CURSOR hdp_rule_cursor
4021: IS
4022: SELECT hours, time_period
4023: FROM hxt_hour_deduction_rules thdr
4024: WHERE thdr.hdp_id = g_hdp_id
4025: AND g_date_worked BETWEEN thdr.effective_start_date
4026: AND thdr.effective_end_date;
4027: