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_EARNING_RULES

Line 202: c_holiday_rule CONSTANT hxt_earning_rules.egr_type%TYPE := 'HOL';

198: RETURN BOOLEAN
199: IS
200: l_holiday_rule_found BOOLEAN;
201: l_count_holiday_rules PLS_INTEGER;
202: c_holiday_rule CONSTANT hxt_earning_rules.egr_type%TYPE := 'HOL';
203: c_no_rule CONSTANT NUMBER := 0;
204: BEGIN
205: SELECT COUNT (1)
206: INTO l_count_holiday_rules

Line 207: FROM hxt_earning_rules

203: c_no_rule CONSTANT NUMBER := 0;
204: BEGIN
205: SELECT COUNT (1)
206: INTO l_count_holiday_rules
207: FROM hxt_earning_rules
208: WHERE egp_id = p_ep_id AND egr_type = c_holiday_rule
209: AND p_date_worked between effective_start_date and effective_end_date;
210:
211: IF (l_count_holiday_rules > c_no_rule)

Line 652: FROM hxt_earning_rules er

648: -- the daily and weekly rules
649: CURSOR spc_earn_rules_cur (i_earn_policy NUMBER, i_days NUMBER)
650: IS
651: SELECT er.hours, er.element_type_id, er.days
652: FROM hxt_earning_rules er
653: WHERE er.egr_type = 'SPC'
654: AND er.days <= i_days
655: AND er.days IS NOT NULL
656: AND er.egp_id = i_earn_policy

Line 664: FROM hxt_earning_rules er

660:
661: CURSOR daily_earn_rules_cur (i_earn_policy NUMBER, i_egr_type VARCHAR2)
662: IS
663: SELECT er.hours, er.element_type_id, er.days
664: FROM hxt_earning_rules er
665: WHERE er.egr_type = i_egr_type
666: AND er.egp_id = i_earn_policy
667: AND g_date_worked BETWEEN er.effective_start_date
668: AND er.effective_end_date

Line 674: FROM hxt_earning_rules er

670:
671: CURSOR weekly_earn_rules_cur (i_earn_policy NUMBER)
672: IS
673: SELECT er.hours, er.element_type_id
674: FROM hxt_earning_rules er
675: WHERE er.egr_type = 'WKL'
676: AND er.egp_id = i_earn_policy
677: AND g_date_worked BETWEEN er.effective_start_date
678: AND er.effective_end_date

Line 957: FROM hxt_earning_rules er

953:
954: CURSOR daily_earn_rules_cur2 (i_earn_policy NUMBER)
955: IS
956: SELECT er.element_type_id
957: FROM hxt_earning_rules er
958: WHERE er.egr_type = 'DAY'
959: AND er.egp_id = i_earn_policy
960: AND g_date_worked BETWEEN er.effective_start_date
961: AND er.effective_end_date

Line 1432: FROM hxt_earning_rules er

1428: c_date_worked DATE
1429: )
1430: IS
1431: SELECT er.hours, er.element_type_id
1432: FROM hxt_earning_rules er
1433: WHERE er.egr_type = 'WKL'
1434: AND er.egp_id = c_earn_policy
1435: AND c_date_worked BETWEEN er.effective_start_date
1436: AND er.effective_end_date

Line 5032: FROM hxt_earning_rules er

5028: c_date_worked DATE
5029: )
5030: IS
5031: SELECT er.hours, er.element_type_id
5032: FROM hxt_earning_rules er
5033: WHERE er.egr_type = 'DAY'
5034: AND er.egp_id = c_earn_policy
5035: AND c_date_worked BETWEEN er.effective_start_date
5036: AND er.effective_end_date

Line 5045: FROM hxt_earning_rules er

5041: c_date_worked DATE
5042: )
5043: IS
5044: SELECT er.hours, er.element_type_id
5045: FROM hxt_earning_rules er
5046: WHERE er.egr_type = 'WKL'
5047: AND er.egp_id = c_earn_policy
5048: AND c_date_worked BETWEEN er.effective_start_date
5049: AND er.effective_end_date

Line 5831: FROM hxt_earning_rules er

5827:
5828: CURSOR get_weekly_cap (i_earn_policy NUMBER)
5829: IS
5830: SELECT er.hours
5831: FROM hxt_earning_rules er
5832: WHERE er.egr_type = 'WKL'
5833: AND er.egp_id = i_earn_policy
5834: AND g_date_worked BETWEEN er.effective_start_date
5835: AND er.effective_end_date

Line 6371: FROM hxt_earning_rules er

6367: spc_hrs_paid NUMBER
6368: )
6369: IS
6370: SELECT er.hours, er.element_type_id, er.days
6371: FROM hxt_earning_rules er
6372: WHERE er.egr_type = 'SPC'
6373: AND er.days = i_days
6374: AND er.days IS NOT NULL
6375: AND er.egp_id = i_earn_policy

Line 6384: FROM hxt_earning_rules er

6380:
6381: CURSOR daily_earning_rules (i_earn_policy NUMBER)
6382: IS
6383: SELECT er.hours, er.element_type_id
6384: FROM hxt_earning_rules er
6385: WHERE er.egr_type = 'DAY'
6386: AND er.egp_id = i_earn_policy
6387: AND g_date_worked BETWEEN er.effective_start_date
6388: AND er.effective_end_date

Line 6394: FROM hxt_earning_rules er

6390:
6391: CURSOR daily_earning_rules2 (i_earn_policy NUMBER, daily_cap NUMBER)
6392: IS
6393: SELECT er.hours, er.element_type_id
6394: FROM hxt_earning_rules er
6395: WHERE er.egr_type = 'DAY'
6396: AND er.egp_id = i_earn_policy
6397: AND g_date_worked BETWEEN er.effective_start_date
6398: AND er.effective_end_date

Line 6405: FROM hxt_earning_rules er

6401:
6402: CURSOR weekly_earning_rules (i_earn_policy NUMBER)
6403: IS
6404: SELECT er.hours, er.element_type_id
6405: FROM hxt_earning_rules er
6406: WHERE er.egr_type = 'WKL'
6407: AND er.egp_id = i_earn_policy
6408: AND g_date_worked BETWEEN er.effective_start_date
6409: AND er.effective_end_date

Line 6415: FROM hxt_earning_rules er

6411:
6412: CURSOR weekly_earning_rules2 (i_earn_policy NUMBER, weekly_cap NUMBER)
6413: IS
6414: SELECT er.hours, er.element_type_id
6415: FROM hxt_earning_rules er
6416: WHERE er.egr_type = 'WKL'
6417: AND er.egp_id = i_earn_policy
6418: AND g_date_worked BETWEEN er.effective_start_date
6419: AND er.effective_end_date