APPS.HXT_TIME_DETAIL dependencies on HXT_EARNING_RULES

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

296: RETURN BOOLEAN
297: IS
298: l_holiday_rule_found BOOLEAN;
299: l_count_holiday_rules PLS_INTEGER;
300: c_holiday_rule CONSTANT hxt_earning_rules.egr_type%TYPE := 'HOL';
301: c_no_rule CONSTANT NUMBER := 0;
302: BEGIN
303: SELECT COUNT (1)
304: INTO l_count_holiday_rules

Line 305: FROM hxt_earning_rules

301: c_no_rule CONSTANT NUMBER := 0;
302: BEGIN
303: SELECT COUNT (1)
304: INTO l_count_holiday_rules
305: FROM hxt_earning_rules
306: WHERE egp_id = p_ep_id AND egr_type = c_holiday_rule
307: AND p_date_worked between effective_start_date and effective_end_date;
308:
309: IF (l_count_holiday_rules > c_no_rule)

Line 771: FROM hxt_earning_rules er

767: -- the daily and weekly rules
768: CURSOR spc_earn_rules_cur (i_earn_policy NUMBER, i_days NUMBER)
769: IS
770: SELECT er.hours, er.element_type_id, er.days
771: FROM hxt_earning_rules er
772: WHERE er.egr_type = 'SPC'
773: AND er.days <= i_days
774: AND er.days IS NOT NULL
775: AND er.egp_id = i_earn_policy

Line 783: FROM hxt_earning_rules er

779:
780: CURSOR daily_earn_rules_cur (i_earn_policy NUMBER, i_egr_type VARCHAR2)
781: IS
782: SELECT er.hours, er.element_type_id, er.days
783: FROM hxt_earning_rules er
784: WHERE er.egr_type = i_egr_type
785: AND er.egp_id = i_earn_policy
786: AND g_date_worked BETWEEN er.effective_start_date
787: AND er.effective_end_date

Line 793: FROM hxt_earning_rules er

789:
790: CURSOR weekly_earn_rules_cur (i_earn_policy NUMBER)
791: IS
792: SELECT er.hours, er.element_type_id
793: FROM hxt_earning_rules er
794: WHERE er.egr_type = 'WKL'
795: AND er.egp_id = i_earn_policy
796: AND g_date_worked BETWEEN er.effective_start_date
797: AND er.effective_end_date

Line 1210: hxt_earning_rules er

1206: IS
1207: select NVL(SUM(det.hours),0)
1208: from hxt_det_hours_worked_f det,
1209: hxt_sum_hours_worked_f sum,
1210: hxt_earning_rules er
1211: WHERE det.date_worked = g_date_worked
1212: AND sum.id = det.parent_id
1213: AND sum.element_type_id IS NULL
1214: AND det.tim_id = g_tim_id

Line 1330: FROM hxt_earning_rules er

1326:
1327: CURSOR daily_earn_rules_cur2 (i_earn_policy NUMBER)
1328: IS
1329: SELECT er.element_type_id
1330: FROM hxt_earning_rules er
1331: WHERE er.egr_type = 'DAY'
1332: AND er.egp_id = i_earn_policy
1333: AND g_date_worked BETWEEN er.effective_start_date
1334: AND er.effective_end_date

Line 1944: FROM hxt_earning_rules er

1940: c_date_worked DATE
1941: )
1942: IS
1943: SELECT er.hours, er.element_type_id
1944: FROM hxt_earning_rules er
1945: WHERE er.egr_type = 'WKL'
1946: AND er.egp_id = c_earn_policy
1947: AND c_date_worked BETWEEN er.effective_start_date
1948: AND er.effective_end_date

Line 6566: FROM hxt_earning_rules er

6562: c_date_worked DATE
6563: )
6564: IS
6565: SELECT er.hours, er.element_type_id
6566: FROM hxt_earning_rules er
6567: WHERE er.egr_type = 'DAY'
6568: AND er.egp_id = c_earn_policy
6569: AND c_date_worked BETWEEN er.effective_start_date
6570: AND er.effective_end_date

Line 6579: FROM hxt_earning_rules er

6575: c_date_worked DATE
6576: )
6577: IS
6578: SELECT er.hours, er.element_type_id
6579: FROM hxt_earning_rules er
6580: WHERE er.egr_type = 'WKL'
6581: AND er.egp_id = c_earn_policy
6582: AND c_date_worked BETWEEN er.effective_start_date
6583: AND er.effective_end_date

Line 7410: FROM hxt_earning_rules er

7406:
7407: CURSOR get_weekly_cap (i_earn_policy NUMBER)
7408: IS
7409: SELECT er.hours
7410: FROM hxt_earning_rules er
7411: WHERE er.egr_type = 'WKL'
7412: AND er.egp_id = i_earn_policy
7413: AND g_date_worked BETWEEN er.effective_start_date
7414: AND er.effective_end_date

Line 7950: FROM hxt_earning_rules er

7946: spc_hrs_paid NUMBER
7947: )
7948: IS
7949: SELECT er.hours, er.element_type_id, er.days
7950: FROM hxt_earning_rules er
7951: WHERE er.egr_type = 'SPC'
7952: AND er.days = i_days
7953: AND er.days IS NOT NULL
7954: AND er.egp_id = i_earn_policy

Line 7963: FROM hxt_earning_rules er

7959:
7960: CURSOR daily_earning_rules (i_earn_policy NUMBER)
7961: IS
7962: SELECT er.hours, er.element_type_id
7963: FROM hxt_earning_rules er
7964: WHERE er.egr_type = 'DAY'
7965: AND er.egp_id = i_earn_policy
7966: AND g_date_worked BETWEEN er.effective_start_date
7967: AND er.effective_end_date

Line 7973: FROM hxt_earning_rules er

7969:
7970: CURSOR daily_earning_rules2 (i_earn_policy NUMBER, daily_cap NUMBER)
7971: IS
7972: SELECT er.hours, er.element_type_id
7973: FROM hxt_earning_rules er
7974: WHERE er.egr_type = 'DAY'
7975: AND er.egp_id = i_earn_policy
7976: AND g_date_worked BETWEEN er.effective_start_date
7977: AND er.effective_end_date

Line 7984: FROM hxt_earning_rules er

7980:
7981: CURSOR weekly_earning_rules (i_earn_policy NUMBER)
7982: IS
7983: SELECT er.hours, er.element_type_id
7984: FROM hxt_earning_rules er
7985: WHERE er.egr_type = 'WKL'
7986: AND er.egp_id = i_earn_policy
7987: AND g_date_worked BETWEEN er.effective_start_date
7988: AND er.effective_end_date

Line 7994: FROM hxt_earning_rules er

7990:
7991: CURSOR weekly_earning_rules2 (i_earn_policy NUMBER, weekly_cap NUMBER)
7992: IS
7993: SELECT er.hours, er.element_type_id
7994: FROM hxt_earning_rules er
7995: WHERE er.egr_type = 'WKL'
7996: AND er.egp_id = i_earn_policy
7997: AND g_date_worked BETWEEN er.effective_start_date
7998: AND er.effective_end_date

Line 11859: FROM hxt_earning_rules er,

11855: CURSOR get_reg_elements(p_ep_id IN NUMBER,
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

Line 15056: hxt_earning_rules er

15052: IS
15053: select NVL(SUM(det.hours),0)
15054: from hxt_det_hours_worked_f det,
15055: hxt_sum_hours_worked_f sum,
15056: hxt_earning_rules er
15057: WHERE det.date_worked = g_date_worked
15058: AND sum.id = det.parent_id
15059: AND sum.element_type_id IS NULL
15060: AND det.tim_id = g_tim_id