[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;
72: -- SELECT 'exist'
73: -- FROM sys.dual
74: -- WHERE EXISTS (
75: SELECT 'x'
76: FROM hxt_earn_groups erg, hxt_earning_policies egp
77: WHERE egp.ID = g_ep_id
78: AND erg.egt_id = egp.egt_id
79: AND erg.element_type_id = g_element_type_id;
80:
191: FUNCTION combine_contig_chunks
192: RETURN NUMBER;
193:
194: FUNCTION holiday_rule_found (
195: p_ep_id IN hxt_earning_policies.ID%TYPE,
196: p_date_worked IN hxt_det_hours_worked_f.date_worked%TYPE
197: )
198: RETURN BOOLEAN
199: IS
736: IS
737: SELECT NVL (SUM (hrw.hours), 0)
738: FROM hxt_pay_element_types_f_ddf_v eltv,
739: pay_element_types_f elt,
740: hxt_earning_policies egp,
741: hxt_per_aei_ddf_v asmv,
742: per_assignments_f asm,
743: hxt_det_hours_worked hrw,
744: hxt_timecards tim
805: SELECT NVL (SUM (hrw.hours), 0)
806: FROM hxt_pay_element_types_f_ddf_v eltv,
807: pay_element_types_f elt,
808: hxt_earn_groups erg,
809: hxt_earning_policies egp,
810: hxt_per_aei_ddf_v asmv,
811: per_assignments_f asm,
812: hxt_det_hours_worked hrw,
813: hxt_timecards tim
858: IS
859: SELECT NVL (SUM (hrw.hours), 0)
860: FROM hxt_pay_element_types_f_ddf_v eltv,
861: pay_element_types_f elt,
862: hxt_earning_policies egp,
863: hxt_per_aei_ddf_v asmv,
864: per_assignments_f asm,
865: hxt_det_hours_worked hrw,
866: hxt_timecards tim
1087: IS
1088: SELECT NVL (SUM (hrw.hours), 0)
1089: FROM hxt_pay_element_types_f_ddf_v eltv,
1090: pay_element_types_f elt,
1091: hxt_earning_policies egp,
1092: hxt_per_aei_ddf_v asmv,
1093: per_assignments_f asm,
1094: hxt_det_hours_worked hrw,
1095: hxt_timecards tim
5057: FROM hxt_det_hours_worked hrw,
5058: hxt_timecards tim,
5059: hxt_earn_groups erg,
5060: hxt_earn_group_types egt,
5061: hxt_earning_policies erp,
5062: hxt_add_elem_info_f aei
5063: WHERE tim.for_person_id = g_person_id
5064: AND hrw.tim_id = tim.ID
5065: AND erp.ID = g_ep_id
5097: FROM hxt_det_hours_worked hrw,
5098: hxt_timecards tim,
5099: hxt_earn_groups erg,
5100: hxt_earn_group_types egt,
5101: hxt_earning_policies erp,
5102: hxt_add_elem_info_f aei
5103: WHERE tim.for_person_id = g_person_id
5104: AND hrw.tim_id = tim.ID
5105: AND erp.ID = g_ep_id
6424: IS
6425: SELECT eg.element_type_id
6426: FROM hxt_earn_groups eg
6427: WHERE eg.egt_id = (SELECT ep.egt_id
6428: FROM hxt_earning_policies ep
6429: WHERE ep.ID = g_ep_id);
6430:
6431: CURSOR all_detail_hours_spc (
6432: cursor_day_worked DATE,
6447: hxt_det_hours_worked hrw,
6448: hxt_timecards tim,
6449: hxt_earn_groups erg,
6450: hxt_earn_group_types egt,
6451: hxt_earning_policies erp
6452: WHERE tim.for_person_id = g_person_id
6453: AND hrw.tim_id = tim.ID
6454: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
6455: g_start_day_of_week
11243: --MHANDA Determine whether the rules to be applied use the
11244: --points counter.
11245: SELECT use_points_assigned
11246: INTO l_use_points_assigned
11247: FROM hxt_earning_policies
11248: WHERE ID = g_ep_id;
11249:
11250: IF g_debug
11251: THEN
12610: l_shift_hours NUMBER;
12611: l_hdp_id NUMBER;
12612: l_hol_id NUMBER;
12613: l_sdp_id NUMBER;
12614: l_ep_type hxt_earning_policies.fcl_earn_type%TYPE;
12615: l_egt_id NUMBER;
12616: l_pep_id NUMBER;
12617: l_pip_id NUMBER;
12618: l_hcl_id NUMBER;