[Home] [Help]
4: -- Global variables for package
5: -- Used for parameters received that are not changed
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7: g_ep_id NUMBER;
8: g_ep_type hxt_earning_policies.fcl_earn_type%TYPE;
9: g_egt_id NUMBER;
10: g_sdf_id NUMBER;
11: g_hdp_id NUMBER;
12: g_hol_id NUMBER;
82: -- SELECT 'exist'
83: -- FROM sys.dual
84: -- WHERE EXISTS (
85: SELECT 'x'
86: FROM hxt_earn_groups erg, hxt_earning_policies egp
87: WHERE egp.ID = g_ep_id
88: AND erg.egt_id = egp.egt_id
89: AND erg.element_type_id = g_element_type_id;
90:
289: FUNCTION combine_contig_chunks
290: RETURN NUMBER;
291:
292: FUNCTION holiday_rule_found (
293: p_ep_id IN hxt_earning_policies.ID%TYPE,
294: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE
295: )
296: RETURN BOOLEAN
297: IS
860: IS
861: SELECT NVL (SUM (hrw.hours), 0)
862: FROM hxt_pay_element_types_f_ddf_v eltv,
863: pay_element_types_f elt,
864: hxt_earning_policies egp,
865: hxt_per_aei_ddf_v asmv,
866: per_assignments_f asm,
867: hxt_det_hours_worked hrw,
868: hxt_timecards tim
911: IS
912: SELECT NVL (SUM (hrw.hours), 0)
913: FROM hxt_pay_element_types_f_ddf_v eltv,
914: pay_element_types_f elt,
915: hxt_earning_policies egp,
916: hxt_per_aei_ddf_v asmv,
917: per_assignments_f asm,
918: hxt_det_hours_worked_f hrw,
919: hxt_timecards_f tim
992: SELECT NVL (SUM (hrw.hours), 0)
993: FROM hxt_pay_element_types_f_ddf_v eltv,
994: pay_element_types_f elt,
995: hxt_earn_groups erg,
996: hxt_earning_policies egp,
997: hxt_per_aei_ddf_v asmv,
998: per_assignments_f asm,
999: hxt_det_hours_worked hrw,
1000: hxt_timecards tim
1032: SELECT NVL (SUM (hrw.hours), 0)
1033: FROM hxt_pay_element_types_f_ddf_v eltv,
1034: pay_element_types_f elt,
1035: hxt_earn_groups erg,
1036: hxt_earning_policies egp,
1037: hxt_per_aei_ddf_v asmv,
1038: per_assignments_f asm,
1039: hxt_det_hours_worked_f hrw,
1040: hxt_timecards_f tim
1103: IS
1104: SELECT NVL (SUM (hrw.hours), 0)
1105: FROM hxt_pay_element_types_f_ddf_v eltv,
1106: pay_element_types_f elt,
1107: hxt_earning_policies egp,
1108: hxt_per_aei_ddf_v asmv,
1109: per_assignments_f asm,
1110: hxt_det_hours_worked hrw,
1111: hxt_timecards tim
1153: IS
1154: SELECT NVL (SUM (hrw.hours), 0)
1155: FROM hxt_pay_element_types_f_ddf_v eltv,
1156: pay_element_types_f elt,
1157: hxt_earning_policies egp,
1158: hxt_per_aei_ddf_v asmv,
1159: per_assignments_f asm,
1160: hxt_det_hours_worked_f hrw,
1161: hxt_timecards_f tim
1471: IS
1472: SELECT NVL (SUM (hrw.hours), 0)
1473: FROM hxt_pay_element_types_f_ddf_v eltv,
1474: pay_element_types_f elt,
1475: hxt_earning_policies egp,
1476: hxt_per_aei_ddf_v asmv,
1477: per_assignments_f asm,
1478: hxt_det_hours_worked hrw,
1479: hxt_timecards tim
1520: IS
1521: SELECT NVL (SUM (hrw.hours), 0)
1522: FROM hxt_pay_element_types_f_ddf_v eltv,
1523: pay_element_types_f elt,
1524: hxt_earning_policies egp,
1525: hxt_per_aei_ddf_v asmv,
1526: per_assignments_f asm,
1527: hxt_det_hours_worked_f hrw,
1528: hxt_timecards_f tim
6591: FROM hxt_det_hours_worked hrw,
6592: hxt_timecards tim,
6593: hxt_earn_groups erg,
6594: hxt_earn_group_types egt,
6595: hxt_earning_policies erp,
6596: hxt_add_elem_info_f aei
6597: WHERE tim.for_person_id = g_person_id
6598: AND hrw.tim_id = tim.ID
6599: AND erp.ID = g_ep_id
6638: FROM hxt_det_hours_worked hrw,
6639: hxt_timecards tim,
6640: hxt_earn_groups erg,
6641: hxt_earn_group_types egt,
6642: hxt_earning_policies erp,
6643: hxt_add_elem_info_f aei
6644: WHERE tim.for_person_id = g_person_id
6645: AND hrw.tim_id = tim.ID
6646: AND erp.ID = g_ep_id
6666: FROM hxt_det_hours_worked_f hrw,
6667: hxt_timecards_f tim,
6668: hxt_earn_groups erg,
6669: hxt_earn_group_types egt,
6670: hxt_earning_policies erp,
6671: hxt_add_elem_info_f aei
6672: WHERE effective_date BETWEEN hrw.effective_start_date
6673: AND hrw.effective_end_date
6674: AND effective_date BETWEEN tim.effective_start_date
8003: IS
8004: SELECT eg.element_type_id
8005: FROM hxt_earn_groups eg
8006: WHERE eg.egt_id = (SELECT ep.egt_id
8007: FROM hxt_earning_policies ep
8008: WHERE ep.ID = g_ep_id);
8009:
8010: CURSOR all_detail_hours_spc (
8011: cursor_day_worked DATE,
8031: hxt_det_hours_worked hrw,
8032: hxt_timecards tim,
8033: hxt_earn_groups erg,
8034: hxt_earn_group_types egt,
8035: hxt_earning_policies erp
8036: WHERE tim.for_person_id = g_person_id
8037: AND hrw.tim_id = tim.ID
8038: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
8039: g_start_day_of_week
8062: hxt_det_hours_worked_f hrw,
8063: hxt_timecards_f tim,
8064: hxt_earn_groups erg,
8065: hxt_earn_group_types egt,
8066: hxt_earning_policies erp
8067: WHERE tim.for_person_id = g_person_id
8068: AND hrw.tim_id = tim.ID
8069: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
8070: g_start_day_of_week
12966: THEN
12967:
12968: SELECT use_points_assigned
12969: INTO l_use_points_assigned
12970: FROM hxt_earning_policies
12971: WHERE ID = g_ep_id;
12972:
12973: ELSE
12974:
14484: l_shift_hours NUMBER;
14485: l_hdp_id NUMBER;
14486: l_hol_id NUMBER;
14487: l_sdp_id NUMBER;
14488: l_ep_type hxt_earning_policies.fcl_earn_type%TYPE;
14489: l_egt_id NUMBER;
14490: l_pep_id NUMBER;
14491: l_pip_id NUMBER;
14492: l_hcl_id NUMBER;